-- phpMyAdmin SQL Dump
-- version 4.5.4.1deb2ubuntu2.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Aug 20, 2019 at 01:46 AM
-- Server version: 5.7.27-0ubuntu0.16.04.1
-- PHP Version: 7.2.20-2+ubuntu16.04.1+deb.sury.org+1

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
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: `hrmis_81419_project`
--

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


INSERT INTO `plantilla_coverages` (`id`, `acronym`, `designation`, `prexc`, `description`) VALUES
(1, 'GASS', 'GMS', '100000100001000', 'GENERAL ADMINISTRATIVE AND SUPPORT SERVICES'),
(2, 'AES', 'ADV ED', '320100100001000', 'ADVANCED EDUCATION SERVICES'),
(3, 'HES', 'HIGHER ED', '310100100001000', 'HIGHER EDUCATION SERVICES'),
(4, 'HES I', 'ISA', '310100100001000', 'ISABEL NATIONAL AGRICULTURAL AND VOCATIONAL SCHOOL'),
(5, 'HES V', 'VILL', '310100100001000', 'LEYTE NATIONAL COLLEGE OF AGRICULTURE SCIENCE AND TECHNOLOGY'),
(6, 'HES A', 'ALANG', '310100100001000', 'LEYTE STATE SCHOOL OF AGRICULTURE'),
(7, 'HES T', 'TOL', '310100100001000', 'LEYTE STATE SCHOOL OF FISHERIES'),
(8, 'RES', 'RESEARCH', '320200100001000', 'RESEARCH SERVICES'),
(9, 'EXT', 'EXTENSION', '330100100001000', 'EXTENSION SERVICES'),
(10, 'AUX', 'AUXILIARY', '200000100001000', 'AUXILIARY SERVICES');

--
-- Indexes for dumped tables
--

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `plantilla_coverages`
--
ALTER TABLE `plantilla_coverages`
  MODIFY `id` tinyint(3) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
/*!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 */;
