-- phpMyAdmin SQL Dump
-- version 4.8.5
-- https://www.phpmyadmin.net/
--
-- Host: mysql
-- Generation Time: Feb 14, 2019 at 01:43 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";


INSERT INTO `departments` (`id`, `acronym`, `fullname`, `head_id`, `parent_id`, `campus_id`) VALUES
(1, 'DAE', 'Dept. of Agricultural Engineering', 783, 33, 1),
(2, 'DAS', 'Dept. of Animal Science', 10, 34, 1),
(3, 'DoA', 'Dept. of Agronomy', 437, 34, 1),
(4, 'DBM', 'Department of Business and Management', 3, 38, 1),
(5, 'DBS', 'Dept. of Biological Sciences', 323, 35, 1),
(6, 'DCST', 'Dept. of Computer Science and Technology', 487, 33, 1),
(7, 'DDC', 'Dept. of Development Communication', 216, 34, 1),
(8, 'DCHM', 'Dept. of Consumer & Hospitality Management', 182, 38, 1),
(9, 'DFST', 'Dept. of Food Science and Technology', 187, 34, 1),
(10, 'DPBG', 'Dept. of Plant Breeding & Genetics', 349, 34, 1),
(11, 'DLABS', 'Dept. of Liberal Arts & Behavioral Sciences', 202, 35, 1),
(12, 'DMP', 'Dept. of Mathematics and Physics', 196, 35, 1),
(13, 'DOE', 'Dept. of Economics', 469, 38, 1),
(14, 'DOH', 'Dept. of Horticulture', 456, 34, 1),
(15, 'DOPAC', 'Dept. of Pure and Applied Chemistry', 266, 35, 1),
(16, 'DPM', 'Dept. of Pest Management', 285, 34, 1),
(17, 'DVBS', 'Dept. of Veterinary Basic Sciences', 791, 32, 1),
(18, 'DVPCS', 'Dept. of Veterinary Para-Clinical Sciences', 272, 32, 1),
(19, 'FARMI', 'Farm Resource Management Institute', 49, 61, 1),
(20, 'IHK', 'Institute of Human Kinetics', 462, 37, 1),
(21, 'ISRDS', 'Institute of Strategic & Development Studies', 486, 38, 1),
(22, 'NARC', 'National Abaca Research Center', 476, 61, 1),
(23, 'NCRC', 'National Coconut Research Center-Visayas', 149, 61, 1),
(24, 'PRCRTC', 'Philippine Root Crops & Research Training Center', 526, 61, 1),
(25, 'DON', 'Department of Nursing', 910, 39, 1),
(26, 'ITE', 'Institute of Tropical Ecology & Envi. Mgmt.', 85, 36, 1),
(27, 'LHS', 'Laboratory High School', 11, 37, 1),
(28, 'DGE', 'Department of Geodetic Engineering', 224, 33, 1),
(29, 'DCE', 'Department of Civil Engineering', 295, 33, 1),
(30, 'DME', 'Department of Mechanical Engineering', 256, 33, 1),
(31, 'DFS', 'Department of Forest Science', 394, 36, 1),
(32, 'CVM', 'College of Veterinary Medicine', 272, 60, 1),
(33, 'COE', 'College of Engineering', 254, 60, 1),
(34, 'CAFS', 'College of Agricultural & Food Science', 54, 60, 1),
(35, 'CAS', 'College of Arts and Sciences', 129, 60, 1),
(36, 'CFES', 'College of Forestry & Environmental Sciences', 394, 60, 1),
(37, 'CoEd', 'College of Eucation', 540, 60, 1),
(38, 'CME', 'College of Management & Economics', 3, 60, 1),
(39, 'CN', 'College of Nursing', 910, 60, 1),
(40, 'PRPEO', 'Personnel Records & Performance Evaluation Office', 156, 77, 1),
(41, 'NSTP', 'National Service Training Program', 297, 37, 1),
(42, 'DAEE', 'Department of Agricultural Education & Extension', 459, 34, 1),
(43, 'DSS', 'Dept. of Soil Science', 289, 34, 1),
(44, 'DepStat', 'Department of Statistics', 338, 35, 1),
(45, 'DoB', 'Department of Biotechnology', 296, 35, 1),
(46, 'RCCRDC', 'Regional Climate Change R & D Center', 311, 61, 1),
(47, 'NCERC', 'Non-Convention Energy Resource Center', 254, 61, 1),
(48, 'ViCARP', 'Visayas Consortium for Agri. & Resources Program', 139, 61, 1),
(49, 'DYAC', 'Radio Station DYAC', 216, 61, 1),
(50, 'CAC', 'Culture and Arts Center', 285, 61, 1),
(51, 'ATP', 'Annals of Tropical Research', 54, 61, 1),
(52, 'CASL', 'Central Analytical Service Laboratory', 237, 61, 1),
(53, 'GISL', 'Geographic Information System Laboratory', 227, 61, 1),
(54, 'PDDL', 'Plant Disease Diagnostic Laboratory', 110, 61, 1),
(55, 'DVCS', 'Dept. of Veterinary Clinical Sciences', 496, 32, 1),
(56, 'DTE', 'Dept. of Teacher Education', 713, 37, 1),
(57, 'SHS', 'Senior High School Unit', 507, 37, 1),
(58, 'OP', 'Office of the President', 512, 1, 1),
(59, 'OVPAF', 'Office of the Vice President for Admin. & Finance', 388, 58, 1),
(60, 'OVPI', 'Office of the Vice President for Instruction', 97, 58, 1),
(61, 'OVPRE', 'Office of the Vice President for Research & Extens', 139, 58, 1),
(62, 'ASHU', 'Anti-Sexual Harassment Unit', 486, 58, 1),
(63, 'ACRO', 'Alumni & Community Relations Office', 454, 58, 1),
(64, 'InfOff', 'Information Office', 63, 58, 1),
(65, 'IAO', 'International Affairs Office', 251, 58, 1),
(66, 'SPMO', 'Supply & Procurement Management Office', 212, 59, 1),
(67, 'VSUHSO', 'VSU Health Services Office', 545, 59, 1),
(68, 'SecOff', 'Security Office', 256, 59, 1),
(69, 'ILFMU', 'Instrumentation & Lab. Facilities Maintenance Unit', 434, 59, 1),
(70, 'UCC', 'University Connectivity Center', 536, 59, 1),
(71, 'BuO', 'Budget Office', 379, 78, 1),
(72, 'AccO', 'Accounting Office', 195, 78, 1),
(73, 'CaO', 'Cash Office', 356, 78, 1),
(74, 'LWMU', 'Landscaping & Waste Management Unit', 76, 79, 1),
(75, 'IDBMU', 'Infrasctructure Devt. & Building Maint. Unit', 522, 79, 1),
(76, 'PESMU', 'Power & Electrical Supply Maintenance Unit', 189, 79, 1),
(77, 'ODAHRD', 'Director for Admin. & Human Resource Devt. Office', 133, 59, 1),
(78, 'DFF', 'Director for Finance', 718, 59, 1),
(79, 'DGS', 'Director for General Services', 522, 59, 1),
(80, 'HELVMU', 'Heavy Eqpt. & Light Vehicle Maint. Unit', 898, 79, 1),
(81, 'WSSMU', 'Water Sewerage System Management Unit', 898, 79, 1),
(82, 'VSUCO', 'VSU Cebu Office', 375, 59, 1),
(83, 'OGS', 'Office of the Graduate School', 511, 60, 1),
(84, 'VSUCL', 'VSU College Library', 382, 60, 1),
(85, 'USSO', 'University Student Services Office', 297, 60, 1),
(86, 'AdO', 'Admissions Office', 358, 60, 1),
(87, 'DQA', 'Director for Quality Assurance', 126, 60, 1),
(88, 'VSUMO', 'VSU Manila Office', 108, 91, 1),
(89, 'URC', 'University Review Center', 251, 91, 1),
(90, 'IGP', 'Income Generation Projects', 406, 91, 1),
(91, 'OVPPRGEA', 'Office of the Vice Pres. for Planning', 205, 58, 1),
(92, 'DFR', 'Director for Research', 66, 61, 1),
(93, 'DDE', 'Director for Development and Extension', 465, 61, 1),
(94, 'PMO', 'Property Management Office', 212, 61, 1),
(95, 'VSUH', 'VSU Hostel', 182, 61, 1),
(96, 'USF', 'University Sports Facilities', 45, 61, 1),
(97, 'RECORDS', 'Records Office', 472, 59, 1),
(98, 'TBS', 'To Be Specified', 1, 98, 1),
(99, 'GAD','Gender Association Department',1,99, 1),
(100, 'Guesthouse','VSU Guesthouse',1,100, 1),
(101, 'REGISTRAR','Registrar''s Office', 1 ,60, 1),
(102, 'BIDANI','Barangay Integrated Development Approach for Nutrition Improvement', 486, 38, 1),
(103, 'DOMet','Department of Meteorology', 890 ,33, 1),
(104, 'LEGAL','LEGAL OFFICE', 706 ,58, 1),
(105, 'DYDC','DYDC FM', 216 ,60, 1),
(106, 'OUC','Office of the University Secretary', 508 ,58, 1),
(107, 'RERC','Renewable Energy Research Center', 254 ,61, 1),
(109,'ISABEL','ISABEL CAMPUS',512,58,3),
(110,'DA','Department of Agriculture',54,34,1),
(111,'APARTELLE','VSU Apartelle',218,90,1),
(112,'BAC','Bids and Awards Committee',205,91,1),
(113,'BAKERY','VSU Bakery',218,90,1),
(114,'BEACH GARDEN','VSU Beach Garden',406,90,1),
(115,'CCE','Center for Continuing Education',251,60,1),
(116,'COMPUTER CENTER','VSU Computer Center',406,90,1),
(117,'CONVENTION CENTER','VSU Convention Center',76,90,1),
(118,'DABE','Department of Agricultural and BioSystems Engineering',783,33,1),
(119,'INTERNET CAFE','VSU Internet Cafe',487,33,1),
(120,'OPO','Online Program Office',251,60,1),
(121,'PAVILLON','VSU Pavilion',276,33,1),
(122,'PRINTING PRESS','VSU Printing Press',75,60,1),
(123,'SEAFRONT','SEAFRONT SUITE',406,33,1),
(124,'SPRING WATER','VSU Spring Water',406,33,1),
(125,'TBI','Technology Business Incubator',294,61,1),
(126,'TECHNOMART','VSU Technomart',139,61,1),
(127, 'OVPAA', 'Office of the Vice President for Academic Affairs', 97, 58, 1),
(128, 'INNOVATION', 'Innovation Center', 512, 61, 1),
(129, 'IASO', 'Internal Audit Service Office', 163, 58, 1),
(130, 'TVET', 'Technical-Vocational Education And Traning', 712, 33, 1);
