CREATE TABLE `psi_provinces` (
  `province_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `region_id` bigint(20) unsigned DEFAULT '0',
  `province_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `synched` tinyint(1) unsigned DEFAULT '0',
  `sync_date` datetime DEFAULT NULL,
  `encoder` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `date_encoded` datetime DEFAULT NULL,
  `updater` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `last_updated` datetime DEFAULT NULL,
  PRIMARY KEY (`province_id`)
) ENGINE=InnoDB AUTO_INCREMENT=88 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO psi_provinces (province_id, region_id, province_name, synched, sync_date, encoder, date_encoded, updater, last_updated) VALUES
(1, 1, 'NCR 1st District', 0, NULL, '', NULL, '', NULL),
(2, 1, 'NCR 2nd District', 0, NULL, '', NULL, '', NULL),
(3, 1, 'NCR 3rd District', 0, NULL, '', NULL, '', NULL),
(4, 1, 'NCR Fourth District', 0, NULL, '', NULL, '', NULL),
(5, 2, 'Abra', 0, NULL, '', NULL, '', NULL),
(6, 2, 'Apayao', 0, NULL, '', NULL, '', NULL),
(7, 2, 'Benguet', 0, NULL, '', NULL, '', NULL),
(8, 2, 'Ifugao', 0, NULL, '', NULL, '', NULL),
(9, 2, 'Kalinga', 0, NULL, '', NULL, '', NULL),
(10, 2, 'Mountain Province', 0, NULL, '', NULL, '', NULL),
(11, 3, 'Ilocos Norte', 0, NULL, '', NULL, '', NULL),
(12, 3, 'Ilocos Sur', 0, NULL, '', NULL, '', NULL),
(13, 3, 'La Union', 0, NULL, '', NULL, '', NULL),
(14, 3, 'Pangasinan', 0, NULL, '', NULL, '', NULL),
(15, 4, 'Batanes', 0, NULL, '', NULL, '', NULL),
(16, 4, 'Cagayan', 0, NULL, '', NULL, '', NULL),
(17, 4, 'Isabela', 0, NULL, '', NULL, '', NULL),
(18, 4, 'Nueva Vizcaya', 0, NULL, '', NULL, '', NULL),
(19, 4, 'Quirino', 0, NULL, '', NULL, '', NULL),
(20, 5, 'Aurora', 0, NULL, '', NULL, '', NULL),
(21, 5, 'Bataan', 0, NULL, '', NULL, '', NULL),
(22, 5, 'Bulacan', 0, NULL, '', NULL, '', NULL),
(23, 5, 'Nueva Ecija', 0, NULL, '', NULL, '', NULL),
(24, 5, 'Pampanga', 0, NULL, '', NULL, '', NULL),
(25, 5, 'Tarlac', 0, NULL, '', NULL, '', NULL),
(26, 5, 'Zambales', 0, NULL, '', NULL, '', NULL),
(27, 6, 'Batangas', 0, NULL, '', NULL, '', NULL),
(28, 6, 'Cavite', 0, NULL, '', NULL, '', NULL),
(29, 6, 'Laguna', 0, NULL, '', NULL, '', NULL),
(30, 6, 'Quezon', 0, NULL, '', NULL, '', NULL),
(31, 6, 'Rizal', 0, NULL, '', NULL, '', NULL),
(32, 7, 'Marinduque', 0, NULL, '', NULL, '', NULL),
(33, 7, 'Occidental Mindoro', 0, NULL, '', NULL, '', NULL),
(34, 7, 'Oriental Mindoro', 0, NULL, '', NULL, '', NULL),
(35, 7, 'Palawan', 0, NULL, '', NULL, '', NULL),
(36, 7, 'Romblon', 0, NULL, '', NULL, '', NULL),
(37, 8, 'Albay', 0, NULL, '', NULL, '', NULL),
(38, 8, 'Camarines Norte', 0, NULL, '', NULL, '', NULL),
(39, 8, 'Camarines Sur', 0, NULL, '', NULL, '', NULL),
(40, 8, 'Catanduanes', 0, NULL, '', NULL, '', NULL),
(41, 8, 'Masbate', 0, NULL, '', NULL, '', NULL),
(42, 8, 'Sorsogon', 0, NULL, '', NULL, '', NULL),
(43, 9, 'Aklan', 0, NULL, '', NULL, '', NULL),
(44, 9, 'Antique', 0, NULL, '', NULL, '', NULL),
(45, 9, 'Capiz', 0, NULL, '', NULL, '', NULL),
(46, 9, 'Guimaras', 0, NULL, '', NULL, '', NULL),
(47, 9, 'Iloilo', 0, NULL, '', NULL, '', NULL),
(48, 9, 'Negros Occidental', 0, NULL, '', NULL, '', NULL),
(49, 10, 'Bohol', 0, NULL, '', NULL, '', NULL),
(50, 10, 'Cebu', 0, NULL, '', NULL, '', NULL),
(51, 10, 'Negros Oriental', 0, NULL, '', NULL, '', NULL),
(52, 10, 'Siquijor', 0, NULL, '', NULL, '', NULL),
(53, 11, 'Biliran', 0, NULL, '', NULL, '', NULL),
(54, 11, 'Eastern Samar', 0, NULL, '', NULL, '', NULL),
(55, 11, 'Leyte', 0, NULL, '', NULL, '', NULL),
(56, 11, 'Northern Samar', 0, NULL, '', NULL, '', NULL),
(57, 11, 'Samar', 0, NULL, '', NULL, '', NULL),
(58, 11, 'Southern Leyte', 0, NULL, '', NULL, '', NULL),
(59, 12, 'Zamboanga del Norte', 0, NULL, '', NULL, '', NULL),
(60, 12, 'Zamboanga del Sur', 0, NULL, '', NULL, '', NULL),
(61, 12, 'Zamboanga Sibugay', 0, NULL, '', NULL, '', NULL),
(62, 13, 'Bukidnon', 0, NULL, '', NULL, '', NULL),
(63, 13, 'Camiguin', 0, NULL, '', NULL, '', NULL),
(64, 13, 'Lanao del Norte', 0, NULL, '', NULL, '', NULL),
(65, 13, 'Misamis Occidental', 0, NULL, '', NULL, '', NULL),
(66, 13, 'Misamis Oriental', 0, NULL, '', NULL, '', NULL),
(67, 14, 'Compostela Valley', 0, NULL, '', NULL, '', NULL),
(68, 14, 'Davao del Norte', 0, NULL, '', NULL, '', NULL),
(69, 14, 'Davao del Sur', 0, NULL, '', NULL, '', NULL),
(70, 14, 'Davao Oriental', 0, NULL, '', NULL, '', NULL),
(71, 14, 'Davao Occidental', 0, NULL, '', NULL, '', NULL),
(72, 15, 'Cotabato', 0, NULL, '', NULL, '', NULL),
(73, 15, 'Sarangani', 0, NULL, '', NULL, '', NULL),
(74, 15, 'South Cotabato', 0, NULL, '', NULL, '', NULL),
(75, 15, 'Sultan Kudarat', 0, NULL, '', NULL, '', NULL),
(76, 16, 'Agusan del Norte', 0, NULL, '', NULL, '', NULL),
(77, 16, 'Agusan del Sur', 0, NULL, '', NULL, '', NULL),
(78, 16, 'Dinagat Islands', 0, NULL, '', NULL, '', NULL),
(79, 16, 'Surigao del Norte', 0, NULL, '', NULL, '', NULL),
(80, 16, 'Surigao del Sur', 0, NULL, '', NULL, '', NULL),
(81, 17, 'Lanao del Sur', 0, NULL, '', NULL, '', NULL),
(82, 17, 'Maguindanao', 0, NULL, '', NULL, '', NULL),
(83, 17, 'Sulu', 0, NULL, '', NULL, '', NULL),
(84, 17, 'Tawi-Tawi', 0, NULL, '', NULL, '', NULL),
(85, 17, 'Basilan', 0, NULL, '', NULL, '', NULL),
(86, 12, 'Basilan', 0, NULL, '', NULL, '', NULL),
(87, 15, 'Maguindanao', 0, NULL, '', NULL, '', NULL);
