
DROP TABLE IF EXISTS `master_provinsi`;
CREATE TABLE IF NOT EXISTS `master_provinsi` (
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

LOCK TABLES `master_provinsi` WRITE;
/*!40000 ALTER TABLE `master_provinsi` DISABLE KEYS */;
INSERT INTO `master_provinsi` VALUES
  ('11', 'ACEH'),
  ('12', 'SUMATERA UTARA'),
  ('13', 'SUMATERA BARAT'),
  ('14', 'RIAU'),
  ('15', 'JAMBI'),
  ('16', 'SUMATERA SELATAN'),
  ('17', 'BENGKULU'),
  ('18', 'LAMPUNG'),
  ('19', 'KEPULAUAN BANGKA BELITUNG'),
  ('21', 'KEPULAUAN RIAU'),
  ('31', 'DKI JAKARTA'),
  ('32', 'JAWA BARAT'),
  ('33', 'JAWA TENGAH'),
  ('34', 'DI YOGYAKARTA'),
  ('35', 'JAWA TIMUR'),
  ('36', 'BANTEN'),
  ('51', 'BALI'),
  ('52', 'NUSA TENGGARA BARAT'),
  ('53', 'NUSA TENGGARA TIMUR'),
  ('61', 'KALIMANTAN BARAT'),
  ('62', 'KALIMANTAN TENGAH'),
  ('63', 'KALIMANTAN SELATAN'),
  ('64', 'KALIMANTAN TIMUR'),
  ('65', 'KALIMANTAN UTARA'),
  ('71', 'SULAWESI UTARA'),
  ('72', 'SULAWESI TENGAH'),
  ('73', 'SULAWESI SELATAN'),
  ('74', 'SULAWESI TENGGARA'),
  ('75', 'GORONTALO'),
  ('76', 'SULAWESI BARAT'),
  ('81', 'MALUKU'),
  ('82', 'MALUKU UTARA'),
  ('91', 'PAPUA BARAT'),
  ('94', 'PAPUA');
/*!40000 ALTER TABLE `master_provinsi` ENABLE KEYS */;
UNLOCK TABLES;