CREATE TABLE `psi_agencies` (
  `agency_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `agency_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `agency_acronym` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `agency_filename` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `agency_file` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `agency_address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `agency_contact` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `agency_email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `agency_phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `agency_website` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `agency_mobile` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `encoder` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `date_encoded` date DEFAULT NULL,
  `updater` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `last_updated` date DEFAULT NULL,
  `agency_longitude` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '121.223697066307',
  `agency_latitude` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '14.1722468782053',
  `agency_gmap_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'AIzaSyCMDx-ejfVStxIBhfqtBuLj98OV79kqbdY',
  `agency_fb_appid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '1685702521726852',
  `agency_region_id` bigint(20) unsigned DEFAULT '6',
  `agency_use_osm` tinyint(3) unsigned DEFAULT '0',
  `region_id` bigint(20) unsigned DEFAULT '6',
  `synched` tinyint(1) unsigned DEFAULT '0',
  `sync_date` datetime DEFAULT NULL,
  PRIMARY KEY (`agency_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO psi_agencies (agency_id, agency_name, agency_acronym, agency_filename, agency_file, agency_address, agency_contact, agency_email, agency_phone, agency_website, agency_mobile, encoder, date_encoded, updater, last_updated, agency_longitude, agency_latitude, agency_gmap_key, agency_fb_appid, agency_region_id, agency_use_osm, region_id, synched, sync_date) VALUES
(1, 'Department of Science &amp; Technology Region 4-A CALABARZON', 'DOST 4A', 'PROGRAMS-and-SERVICES-nf', 'PROGRAMS-and-SERVICES-nf-pvvgyzh-20170209_102454.png', 'Jamboree Road, Timugan, Los BaÃ±os, Laguna', '2', '', '3', '5', '4', 'Admin Is Traytor', '2015-04-26', 'Glenn John M Geronimo', '2018-05-23', '121.223697066307', '14.1722468782053', 'AIzaSyCMDx-ejfVStxIBhfqtBuLj98OV79kqbdY', '1685702521726852', 6, 0, 6, 0, NULL);
