-- phpMyAdmin SQL Dump
-- version 4.8.5
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: Apr 09, 2020 at 03:17 AM
-- Server version: 5.7.25
-- PHP Version: 7.2.21

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


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `hris`
--

-- --------------------------------------------------------

--
-- Table structure for table `ref_institutions`
--
--
-- Dumping data for table `ref_institutions`
--

INSERT INTO `ref_institutions` (`id`, `name`, `acronym`) VALUES
(2, 'Alang-Alang', 'Alang-Alang'),
(3, 'Albuera', 'Albuera'),
(4, 'ARTIMCO', 'ARTIMCO'),
(5, 'Agricultural Training Institute – National Telecommunications Commission', 'ATI-NTC'),
(6, 'Badian National HighSchool', 'BadianNHS'),
(7, 'BAE', 'BAE'),
(8, 'BAEx', 'BAEx'),
(9, 'Baybay', 'Baybay'),
(10, 'Baybay National HighSchool', 'BNHS'),
(11, 'Baybay North School', 'Baybay North'),
(12, 'BHS', 'BHS'),
(13, 'Bohol Island State University', 'BISU'),
(14, 'BNAFS', 'BNAFS'),
(15, 'BPS', 'BPS'),
(16, 'BPS Matag-ob', 'BPS Matag-ob'),
(17, 'BPS Villaba', 'BPS Villaba'),
(18, 'Bukidnon', 'Bukidnon'),
(19, 'Capiz Agricultural Fish School', 'CapizAgFisSch'),
(20, 'Caridad National HighSchool', 'Caridad-NHS'),
(21, 'Claveria', 'Claveria'),
(22, 'College of Mindanao University', 'CMU'),
(23, 'CNSC', 'CNSC'),
(24, 'COA-Reg. 8', 'COA-Reg. 8'),
(25, 'CPSU', 'CPSU'),
(26, 'CTO', 'CTO'),
(27, 'DA-AES', 'DA-AES'),
(28, 'DA-RFU Reg. 8', 'DA-RFU Reg. 8'),
(29, 'DAR', 'DAR'),
(30, 'DCDE-VSU', 'DCDE-VSU'),
(31, 'Department of Education', 'Dep-Ed'),
(32, 'Dep-Ed ENHS', 'Dep-Ed ENHS'),
(33, 'Dep-Ed LNTNHS', 'Dep-Ed LNTNHS'),
(34, 'Dingras', 'Dingras'),
(35, 'DPI Cebu', 'DPI Cebu'),
(36, 'DSW Ormoc', 'DSW Ormoc'),
(37, 'DSWD Reg.7', 'DSWD Reg.7'),
(38, 'Duero Bohol', 'Duero Bohol'),
(39, 'ESSC', 'ESSC'),
(40, 'ESSU-Salcedo', 'ESSU-Salcedo'),
(41, 'Eastern Visayas Regional Medical Center', 'EVRMC'),
(42, 'EWCST', 'EWCST'),
(43, 'FARMI', 'FARMI'),
(44, 'FSDP-EV', 'FSDP-EV'),
(45, 'FSDP-DA', 'FSDP-DA'),
(46, 'ICNHS', 'ICNHS'),
(47, 'IDRC', 'IDRC'),
(48, 'Isabel NCIS', 'Isabel NCIS'),
(49, 'Local Government Unit – La Paz', 'LGU La Paz'),
(50, 'Local Government Unit – Makati', 'LGU Makati'),
(51, 'Local Government Unit – Ormoc', 'LGU Ormoc'),
(52, 'LNAC Villaba', 'LNAC Villaba'),
(53, 'Leyte Normal Unveristy', 'LNU'),
(54, 'Leyte State University', 'LSU'),
(55, 'Magsaysay SF', 'Magsaysay SF'),
(56, 'MAR', 'MAR'),
(57, 'Matag-ob', 'Matag-ob'),
(58, 'MC', 'MC'),
(59, 'MIT', 'MIT'),
(60, 'MMSU-CAF', 'MMSU-CAF'),
(61, 'MOSCAT', 'MOSCAT'),
(62, 'Mindanao State University', 'MSU'),
(63, 'MSU-IIT', 'MSU-IIT'),
(64, 'MSUCNSM', 'MSUCNSM'),
(65, 'NAT.', 'NAT.'),
(66, 'NOAC', 'NOAC'),
(67, 'NORMISIST', 'NORMISIST'),
(68, 'NSCA', 'NSCA'),
(69, 'NSDC ViSCA', 'NSDC ViSCA'),
(70, 'NTA-Leyte', 'NTA-Leyte'),
(71, 'Northwest Samar State University', 'NwSSU'),
(72, 'Palo', 'Palo'),
(73, 'PCAR/IDRC', 'PCAR/IDRC'),
(74, 'Philippine Council for Agriculture, Aquatic and Natural Resources Research and Development', 'PCARRD'),
(75, 'PCC', 'PCC'),
(76, 'PICOP Resources inc.', 'PICOP Resources inc.'),
(77, 'PIU', 'PIU'),
(78, 'PSHSSMC', 'PSHSSMC'),
(79, 'Quedancor', 'Quedancor'),
(80, 'Reg.', 'Reg.'),
(81, 'RKKMAFTI', 'RKKMAFTI'),
(82, 'RTC-RD', 'RTC-RD'),
(83, 'SHS', 'SHS'),
(84, 'SIAFTI Bontoc', 'SIAFTI Bontoc'),
(85, 'Southern Leyte State University - Sogod', 'SLSU-Sogod'),
(86, 'SLSU-TO', 'SLSU-TO'),
(87, 'SLSU-TONC', 'SLSU-TONC'),
(88, 'TTMIST', 'TTMIST'),
(89, 'University of Eastern Philippines', 'UEP'),
(90, 'University of the Philippines – Cebu', 'UP Cebu'),
(91, 'University of the Philippines – Tacloban', 'UP Tacloban'),
(92, 'UPICM', 'UPICM'),
(93, 'VAC', 'VAC'),
(94, 'Visca Foundation Elementary School', 'ViFES'),
(95, 'Visayas College of Agriculture', 'ViSCA'),
(96, 'APC', 'APC'),
(97, 'WLGH', 'WLGH'),
(98, 'WLPH', 'WLPH'),
(99, 'S54-TONC', 'S54-TONC'),
(100, 'SUC-TONC', 'SUC-TONC'),
(101, 'UPV-Tac.', 'UPV-Tac.');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `ref_institutions`
--
ALTER TABLE `ref_institutions`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `ref_institutions`
--
ALTER TABLE `ref_institutions`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=101;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
