-- phpMyAdmin SQL Dump
-- version 4.8.5
-- https://www.phpmyadmin.net/
--
-- Host: mysql
-- Generation Time: Mar 17, 2019 at 08:01 AM
-- Server version: 5.7.25
-- PHP Version: 7.2.14

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";

--
-- Dumping data for table `ref_eligibilities`
--

INSERT INTO `ref_eligibilities` (`id`, `name`, `category_id`) VALUES
(1, 'Automotive Mechanic', 11),
(2, 'Carpenter', 11),
(3, 'Draftsman', 11),
(4, 'Heavy Equipment Operator', 11),
(5, 'Laboratory Technician', 11),
(6, 'Plant Electrician', 11),
(7, 'Plumber', 11),
(8, 'Shrine Curator', 11),
(9, 'Welder', 11),
(10, 'Career Service Professional', 13),
(11, 'Career Service Sub-Professional', 13),
(12, 'Electrician', 11),
(13, 'Illustrator', 11),
(14, 'Machinist', 11),
(15, 'Mechanic', 11),
(16, 'Electronics Equipment Technician', 11),
(17, 'Audio-Visual Equipment Operator/Technician', 11),
(18, 'Mechanical Equipment Operator', 11),
(19, 'Painter', 11),
(20, 'Security Guard License', 11),
(21,'Agrarian Reform Officer',NULL),
(22,'Agrarian Reform Technologist',NULL),
(23,'Agricultural Engineer',NULL),
(24,'Agricultural Extension Officer',NULL),
(25,'Agricultural Officer',NULL),
(26,'Agriculturist',NULL),
(27,'Agriculturist (RA8435)',NULL),
(28,'Animal Production',11),
(29,'Architect',NULL),
(30,'Artist Illustrator',11),
(31,'Automotive Mechanical Assembly',11),
(32,'Barangay Health Worker Eligibility',2),
(33,'Barangay Nutrition Scholar Eligibility',3),
(34,'Barangay Official Eligibility',4),
(35,'Building Wiring Electrician',11),
(36,'Career Service Executive Eligibility',NULL),
(37,'Certified Public Accountant',NULL),
(38,'Chemist',NULL),
(39,'Civil Engineer',NULL),
(40,'Commercial Radio Operator',NULL),
(41,'Criminologist',NULL),
(42,'Data Encoder',NULL),
(43,'Data Encoder converted to CSC Eligibility',NULL),
(44,'Dentistry Board Examination',1),
(45,'Doctor of Verterinary Medicine',1),
(46,'Electrical Engineers Licensure Exam',1),
(47,'Electrical Installation & Maintenance',NULL),
(48,'Electrician',NULL),
(49,'Electrician – Testimonial Examination',NULL),
(50,'Electronic Data Processing Specialist Eligibility',NULL),
(51,'Electronics & Communication Engineer',NULL),
(52,'ESK Eligibility',4),
(53,'Farm Management Technician',NULL),
(54,'First Class Radio Telephone Operator',NULL),
(55,'First Grade Civil Service Examination',NULL),
(56,'Fish Examiner',NULL),
(57,'Food Processing',11),
(58,'Foreign School Eligibility',6),
(59,'Foresters Board Exam',1),
(60,'General Carpentry',NULL),
(61,'Geodetic Engineers Licensure Exam',1),
(62,'Guidance Counselor Licensure Exam',1),
(63,'Home Economics Extension Officer',NULL),
(64,'Honor Graduate Eligibility',7),
(65,'Lawyer',1),
(66,'Librarian Licensure Examination',NULL),
(67,'Licensed Chemist (without Exam)',NULL),
(68,'Local Treasury Officer',NULL),
(69,'Manpower Development Officer',NULL),
(70,'Master Electrician',11),
(71,'Master Plumber',11),
(72,'MC II – Installation & Maintenance',11),
(73,'Meat Inspector Licensure Exam',1),
(74,'Mechanic',11),
(75,'Mechanical Engineer',1),
(76,'Mechanical Plant Operator',11),
(77,'Medical Board Examination',1),
(78,'Medical Technology Board Exam',1),
(79,'Midwifery Licensure Examination',1),
(80,'Money Counter',11),
(81,'Museum Technician',11),
(82,'National TVET Trainors Level 1(TQ1) and National TVET Assessors Level 1 (AQ1)',NULL),
(83,'NC I – Automotive Servicing',NULL),
(84,'NC II - Health Care Services',NULL),
(85,'NC II - Horticulture',11),
(86,'NC II - House Keeping Services',11),
(87,'NC II – Computer Hardware Servicing',11),
(88,'NC II – Driving',11),
(89,'NC II – Food Beverage Services',11),
(90,'NC II – National Certificate in Commercial Baking – TESDA',11),
(91,'NC II – Tour Guiding Services',11),
(92,'NC III – Agricultural Crops Production',11),
(93,'NC III – Electrical Installation & Maintenance',11),
(94,'NC III in Ag. Crop Production',11),
(95,'NTC Radio Licensure Exam',1),
(96,'Nurse Licensure Exam',1),
(97,'Philippine Physician Licensure Examination',1),
(98,'Philippine Teacher’s Selection Test',NULL),
(99,'PO1 Entrance (NAPOLCOM)',1),
(100,'Police Officer Eligibility',NULL),
(101,'Professional Board Examination for Teacher',1),
(102,'Professional Drivers License',NULL),
(103,'Professional Mechanical Enigneer',1),
(104,'Qualifying Exam for Residency Training',NULL),
(105,'R.A. 6850',NULL),
(106,'Radio Operator’s License',NULL),
(107,'Registered Guidance Counselor',NULL),
(108,'Sanggunian Member Eligibility',8),
(109,'Scientific and Technological Specialist Eligibility',9),
(110,'Soil Technologist',NULL),
(111,'Soil Technologist (Soil Fertility)',NULL),
(112,'Stenographer',1),
(113,'TESDA TQ1 & TQ2 in Hort.',11),
(114,'Trade Skills Certificate',NULL),
(115,'US NRA ServSafe Food Protection Manager Certification',NULL),
(116,'Veretan Preference Rating Eligibility',12),
(117,'Veterinary Medicine Licensure Exam',1);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `ref_eligibilities`
--
ALTER TABLE `ref_eligibilities`
  ADD PRIMARY KEY (`id`),
  ADD KEY `ref_eligibilities_category_id_index` (`category_id`);
