ALTER TABLE ref_regions AUTO_INCREMENT = 1;

-- ----------------------------
-- Table structure for ref_regions
-- ----------------------------
-- DROP TABLE IF EXISTS `ref_regions`;
-- CREATE TABLE `ref_regions` (
--   `id` int(11) NOT NULL AUTO_INCREMENT,
--   `psgcCode` varchar(255) DEFAULT NULL,
--   `regDesc` text,
--   `regCode` varchar(255) DEFAULT NULL,
--   PRIMARY KEY (`id`)
-- ) ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of ref_regions
-- ----------------------------
INSERT INTO `ref_regions` VALUES ('1', '010000000', 'REGION I (ILOCOS REGION)', '01');
INSERT INTO `ref_regions` VALUES ('2', '020000000', 'REGION II (CAGAYAN VALLEY)', '02');
INSERT INTO `ref_regions` VALUES ('3', '030000000', 'REGION III (CENTRAL LUZON)', '03');
INSERT INTO `ref_regions` VALUES ('4', '040000000', 'REGION IV-A (CALABARZON)', '04');
INSERT INTO `ref_regions` VALUES ('5', '170000000', 'REGION IV-B (MIMAROPA)', '17');
INSERT INTO `ref_regions` VALUES ('6', '050000000', 'REGION V (BICOL REGION)', '05');
INSERT INTO `ref_regions` VALUES ('7', '060000000', 'REGION VI (WESTERN VISAYAS)', '06');
INSERT INTO `ref_regions` VALUES ('8', '070000000', 'REGION VII (CENTRAL VISAYAS)', '07');
INSERT INTO `ref_regions` VALUES ('9', '080000000', 'REGION VIII (EASTERN VISAYAS)', '08');
INSERT INTO `ref_regions` VALUES ('10', '090000000', 'REGION IX (ZAMBOANGA PENINSULA)', '09');
INSERT INTO `ref_regions` VALUES ('11', '100000000', 'REGION X (NORTHERN MINDANAO)', '10');
INSERT INTO `ref_regions` VALUES ('12', '110000000', 'REGION XI (DAVAO REGION)', '11');
INSERT INTO `ref_regions` VALUES ('13', '120000000', 'REGION XII (SOCCSKSARGEN)', '12');
INSERT INTO `ref_regions` VALUES ('14', '130000000', 'NATIONAL CAPITAL REGION (NCR)', '13');
INSERT INTO `ref_regions` VALUES ('15', '140000000', 'CORDILLERA ADMINISTRATIVE REGION (CAR)', '14');
INSERT INTO `ref_regions` VALUES ('16', '150000000', 'AUTONOMOUS REGION IN MUSLIM MINDANAO (ARMM)', '15');
INSERT INTO `ref_regions` VALUES ('17', '160000000', 'REGION XIII (Caraga)', '16');
