CREATE TABLE `psi_courses` (
  `course_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `course_cat_id` bigint(20) unsigned DEFAULT '0',
  `course_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `course_yearcount` int(11) unsigned DEFAULT '4',
  `region_id` bigint(20) unsigned DEFAULT '6',
  `synched` tinyint(1) unsigned DEFAULT '0',
  `sync_date` datetime DEFAULT NULL,
  `date_encoded` datetime DEFAULT NULL,
  `last_updated` datetime DEFAULT NULL,
  `encoder` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `updater` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  PRIMARY KEY (`course_id`)
) ENGINE=InnoDB AUTO_INCREMENT=126 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO psi_courses (course_id, course_cat_id, course_name, course_yearcount, region_id, synched, sync_date, date_encoded, last_updated, encoder, updater) VALUES
(1, 1, 'Veterinary Medicine', 6, 6, 0, NULL, NULL, NULL, '', ''),
(2, 1, 'Agricultural and Biosystems Engineering', 5, 6, 0, NULL, NULL, NULL, '', ''),
(3, 1, 'Agricultural Chemistry', 5, 6, 0, NULL, NULL, NULL, '', ''),
(4, 1, 'Agricultural Engineering', 5, 6, 0, NULL, NULL, NULL, '', ''),
(5, 1, 'Chemical Engineering', 5, 6, 0, NULL, NULL, NULL, '', ''),
(6, 1, 'Civil Engineering', 5, 6, 0, NULL, NULL, NULL, '', ''),
(7, 1, 'Computer Engineering', 5, 6, 0, NULL, NULL, NULL, '', ''),
(8, 1, 'Electornics and Communication Engineering', 5, 6, 0, NULL, NULL, NULL, '', ''),
(9, 1, 'Electrical Engineering', 5, 6, 0, NULL, NULL, NULL, '', ''),
(10, 1, 'Electronics and Communications Engineering', 5, 6, 0, NULL, NULL, NULL, '', ''),
(11, 1, 'Food Engineering', 5, 6, 0, NULL, NULL, NULL, '', ''),
(12, 1, 'Forest Product Engineering', 5, 6, 0, NULL, NULL, NULL, '', ''),
(13, 1, 'Industrial Engineering', 5, 6, 0, NULL, NULL, NULL, '', ''),
(14, 1, 'Mechanical Engineering', 5, 6, 0, NULL, NULL, NULL, '', ''),
(15, 1, 'Petroleum Engineering', 5, 6, 0, NULL, NULL, NULL, '', ''),
(16, 1, 'Agricultural Biotechnology', 4, 6, 0, NULL, NULL, NULL, '', ''),
(17, 1, 'Agriculture', 4, 6, 0, NULL, NULL, NULL, '', ''),
(18, 1, 'Applied Mathematics', 4, 6, 0, NULL, NULL, NULL, '', ''),
(19, 1, 'Applied Physics', 4, 6, 0, NULL, NULL, NULL, '', ''),
(20, 1, 'Biology', 4, 6, 0, NULL, NULL, NULL, '', ''),
(21, 1, 'Chemistry', 4, 6, 0, NULL, NULL, NULL, '', ''),
(22, 1, 'Computer Science', 4, 6, 0, NULL, NULL, NULL, '', ''),
(23, 1, 'Environmental Science', 4, 6, 0, NULL, NULL, NULL, '', ''),
(24, 1, 'Fisheries', 4, 6, 0, NULL, NULL, NULL, '', ''),
(25, 1, 'Food & Nutrition & Diedetics', 4, 6, 0, NULL, NULL, NULL, '', ''),
(26, 1, 'Food and Beverage Technology', 4, 6, 0, NULL, NULL, NULL, '', ''),
(27, 1, 'Food Technology', 4, 6, 0, NULL, NULL, NULL, '', ''),
(28, 1, 'Forestry', 4, 6, 0, NULL, NULL, NULL, '', ''),
(29, 1, 'Information Technology', 4, 6, 0, NULL, NULL, NULL, '', ''),
(30, 1, 'Marine Biology', 4, 6, 0, NULL, NULL, NULL, '', ''),
(31, 1, 'Mathematics', 4, 6, 0, NULL, NULL, NULL, '', ''),
(32, 1, 'Mathematics & Science Teaching - Chemistry', 4, 6, 0, NULL, NULL, NULL, '', ''),
(33, 1, 'Mathematics & Science Teaching - Mathematics', 4, 6, 0, NULL, NULL, NULL, '', ''),
(34, 1, 'Mathematics & Science Teaching - Physics', 4, 6, 0, NULL, NULL, NULL, '', ''),
(35, 1, 'Mathematics Teaching', 4, 6, 0, NULL, NULL, NULL, '', ''),
(36, 1, 'Nutrition', 4, 6, 0, NULL, NULL, NULL, '', ''),
(37, 1, 'Nutrition & Dietetics', 4, 6, 0, NULL, NULL, NULL, '', ''),
(38, 1, 'Physics', 4, 6, 0, NULL, NULL, NULL, '', ''),
(39, 1, 'Physics Teaching', 4, 6, 0, NULL, NULL, NULL, '', ''),
(40, 1, 'Secondary Education major in Biological Science', 4, 6, 0, NULL, NULL, NULL, '', ''),
(41, 1, 'Secondary Education major in Biology', 4, 6, 0, NULL, NULL, NULL, '', ''),
(42, 1, 'Secondary Education major in Chemistry', 4, 6, 0, NULL, NULL, NULL, '', ''),
(43, 1, 'Secondary Education major in Mathematics', 4, 6, 0, NULL, NULL, NULL, '', ''),
(44, 1, 'Secondary Education major in Physical Science', 4, 6, 0, NULL, NULL, NULL, '', ''),
(45, 1, 'Secondary Education major in Physics', 4, 6, 0, NULL, NULL, NULL, '', ''),
(46, 1, 'Statistics', 4, 6, 0, NULL, NULL, NULL, '', ''),
(47, 1, 'Technical Education major in Electronics Techonolo', 4, 6, 0, NULL, NULL, NULL, '', ''),
(48, 2, 'Agricultural Technology', 3, 6, 0, NULL, NULL, NULL, '', ''),
(49, 2, 'Associate in Computer Science', 3, 6, 0, NULL, NULL, NULL, '', ''),
(50, 2, 'Associate in Computer Technology', 3, 6, 0, NULL, NULL, NULL, '', ''),
(51, 2, 'Automotive Engieering Technology', 3, 6, 0, NULL, NULL, NULL, '', ''),
(52, 2, 'Automotive Technology', 3, 6, 0, NULL, NULL, NULL, '', ''),
(53, 2, 'Certificate in Forestry', 3, 6, 0, NULL, NULL, NULL, '', ''),
(54, 2, 'Civil Technology', 3, 6, 0, NULL, NULL, NULL, '', ''),
(55, 2, 'Computer Engineering Technology', 3, 6, 0, NULL, NULL, NULL, '', ''),
(56, 2, 'Computer Information Technology', 3, 6, 0, NULL, NULL, NULL, '', ''),
(57, 2, 'Computer System & Programming', 3, 6, 0, NULL, NULL, NULL, '', ''),
(58, 2, 'Computer Technology', 3, 6, 0, NULL, NULL, NULL, '', ''),
(59, 2, 'Diploma in Agricultural Technology', 3, 6, 0, NULL, NULL, NULL, '', ''),
(60, 2, 'Electrical Engineering Technology', 3, 6, 0, NULL, NULL, NULL, '', ''),
(61, 2, 'Electrical Technology', 3, 6, 0, NULL, NULL, NULL, '', ''),
(62, 2, 'Electronics and Communication Engineering Technolo', 3, 6, 0, NULL, NULL, NULL, '', ''),
(63, 2, 'Electronics Engineering Technology', 3, 6, 0, NULL, NULL, NULL, '', ''),
(64, 2, 'Electronics Service Engineering Technology', 3, 6, 0, NULL, NULL, NULL, '', ''),
(65, 2, 'Electronics Technology', 3, 6, 0, NULL, NULL, NULL, '', ''),
(66, 2, 'Fish Technology', 3, 6, 0, NULL, NULL, NULL, '', ''),
(67, 2, 'Food and Beverage Engineering Technology', 3, 6, 0, NULL, NULL, NULL, '', ''),
(68, 2, 'Food and Beverage Technology', 3, 6, 0, NULL, NULL, NULL, '', ''),
(69, 2, 'Food Technology', 3, 6, 0, NULL, NULL, NULL, '', ''),
(70, 2, 'Industrial Design Technology', 3, 6, 0, NULL, NULL, NULL, '', ''),
(71, 2, 'Industrial Engineering Technology', 3, 6, 0, NULL, NULL, NULL, '', ''),
(72, 2, 'Industrial Technology', 3, 6, 0, NULL, NULL, NULL, '', ''),
(73, 2, 'Information & Communication Engineering Technology', 3, 6, 0, NULL, NULL, NULL, '', ''),
(74, 2, 'Information & Communication Technology', 3, 6, 0, NULL, NULL, NULL, '', ''),
(75, 2, 'Information Technology', 3, 6, 0, NULL, NULL, NULL, '', ''),
(76, 2, 'Instrumentation and Control Engineering Technology', 3, 6, 0, NULL, NULL, NULL, '', ''),
(77, 2, 'Mechanical and Production Engineering Technology', 3, 6, 0, NULL, NULL, NULL, '', ''),
(78, 2, 'Mechanical Engineering Technology', 3, 6, 0, NULL, NULL, NULL, '', ''),
(79, 2, 'Mechanical Technology', 3, 6, 0, NULL, NULL, NULL, '', ''),
(80, 3, 'Agricultural Engineering Technology', 2, 6, 0, NULL, NULL, NULL, '', ''),
(81, 3, 'Agricultural Technology', 2, 6, 0, NULL, NULL, NULL, '', ''),
(82, 3, 'Associate in Computer Science', 2, 6, 0, NULL, NULL, NULL, '', ''),
(83, 3, 'Associate in Computer Technology', 2, 6, 0, NULL, NULL, NULL, '', ''),
(84, 3, 'Associate in Information Technology', 2, 6, 0, NULL, NULL, NULL, '', ''),
(85, 3, 'Associate in System Technology', 2, 6, 0, NULL, NULL, NULL, '', ''),
(86, 3, 'Automotive Technology', 2, 6, 0, NULL, NULL, NULL, '', ''),
(87, 3, 'Certificate in Forestry', 2, 6, 0, NULL, NULL, NULL, '', ''),
(88, 3, 'Certificate in Information Management', 2, 6, 0, NULL, NULL, NULL, '', ''),
(89, 3, 'Computer Engineering Technology', 2, 6, 0, NULL, NULL, NULL, '', ''),
(90, 3, 'Computer Information Management', 2, 6, 0, NULL, NULL, NULL, '', ''),
(91, 3, 'Computer Information Technology', 2, 6, 0, NULL, NULL, NULL, '', ''),
(92, 3, 'Computer Operation Programming', 2, 6, 0, NULL, NULL, NULL, '', ''),
(93, 3, 'Computer Programming ', 2, 6, 0, NULL, NULL, NULL, '', ''),
(94, 3, 'Computer Programming and Operation', 2, 6, 0, NULL, NULL, NULL, '', ''),
(95, 3, 'Computer System Design & Programming', 2, 6, 0, NULL, NULL, NULL, '', ''),
(96, 3, 'Computer System Technology', 2, 6, 0, NULL, NULL, NULL, '', ''),
(97, 3, 'Computer Technology', 2, 6, 0, NULL, NULL, NULL, '', ''),
(98, 3, 'Diploma in Agricultural Technology', 2, 6, 0, NULL, NULL, NULL, '', ''),
(99, 3, 'Diploma in Electrical Technology', 2, 6, 0, NULL, NULL, NULL, '', ''),
(100, 3, 'Electrical Engineering Technology', 2, 6, 0, NULL, NULL, NULL, '', ''),
(101, 3, 'Electrical System Technician', 2, 6, 0, NULL, NULL, NULL, '', ''),
(102, 3, 'Electrical Technology', 2, 6, 0, NULL, NULL, NULL, '', ''),
(103, 3, 'Electromechanics', 2, 6, 0, NULL, NULL, NULL, '', ''),
(104, 3, 'Electronics and Communication Engineering Technolo', 2, 6, 0, NULL, NULL, NULL, '', ''),
(105, 3, 'Electronics Communication Technology', 2, 6, 0, NULL, NULL, NULL, '', ''),
(106, 3, 'Electronics Engineering Technology', 2, 6, 0, NULL, NULL, NULL, '', ''),
(107, 3, 'Electronics Technology', 2, 6, 0, NULL, NULL, NULL, '', ''),
(108, 3, 'Food and Beverage Technology', 2, 6, 0, NULL, NULL, NULL, '', ''),
(109, 3, 'Food Technology', 2, 6, 0, NULL, NULL, NULL, '', ''),
(110, 3, 'Forest Ranger', 2, 6, 0, NULL, NULL, NULL, '', ''),
(111, 3, 'Forest Technology', 2, 6, 0, NULL, NULL, NULL, '', ''),
(112, 3, 'Information Technology', 2, 6, 0, NULL, NULL, NULL, '', ''),
(113, 3, 'Mechanical Technology', 2, 6, 0, NULL, NULL, NULL, '', ''),
(121, 1, 'General Engineering', 5, 6, 0, NULL, NULL, NULL, '', ''),
(122, 1, 'Mathematics &amp; Science Teaching', 4, 6, 0, NULL, NULL, NULL, '', ''),
(123, 1, 'Electronics Engineering', 5, 6, 0, NULL, NULL, NULL, '', ''),
(124, 1, 'Industrial Engineering', 5, 6, 0, NULL, NULL, NULL, '', ''),
(125, 1, 'General Engineering', 0, 6, 0, NULL, NULL, NULL, '', '');
