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

--
-- Dumping data for table `ref_organizations_associations`
--

INSERT INTO `ref_organizations_associations` (`id`, `title`, `acronym`) VALUES
(1, 'Natural Products Society of the Philippines', 'NPSP'),
(2, 'Phil. Association of Institutions for Research, Inc.', 'PAIR'),
(3, 'Alpha Sigma Chi Omega Fraternity and Sorrority', 'ACO'),
(4, 'American Safety Health Institute', 'ASHI'),
(5, 'Association of Nursing Service Administrators of the Philippines', 'ANSAP'),
(6, 'American Safety Health Institute – Advanced Cardiac Life Support', 'ASHI ACLS'),
(7, 'Association of Systematic Biologist in the Philippines', 'ASBP'),
(8, 'Brotherhood of Christian Business and Professionals', 'BCBP'),
(9, 'Coastal Conservation Education Foundation', 'CCEF'),
(10, 'Consortium of Development Communication Educators and Practicioners in the Philippines', 'CDCEPP'),
(11, 'CPR Pro for the Professional Rescuer', NULL),
(12, 'CRM Network of Southern Leyte', NULL),
(13, 'DAAD Alumni Association', NULL),
(14, 'DOH Vicente Sotto Memorial Medical Center', NULL),
(15, 'Federation of Institutions for Marine and Freshwater Sciences', 'FIMFS'),
(16, 'Geodetic Engineers of the Philippines Incorporated', 'GEP'),
(17, 'Gerontology Nurses & Cares & Assocation of the Philippines', NULL),
(18, 'Gerontology Nurses Assocation of the Philippines', 'GNAP'),
(19, 'Hilongos District Hospital, Leyte', NULL),
(20, 'Housing', NULL),
(21, 'Infusion Nurses Society', 'INS'),
(22, 'Institute of Integrated Electrical Engineers, Phil', 'IIEE'),
(23, 'International societ for southeast Asian Agricultural Sciences, Inc.', 'ISSAAS'),
(24, 'Knights of Colombus – Pangasugan Council', 'KOFC'),
(25, 'Lady of the Miraculous Medal Lectors Guild', NULL),
(26, 'Leyte State University – Administrative Personnel Association', 'LSU – ADPA'),
(27, 'Mother and Child Nurses Association of the Philippines', 'MCNAP'),
(28, 'National League of Phil Government Nurses, Inc.', 'NLPGN'),
(29, 'National Research Council of the Philippines', 'NRCP'),
(30, 'Occupational Health Nurses Assocation of the Philippines, Inc.', 'OHNAP'),
(31, 'Operating Room Nurses Association of the Philippines', 'ORNAP'),
(32, 'PCARRD Scholars Assocation Incorporated', 'PSAI'),
(33, 'Phil. Association of Agri-Environmental Educators and Entrepreneurs', 'PASSAGE'),
(34, 'Phil. Assocation of Food Technologists, Inc.', 'PAFT'),
(35, 'Philippines Council of Mathematics Teacher Educators', 'MATHTED'),
(36, 'Philippine Assocation for Graduate Education', 'PAGE'),
(37, 'Philippine Assocation of Marine Scientist', 'PAMS'),
(38, 'Philippine Coastguard Auxiliary', 'PCG'),
(39, 'Philippine Extension Network, Inc.', 'PEN'),
(40, 'Philippine Librarians Assocation, Inc.', 'PLAI'),
(41, 'Philippine Nurses Assocation', 'PNA'),
(42, 'Philippine Nurses Environmental Organizations', 'PNEO'),
(43, 'Philippine Nursing Research Society Inc.', 'PNRSI'),
(44, 'Philippine Oncology Nurses Association, Inc.', 'PONA'),
(45, 'Philippine Society for Lactic Acid Bacteria', 'PSLAB'),
(46, 'Philippine Society of Biochemistry and Molecular Biology', 'PSBMB'),
(47, 'Philippine Society of Emergency Care Nurses, Inc.', 'PSECN'),
(48, 'Philippine Society of Mechanical Engineers', 'PSME'),
(49, 'Philippine Librarians Association, Inc. - Eastern Visayas Librarians Council', 'PLAI-EVRLC'),
(50, 'Plan International', ''),
(51, 'Philippine Society of Agricultural Engineers', 'PSAE'),
(52, 'Renal Nurses Assocation of the Philippines', 'RENAP'),
(53, 'Society of Cardiovascular Nurse Practioners of the Philippines, Inc.', 'SCVNPPI'),
(54, 'Society of Fishery Technologists in Eastern Visayas', 'SOFT'),
(55, 'State Universities and Colleges Extension Managers Network, Inc.', NULL),
(56, 'VISCA Environmental Awareness Movement', NULL),
(57, 'Visayas State University – Farmer’s Association', 'VSU – FA'),
(58, 'VSU Alumni Association', 'VSUAA'),
(59, 'Visayas State University Credit Cooperative', 'VSUCC'),
(60, 'Personnel Officers Association of the Philippines', 'POAP'),
(61, 'Association of Government Internal Auditors', 'AGIA'),
(62, 'Philippines Association for Government Budget Administration', 'PAGBA'),
(63, 'Association of Government Accountants of the Philippines', 'AGAP'),
(64, 'Integrated Bar of the Philippines', 'IBP'),
(65, 'Philippine Librarians Association. Inc.', 'PLAI'),
(66, 'Eastern Visayas Region Librarians Council', 'EVRLC');

--
-- Indexes for dumped tables
--

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