text: -- --------------------------------------------------------
  -- Host:                         127.0.0.1
  -- Server version:               5.7.9 - MySQL Community Server (GPL)
  -- Server OS:                    Win64
  -- HeidiSQL Version:             9.2.0.4976
  -- --------------------------------------------------------
  
  /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  /*!40101 SET NAMES utf8mb4 */;
  /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  -- Dumping data for table intern_portal.courses: ~0 rows (approximately)
  /*!40000 ALTER TABLE `courses` DISABLE KEYS */;
  INSERT INTO `courses` (`id`, `course_code`, `course_name`, `duration`, `stage_caption`) VALUES
  	(1, 'ab241', 'Bachelors of Architectural Technology', 6, 'year'),
  	(2, 'ab242', 'BSc Landscape Architecture', 4, 'year'),
  	(3, 'ab243', 'construction management', 4, 'year'),
  	(4, 'ab244', 'Bachelor of Quantity Surveying', 4, 'year'),
  	(5, 'ab343', 'Msc Construction Project Management', 2, 'year'),
  	(6, 'aba2507', 'Bachelor in Architecture', 5, 'Year'),
  	(7, 'ag221', 'BSc Food Science and Technology', 4, 'year'),
  	(8, 'ag222', 'BSc Food Science and Nutrition', 4, 'year'),
  	(9, 'ag223', 'BSc Human Nutrition and Dietetics', 4, 'year'),
  	(10, 'ag224', 'BSc. Food Service and Hospitality management', 4, 'year'),
  	(11, 'ag231', 'BSc. Horticulture', 4, 'year'),
  	(12, 'ag237', 'BSc. Agribusiness Economics and Food Industrial Management', 4, 'year'),
  	(13, 'ag238', 'BSc. Agriculture', 4, 'year'),
  	(14, 'ag241', 'BSc. Land Resource Planning and Management', 4, 'year'),
  	(15, 'ag242', 'Bsc.Animal Health Production and Processing', 4, 'year'),
  	(16, 'ag251', 'BSc. Agricultural Economics and Rural Development', 4, 'year'),
  	(17, 'ag252', 'BSc. Agribusiness Management & Enterprise Development', 4, 'year'),
  	(18, 'ag253', 'BSc Agribusiness Economics', 4, 'year'),
  	(19, 'bit', 'Bachelor of Science Information Technology', 4, 'YEAR'),
  	(20, 'cit', 'Certificate in Information Technology', 3, 'Months'),
  	(21, 'cs', 'BSc. Computer Science', 4, 'Year'),
  	(22, 'cs281', 'Bachelor of Science in Computer Science', 4, 'Year'),
  	(23, 'cs282', 'Bsc.Computer Technology', 4, 'Year'),
  	(24, 'cs381', 'MSc. Software Engineering 381', 2, 'year'),
  	(25, 'cs382', 'MSc. Computer Systems', 2, 'year'),
  	(26, 'cs385', 'Msc. Information Technology', 2, 'Year'),
  	(27, 'cs481', 'PhD. Information Technology', 3, 'year'),
  	(28, 'cs482', 'PhD. Computer Science', 3, 'year'),
  	(29, 'ct', 'BSc. Computer Technology', 4, 'Year'),
  	(30, 'dit', 'Diploma in Information Technology', 2, 'Year'),
  	(31, 'eet31', 'Msc Energy Technology', 2, 'Year'),
  	(32, 'eet32', 'Msc. Energy Technology', 2, 'year'),
  	(33, 'en251', 'Bsc Civil Engineering', 5, 'Year'),
  	(34, 'en264', 'Agricultural and Biosystems Engineering', 5, 'Year'),
  	(35, 'en271', 'BSc Electrical & Electronics Engineering', 5, 'Year'),
  	(36, 'en272', 'Bsc Electronic and Computer Engineering', 5, 'Year'),
  	(37, 'en273', 'Telecommunications Information Engineering', 6, 'Year'),
  	(38, 'en283', 'BSc Geospatial Information Science', 4, 'Year'),
  	(39, 'en291', 'BSc Mechanical Engineering', 5, 'year'),
  	(40, 'en292', 'BSc. Mechatronics Engineering', 5, 'year'),
  	(41, 'en293', 'BSc Mining and Mineral Processing Engineering', 5, 'Year'),
  	(42, 'en295', 'BSc. Marine Engineering', 5, 'year'),
  	(43, 'en392', 'MSc Mechatronic Engineering', 2, 'Year'),
  	(44, 'hbd212', 'bachelor of business information technology', 4, 'year'),
  	(45, 'hd111', 'Diploma in Purchasing and Supplies Management', 4, 'Stages'),
  	(46, 'hd112', 'Diploma in Human Resource Management HD112', 2, 'year'),
  	(47, 'hd132', 'Diploma in Business Information Technology', 4, 'Stages'),
  	(48, 'hd211', 'Bachelor of Procurement and Contract Management', 4, 'Year'),
  	(49, 'hd212', 'Bachelor of Supply Chain Management', 4, 'Year'),
  	(50, 'hd213', 'Bachelor of Human Resource Management', 4, 'year'),
  	(51, 'hd214', 'Bachelor of  Entrepreneurship', 4, 'Year'),
  	(52, 'hd215', 'Bachelor  in Project Management', 4, 'Year'),
  	(53, 'hd221', 'Bachelor of Mass Communication', 4, 'year'),
  	(54, 'hd224', 'Bachelor of Development Studies', 4, 'year'),
  	(55, 'hd231', 'Bachelor of Commerce', 4, 'Year'),
  	(56, 'hd232', 'Bachelor of Business Information Technology', 4, 'Year'),
  	(57, 'hd241', 'Bachelor of Economics', 4, '2015/2016'),
  	(58, 'hd311', 'MSc Procurement and Logistics', 2, 'year'),
  	(59, 'hd312', 'MSC HUMAN RESOURCE MANAGEMENT', 2, 'YEAR'),
  	(60, 'hd313', 'Msc.Entreprenuership', 2, 'Year'),
  	(61, 'hd314', 'MSc ICT Policy Regulation', 2, 'year'),
  	(62, 'hd317', 'MSc. in Project Management', 2, 'year'),
  	(63, 'hd318', 'Msc. Strategic Management', 3, 'year'),
  	(64, 'hd321', 'MSc in Mass Communication', 2, '2015/2016'),
  	(65, 'hd333', 'Masters of Business Administration', 2, 'Year'),
  	(66, 'hd339', 'Master of Finance and Accounting', 2, 'year'),
  	(67, 'hd343', 'MSc. Business Information Technology', 2, 'year'),
  	(68, 'hd411', 'PHD Supply Chain Management', 4, '2015/2016'),
  	(69, 'hd412', 'PhD Human Resource Management', 4, 'Year'),
  	(70, 'hd413', 'PHD Entrepreneurship', 3, 'year'),
  	(71, 'hd417', 'PhD Project Management', 3, 'Year'),
  	(72, 'hd418', 'PhD in Strategic Management', 3, 'Year'),
  	(73, 'hd421', 'PhD Mass Communication', 3, 'Year'),
  	(74, 'hd433', 'PhD Business Administration', 3, 'Year'),
  	(75, 'hd435', 'PhD FINANCE', 3, 'year'),
  	(76, 'hdb112', 'Diploma in Business Information Technology hdb112', 2, 'year'),
  	(77, 'hdb113', 'Diploma in Business Administration', 2, 'year'),
  	(78, 'hdb211', 'Bachelor of Commerce New', 4, 'year'),
  	(79, 'hdb212', 'bachelor of business information technology', 4, 'year'),
  	(80, 'hdb221', 'Bachelor of Science in Economics', 3, 'year'),
  	(81, 'hdb318', 'Post-Graduate Diploma in Strategic Management', 1, 'Year'),
  	(82, 'hdc111', 'Diploma in Mass Communication', 2, '2015/2016'),
  	(83, 'hdc114', 'Diploma in Public Relations', 2, 'years'),
  	(84, 'hdc211', 'Bachelor of Mass Communication', 4, 'year'),
  	(85, 'hdc212', 'Bachelor of Journalism', 4, 'Year'),
  	(86, 'hdc213', 'B.Sc. Corporate Communication and Management', 4, 'Years'),
  	(87, 'hdc221', 'Bachelor of Development Studies', 4, 'Year'),
  	(88, 'hdc222', 'BSc. Public Management and Development Studies', 4, 'year'),
  	(89, 'hdc223', 'BSc. Community Development and Environment', 4, 'year'),
  	(90, 'hde', 'BSC. ECONOMICS', 4, 'YEAR'),
  	(91, 'hde 111', 'Diploma in Purchasing and Supplies management', 2, 'year'),
  	(92, 'hde111', 'Diploma in Purchasing and Supplies management', 2, 'year'),
  	(93, 'hde121', 'Diploma in Human Resource Management', 2, 'year'),
  	(94, 'hde211', 'Bachelor of procurement & contract management', 4, '1'),
  	(95, 'hde212', 'Bachelor of Supply Chain Management', 4, 'Year'),
  	(96, 'hde221', 'Bachelor of Science in Human Resource Management', 4, 'Year'),
  	(97, 'hde223', 'Bachelor of Entrepreneurship', 4, 'year'),
  	(98, 'hde224', 'BSc. Project Management', 4, 'YEAR'),
  	(99, 'hde225', 'BSc Strategic Management', 4, 'Year'),
  	(100, 'hde226', 'Bsc Innovation and Technology Management', 4, 'year'),
  	(101, 'hps211', 'BSc Procurement and Contract Management', 4, 'Year'),
  	(102, 'msc', 'Msc. Masters in Information Technology', 2, 'YEAR'),
  	(103, 'sc200', 'Bachelor of Science General', 4, 'Year'),
  	(104, 'sc222', 'BSc Microbiology', 4, 'Year'),
  	(105, 'sc224', 'BSc. Biotechnology', 4, 'YEAR'),
  	(106, 'sc232', 'Bsc. Analytical Chemistry', 4, 'Year'),
  	(107, 'sc242', 'BSc Control and Instrumentation', 4, 'Year'),
  	(108, 'sc281', 'acturial science', 4, 'year'),
  	(109, 'scb231', 'Bachelor of Science in Biotechnology', 4, 'Year'),
  	(110, 'scb232', 'Genomic Sciences', 4, 'year'),
  	(111, 'scb236', 'B.Sc. Applied Biology', 4, 'year'),
  	(112, 'scg200', 'Bachelor of Science', 4, 'year'),
  	(113, 'scm211', 'BSc. Maths and Computer Science', 4, 'year'),
  	(114, 'scm212', 'BSc. Acturial Science', 4, 'year'),
  	(115, 'scm213', 'BSc Biostatistics', 4, 'year'),
  	(116, 'scm214', 'Bsc Financial Engineering', 4, 'Year'),
  	(117, 'scm215', 'Bsc Statistics', 4, 'Year'),
  	(118, 'scm216', 'BSc. Industrial Mathematics', 4, 'year'),
  	(119, 'scp222', 'BSc. Analytical Chemistry', 4, 'year'),
  	(120, 'scp223', 'BSc Industrial Chemistry', 4, '2015/2016'),
  	(121, 'scp224', 'BSc Control and Instrumentation', 4, '2015/2016'),
  	(122, 'sct001', 'Certificate in Information Technology', 1, 'year'),
  	(123, 'sct021', 'Certificate in Information Technology SCT021', 1, 'year'),
  	(124, 'sct121', 'Diploma in Information Technology New', 2, 'year'),
  	(125, 'sct211', 'BSc. Computer Science   SCT211', 4, 'year'),
  	(126, 'sct212', 'BSc Computer Technology', 4, 'Year'),
  	(127, 'sct22', 'Bachelor of Science in Information Technology', 4, 'Year'),
  	(128, 'sct221', 'sct221 Bachelor of Science in Information Technology', 4, 'Year'),
  	(129, 'sct222', 'Business Computing', 4, 'Year'),
  	(130, 'sct311', 'MSc. Software Engineering', 2, 'year'),
  	(131, 'sct312', 'MSc. Computer Systems', 2, 'year'),
  	(132, 'sct322', 'Msc IT Integration in Education and Instructional Design', 2, 'Year'),
  	(133, 'sct411', 'PhD Computer Science', 3, 'year'),
  	(134, 'sct421', 'Ph.D. Information Technology', 2, 'Year'),
  	(135, 'tm101', 'Diploma in Clinical Medicine', 3, 'year'),
  	(136, 'tm200', 'Bachelor of Science in Medical Laboratory Science', 4, 'Year'),
  	(137, 'tm201', 'BSc in Clinical Medicine', 5, 'Year'),
  	(138, 'tm210', 'Bsc Public Health', 4, 'Year'),
  	(139, 'tm211', 'BSc. Pharmacy', 5, 'year'),
  	(140, 'tm213', 'KONYANGO MILDRED ADHIAMBO', 4, 'year'),
  	(141, 'tm214', 'BSc. Nursing', 4, 'year'),
  	(142, 'tm215', 'BSc. Radiography', 4, 'year'),
  	(143, 'tm216', 'Bsc Medical Microbiology', 4, 'year'),
  	(144, 'tm224', 'BSc.Industrial Biotechnology', 4, 'year'),
  	(145, 'tm225', 'BSc. Biochemistry and Molecular Biology', 4, 'year'),
  	(146, 'tm226', 'Bachelor of Medicine and Bachelor of Surgery', 4, '2015/2016'),
  	(147, 'tm227', 'B.Sc. in Applied Bioengineering', 4, 'year'),
  	(148, 'tm310', 'MSc. Public Health', 2, 'year'),
  	(149, 'tm318', 'Msc. Molecular Biology And Bioinformatics', 2, 'year'),
  	(150, 'tm323', 'MSc. Agricultural and Environmental Biotechnology', 2, 'year');
  /*!40000 ALTER TABLE `courses` ENABLE KEYS */;
  /*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
  /*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
  /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  