CREATE TABLE `psi_regions` (
  `region_id` int(11) NOT NULL AUTO_INCREMENT,
  `region_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `region_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `synched` tinyint(1) unsigned DEFAULT '0',
  `sync_date` datetime DEFAULT NULL,
  `date_encoded` datetime DEFAULT NULL,
  `last_updated` datetime DEFAULT NULL,
  `encoder` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `updater` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  PRIMARY KEY (`region_id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO psi_regions (region_id, region_code, region_name, synched, sync_date, date_encoded, last_updated, encoder, updater) VALUES
(1, 'NCR', 'National Capital Region', 0, NULL, NULL, NULL, '', ''),
(2, 'CAR', 'Cordillera Administrative Region', 0, NULL, NULL, NULL, '', ''),
(3, 'Region I', 'Ilocos Region', 0, NULL, NULL, NULL, '', ''),
(4, 'Region II', 'Cagayan Valley', 0, NULL, NULL, NULL, '', ''),
(5, 'Region III', 'Central Luzon', 0, NULL, NULL, NULL, '', ''),
(6, 'Region IV-A', 'CALABARZON', 0, NULL, NULL, NULL, '', ''),
(7, 'Region IV-B', 'MIMAROPA', 0, NULL, NULL, NULL, '', ''),
(8, 'Region V', 'Bicol Region', 0, NULL, NULL, NULL, '', ''),
(9, 'Region VI', 'Western Visayas', 0, NULL, NULL, NULL, '', ''),
(10, 'Region VII', 'Central Visayas', 0, NULL, NULL, NULL, '', ''),
(11, 'Region VIII', 'Eastern Visayas', 0, NULL, NULL, NULL, '', ''),
(12, 'Region IX', 'Zamboanga Peninsula', 0, NULL, NULL, NULL, '', ''),
(13, 'Region X', 'Northern Mindanao', 0, NULL, NULL, NULL, '', ''),
(14, 'Region XI', 'Davao Region', 0, NULL, NULL, NULL, '', ''),
(15, 'Region XII', 'SOCCSKSARGEN', 0, NULL, NULL, NULL, '', ''),
(16, 'CARAGA', 'Caraga', 0, NULL, NULL, NULL, '', ''),
(17, 'ARMM', 'Autonomous Region in Muslim Mindanao', 0, NULL, NULL, NULL, '', '');
