text: /*
   Navicat Premium Data Transfer
  
   Source Server         : localhost mysql
   Source Server Type    : MySQL
   Source Server Version : 100137
   Source Host           : localhost:3306
   Source Schema         : db_nylesouth
  
   Target Server Type    : MySQL
   Target Server Version : 100137
   File Encoding         : 65001
  
   Date: 30/08/2021 23:06:34
  */
  
  SET NAMES utf8mb4;
  SET FOREIGN_KEY_CHECKS = 0;
  
  -- ----------------------------
  -- Table structure for data_admin
  -- ----------------------------
  DROP TABLE IF EXISTS `data_admin`;
  CREATE TABLE `data_admin`  (
    `kode_admin` int(11) NOT NULL AUTO_INCREMENT,
    `username` char(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `nama_lengkap` char(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `email_admin` char(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
    `password_admin` char(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `status_admin` int(11) NOT NULL DEFAULT 1,
    `created_at` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),
    `updated_at` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),
    PRIMARY KEY (`kode_admin`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Table structure for data_ekspedisi
  -- ----------------------------
  DROP TABLE IF EXISTS `data_ekspedisi`;
  CREATE TABLE `data_ekspedisi`  (
    `kode_ekspedisi` int(11) NOT NULL AUTO_INCREMENT,
    `nama_ekspedisi` char(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `created_at` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),
    `updated_at` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),
    PRIMARY KEY (`kode_ekspedisi`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Table structure for data_pembayaran
  -- ----------------------------
  DROP TABLE IF EXISTS `data_pembayaran`;
  CREATE TABLE `data_pembayaran`  (
    `kode_pembayaran` int(11) NOT NULL AUTO_INCREMENT,
    `kode_trx_pemesanan` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `kode_pelanggan` int(11) NOT NULL,
    `transfer_atas_nama` char(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `notes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
    `status_bayar` char(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `pembayaran_foto_folder_path` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `created_at` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),
    `updated_at` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0),
    PRIMARY KEY (`kode_pembayaran`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of data_pembayaran
  -- ----------------------------
  INSERT INTO `data_pembayaran` VALUES (1, '2021-08-11 08:23:59/TRX-0001-933', 8, 'Brian', 'semoga', '0', '/uploads/bukti_transfer/login.PNG', '2021-08-11 08:23:59', '2021-08-11 15:23:59');
  INSERT INTO `data_pembayaran` VALUES (2, '2021-08-28 08:16:56/TRX-0002-83', 8, 'AAA', 'AAAA', '0', '/uploads/bukti_transfer/Feed 3.png', '2021-08-28 08:16:56', '2021-08-28 15:16:56');
  
  -- ----------------------------
  -- Table structure for data_pemesanan
  -- ----------------------------
  DROP TABLE IF EXISTS `data_pemesanan`;
  CREATE TABLE `data_pemesanan`  (
    `kode_trx_pemesanan` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `kode_pelanggan` int(11) NOT NULL,
    `kode_produk` char(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `tanggal_pesan` datetime(0) NOT NULL,
    `jumlah` int(11) NOT NULL,
    `total_harga` double NOT NULL,
    `status_pemesanan` char(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `notes` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
    `created_at` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0),
    `updated_at` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0),
    `kurir` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
    `sub_total` double NULL DEFAULT NULL,
    `biaya_kirim` double NULL DEFAULT NULL,
    `id_detail_produk` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
    `deleted_at` timestamp(0) NULL DEFAULT NULL
  ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of data_pemesanan
  -- ----------------------------
  INSERT INTO `data_pemesanan` VALUES ('2021-08-11 08:23:59/TRX-0001-933', 8, 'NS-0003', '2021-08-11 08:23:59', 2, 872000, '4', NULL, '2021-08-28 18:31:23', '2021-08-11 15:23:59', 'Economy Service - (TIKI)', 624000, 8000, 'BN-NS-0003-705', '2021-08-28 11:31:23');
  INSERT INTO `data_pemesanan` VALUES ('2021-08-11 08:23:59/TRX-0001-933', 8, 'NS-0004', '2021-08-11 08:23:59', 2, 872000, '4', NULL, '2021-08-11 15:56:14', '2021-08-11 15:23:59', 'Economy Service - (TIKI)', 240000, 8000, 'BN-NS-0004-563', NULL);
  INSERT INTO `data_pemesanan` VALUES ('2021-08-28 08:16:56/TRX-0002-83', 8, 'NS-0003', '2021-08-28 08:16:56', 1, 320000, '4', NULL, '2021-08-28 15:19:19', '2021-08-28 15:16:56', 'Economy Service - (TIKI)', 312000, 8000, 'BN-NS-0003-666', NULL);
  
  -- ----------------------------
  -- Table structure for data_pengiriman
  -- ----------------------------
  DROP TABLE IF EXISTS `data_pengiriman`;
  CREATE TABLE `data_pengiriman`  (
    `kode_pengiriman` bigint(30) NOT NULL AUTO_INCREMENT,
    `kode_trx_pemesanan` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `kode_provinsi` int(11) NULL DEFAULT NULL,
    `kurir` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `nomor_resi` char(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `nama_penerima` char(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `no_hp_penerima` char(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
    `alamat_kirim` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
    `biaya_kirim` double NOT NULL,
    `created_at` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0),
    `updated_at` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0),
    `status_pengiriman` smallint(6) NULL DEFAULT NULL,
    PRIMARY KEY (`kode_pengiriman`) USING BTREE,
    INDEX `kode_trx_pemesanan`(`kode_trx_pemesanan`) USING BTREE,
    INDEX `kode_ekspedisi`(`kurir`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of data_pengiriman
  -- ----------------------------
  INSERT INTO `data_pengiriman` VALUES (1, '2021-08-11 08:23:59/TRX-0001-933', NULL, 'Economy Service - (TIKI)', 'J8456JDA45678', 'Brayen Prayoga', '56789765', 'Centex', 8000, '2021-08-11 15:48:42', '2021-08-11 15:48:42', 1);
  
  -- ----------------------------
  -- Table structure for data_retur
  -- ----------------------------
  DROP TABLE IF EXISTS `data_retur`;
  CREATE TABLE `data_retur`  (
    `kode_retur` int(11) NOT NULL AUTO_INCREMENT,
    `kode_trx_pemesanan` char(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
    `kode_pelanggan` int(11) NOT NULL,
    `alasan_retur` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `status_retur` char(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `retur_foto_folder_path` int(11) NULL DEFAULT NULL,
    `created_at` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0),
    `updated_at` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0),
    `kode_produk` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
    `kode_warna` int(11) NULL DEFAULT NULL,
    `kode_ukuran` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
    `jumlah` int(11) NULL DEFAULT NULL,
    PRIMARY KEY (`kode_retur`) USING BTREE,
    INDEX `kode_trx_pemesanan`(`kode_trx_pemesanan`) USING BTREE,
    INDEX `kode_pelanggan`(`kode_pelanggan`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of data_retur
  -- ----------------------------
  INSERT INTO `data_retur` VALUES (2, NULL, 8, 'kekecilan', '1', NULL, '2021-08-28 18:31:23', '2021-08-28 18:31:23', 'NS-0003', 1, 'M', 2);
  
  -- ----------------------------
  -- Table structure for keranjang_belanja
  -- ----------------------------
  DROP TABLE IF EXISTS `keranjang_belanja`;
  CREATE TABLE `keranjang_belanja`  (
    `kode_keranjang` int(11) NOT NULL AUTO_INCREMENT,
    `kode_produk` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `kode_ukuran` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
    `kode_pelanggan` int(11) NOT NULL,
    `kode_warna` int(11) NULL DEFAULT NULL,
    `jumlah` int(11) NOT NULL,
    `created_at` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),
    `updated_at` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0),
    `berat_barang` decimal(11, 2) NULL DEFAULT NULL,
    `status` int(1) NULL DEFAULT NULL,
    `deleted_at` timestamp(0) NULL DEFAULT NULL,
    PRIMARY KEY (`kode_keranjang`) USING BTREE,
    INDEX `kode_produk`(`kode_produk`(191)) USING BTREE,
    INDEX `kode_pelanggan`(`kode_pelanggan`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of keranjang_belanja
  -- ----------------------------
  INSERT INTO `keranjang_belanja` VALUES (1, 'NS-0004', 'L', 2, 1, 3, '2021-05-23 14:50:45', NULL, 0.37, NULL, NULL);
  INSERT INTO `keranjang_belanja` VALUES (2, 'NS-0004', 'M', 2, 3, 3, '2021-05-23 14:51:36', NULL, 0.40, NULL, NULL);
  INSERT INTO `keranjang_belanja` VALUES (3, 'NS-0004', 'L', 5, 1, 1, '2021-07-10 07:29:42', '2021-07-10 14:29:42', NULL, NULL, NULL);
  INSERT INTO `keranjang_belanja` VALUES (4, 'NS-0003', 'M', 8, 1, 2, '2021-07-11 08:27:00', '2021-07-10 17:51:27', NULL, 1, '2021-08-28 11:31:23');
  INSERT INTO `keranjang_belanja` VALUES (5, 'NS-0004', 'M', 8, 3, 2, '2021-07-11 08:47:38', '2021-07-10 17:51:27', NULL, 1, NULL);
  INSERT INTO `keranjang_belanja` VALUES (6, 'NS-0003', 'L', 8, 1, 1, '2021-08-28 08:15:45', '2021-08-28 15:15:45', NULL, 1, NULL);
  
  -- ----------------------------
  -- Table structure for master_kab_kota
  -- ----------------------------
  DROP TABLE IF EXISTS `master_kab_kota`;
  CREATE TABLE `master_kab_kota`  (
    `id` int(11) NOT NULL,
    `id_provinsi` int(11) NULL DEFAULT NULL,
    `kab_kota` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
    `created_at` timestamp(6) NULL DEFAULT NULL,
    `deleted_at` timestamp(6) NULL DEFAULT NULL,
    `updated_at` timestamp(6) NULL DEFAULT NULL,
    `status_active` int(11) NULL DEFAULT NULL,
    `kode_pos` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
    `id_api` int(11) NULL DEFAULT NULL,
    `id_provinsi_api` int(11) NULL DEFAULT NULL,
    PRIMARY KEY (`id`) USING BTREE
  ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Compact;
  
  -- ----------------------------
  -- Records of master_kab_kota
  -- ----------------------------
  INSERT INTO `master_kab_kota` VALUES (1, 2, 'KAB. ACEH SELATAN', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '23719', 5, 21);
  INSERT INTO `master_kab_kota` VALUES (2, 2, 'KAB. ACEH TENGGARA', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '24611', 9, 21);
  INSERT INTO `master_kab_kota` VALUES (3, 2, 'KAB. ACEH TIMUR', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '24454', 10, 21);
  INSERT INTO `master_kab_kota` VALUES (4, 2, 'KAB. ACEH TENGAH', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '24511', 8, 21);
  INSERT INTO `master_kab_kota` VALUES (5, 2, 'KAB. ACEH BARAT', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '23681', 1, 21);
  INSERT INTO `master_kab_kota` VALUES (6, 2, 'KAB. ACEH BESAR', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '23951', 3, 21);
  INSERT INTO `master_kab_kota` VALUES (7, 2, 'KAB. PIDIE', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '24116', 358, 21);
  INSERT INTO `master_kab_kota` VALUES (8, 2, 'KAB. ACEH UTARA', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '24382', 11, 21);
  INSERT INTO `master_kab_kota` VALUES (9, 2, 'KAB. SIMEULUE', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '23891', 414, 21);
  INSERT INTO `master_kab_kota` VALUES (10, 2, 'KAB. ACEH SINGKIL', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '24785', 6, 21);
  INSERT INTO `master_kab_kota` VALUES (11, 2, 'KAB. BIREUEN', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '24219', 72, 21);
  INSERT INTO `master_kab_kota` VALUES (12, 2, 'KAB. ACEH BARAT DAYA', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '23764', 2, 21);
  INSERT INTO `master_kab_kota` VALUES (13, 2, 'KAB. GAYO LUES', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '24653', 127, 21);
  INSERT INTO `master_kab_kota` VALUES (14, 2, 'KAB. ACEH JAYA', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '23654', 4, 21);
  INSERT INTO `master_kab_kota` VALUES (15, 2, 'KAB. NAGAN RAYA', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '23674', 300, 21);
  INSERT INTO `master_kab_kota` VALUES (16, 2, 'KAB. ACEH TAMIANG', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '24476', 7, 21);
  INSERT INTO `master_kab_kota` VALUES (17, 2, 'KAB. BENER MERIAH', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '24581', 59, 21);
  INSERT INTO `master_kab_kota` VALUES (18, 2, 'KAB. PIDIE JAYA', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '24186', 359, 21);
  INSERT INTO `master_kab_kota` VALUES (19, 2, 'KOTA BANDA ACEH', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '23238', 20, 21);
  INSERT INTO `master_kab_kota` VALUES (20, 2, 'KOTA SABANG', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '23512', 384, 21);
  INSERT INTO `master_kab_kota` VALUES (21, 2, 'KOTA LHOKSEUMAWE', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '24352', 235, 21);
  INSERT INTO `master_kab_kota` VALUES (22, 2, 'KOTA LANGGA', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, NULL, NULL, NULL);
  INSERT INTO `master_kab_kota` VALUES (23, 2, 'KOTA SUBULUSSALAM', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '24882', 429, 21);
  INSERT INTO `master_kab_kota` VALUES (24, 3, 'KAB. TAPANULI TENGAH', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '22611', 464, 34);
  INSERT INTO `master_kab_kota` VALUES (25, 3, 'KAB. TAPANULI UTARA', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '22414', 465, 34);
  INSERT INTO `master_kab_kota` VALUES (26, 3, 'KAB. TAPANULI SELATAN', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '22742', 463, 34);
  INSERT INTO `master_kab_kota` VALUES (27, 3, 'KAB. NIAS', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '22876', 307, 34);
  INSERT INTO `master_kab_kota` VALUES (28, 3, 'KAB. LANGKAT', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '20811', 229, 34);
  INSERT INTO `master_kab_kota` VALUES (29, 3, 'KAB. KARO', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '22119', 173, 34);
  INSERT INTO `master_kab_kota` VALUES (30, 3, 'KAB. DELI SERDANG', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '20511', 112, 34);
  INSERT INTO `master_kab_kota` VALUES (31, 3, 'KAB. SIMALUNGUN', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '21162', 413, 34);
  INSERT INTO `master_kab_kota` VALUES (32, 3, 'KAB. ASAHAN', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '21214', 15, 34);
  INSERT INTO `master_kab_kota` VALUES (33, 3, 'KAB. LABUHAN BATU', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '21412', 217, 34);
  INSERT INTO `master_kab_kota` VALUES (34, 3, 'KAB. DAIRI', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '22211', 110, 34);
  INSERT INTO `master_kab_kota` VALUES (35, 3, 'KAB. TOBA SAMOSIR', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '22316', 481, 34);
  INSERT INTO `master_kab_kota` VALUES (36, 3, 'KAB. MANDAILING NATAL', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '22916', 268, 34);
  INSERT INTO `master_kab_kota` VALUES (37, 3, 'KAB. NIAS SELATAN', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '22865', 309, 34);
  INSERT INTO `master_kab_kota` VALUES (38, 3, 'KAB. PAKPAK BHARAT', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '22272', 325, 34);
  INSERT INTO `master_kab_kota` VALUES (39, 3, 'KAB. HUMBANG HASUNDUTAN', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '22457', 146, 34);
  INSERT INTO `master_kab_kota` VALUES (40, 3, 'KAB. SAMOSIR', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '22392', 389, 34);
  INSERT INTO `master_kab_kota` VALUES (41, 3, 'KAB. SERDANG BEDAGAI', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '20915', 404, 34);
  INSERT INTO `master_kab_kota` VALUES (42, 3, 'KAB. BATUBARA', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, NULL, NULL, NULL);
  INSERT INTO `master_kab_kota` VALUES (43, 3, 'KAB. PADANG LAWAS UTARA', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '22753', 320, 34);
  INSERT INTO `master_kab_kota` VALUES (44, 3, 'KAB. PADANG LAWAS', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '22763', 319, 34);
  INSERT INTO `master_kab_kota` VALUES (45, 3, 'KAB. LABUHAN BATU SELATAN', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '21511', 218, 34);
  INSERT INTO `master_kab_kota` VALUES (46, 3, 'KAB. LABUHAN BATU UTARA', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '21711', 219, 34);
  INSERT INTO `master_kab_kota` VALUES (47, 3, 'KAB. NIAS UTARA', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '22856', 310, 34);
  INSERT INTO `master_kab_kota` VALUES (48, 3, 'KAB. NIAS BARAT', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '22895', 308, 34);
  INSERT INTO `master_kab_kota` VALUES (49, 3, 'KOTA MEDAN', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '20228', 278, 34);
  INSERT INTO `master_kab_kota` VALUES (50, 3, 'KOTA PEMATANG SIANTAR', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '21126', 353, 34);
  INSERT INTO `master_kab_kota` VALUES (51, 3, 'KOTA SIBOLGA', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '22522', 407, 34);
  INSERT INTO `master_kab_kota` VALUES (52, 3, 'KOTA TANJUNG BALAI', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '21321', 459, 34);
  INSERT INTO `master_kab_kota` VALUES (53, 3, 'KOTA BINJAI', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '20712', 70, 34);
  INSERT INTO `master_kab_kota` VALUES (54, 3, 'KOTA TEBING TINGGI', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '20632', 470, 34);
  INSERT INTO `master_kab_kota` VALUES (55, 3, 'KOTA PADANG SIDEMPUAN', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '22727', 323, 34);
  INSERT INTO `master_kab_kota` VALUES (56, 3, 'KOTA GUNUNG SITOLI', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, NULL, NULL, NULL);
  INSERT INTO `master_kab_kota` VALUES (57, 4, 'KAB. PESISIR SELATAN', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '25611', 357, 32);
  INSERT INTO `master_kab_kota` VALUES (58, 4, 'KAB. SOLOK', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '27365', 420, 32);
  INSERT INTO `master_kab_kota` VALUES (59, 4, 'KAB. SW. LUNTO/SIJUNJUNG', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, NULL, NULL, NULL);
  INSERT INTO `master_kab_kota` VALUES (60, 4, 'KAB. TANAH DATAR', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '27211', 453, 32);
  INSERT INTO `master_kab_kota` VALUES (61, 4, 'KAB. PADANG PARIAMAN', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '25583', 322, 32);
  INSERT INTO `master_kab_kota` VALUES (62, 4, 'KAB. AGAM', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '26411', 12, 32);
  INSERT INTO `master_kab_kota` VALUES (63, 4, 'KAB. LIMA PULUH KOTA', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, NULL, NULL, NULL);
  INSERT INTO `master_kab_kota` VALUES (64, 4, 'KAB. PASAMAN', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '26318', 339, 32);
  INSERT INTO `master_kab_kota` VALUES (65, 4, 'KAB. KEPULAUAN MENTAWAI', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '25771', 186, 32);
  INSERT INTO `master_kab_kota` VALUES (66, 4, 'KAB. DHARMASRAYA', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '27612', 116, 32);
  INSERT INTO `master_kab_kota` VALUES (67, 4, 'KAB. SOLOK SELATAN', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '27779', 422, 32);
  INSERT INTO `master_kab_kota` VALUES (68, 4, 'KAB. PASAMAN BARAT', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '26511', 340, 32);
  INSERT INTO `master_kab_kota` VALUES (69, 4, 'KOTA PADANG', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '25112', 318, 32);
  INSERT INTO `master_kab_kota` VALUES (70, 4, 'KOTA SOLOK', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '27315', 421, 32);
  INSERT INTO `master_kab_kota` VALUES (71, 4, 'KOTA SAWAHLUNTO', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, NULL, NULL, NULL);
  INSERT INTO `master_kab_kota` VALUES (72, 4, 'KOTA PADANG PANJANG', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '27122', 321, 32);
  INSERT INTO `master_kab_kota` VALUES (73, 4, 'KOTA BUKITTINGGI', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '26115', 93, 32);
  INSERT INTO `master_kab_kota` VALUES (74, 4, 'KOTA PAYAKUMBUH', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '26213', 345, 32);
  INSERT INTO `master_kab_kota` VALUES (75, 4, 'KOTA PARIAMAN', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '25511', 337, 32);
  INSERT INTO `master_kab_kota` VALUES (76, 5, 'KAB. KAMPAR', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '28411', 166, 26);
  INSERT INTO `master_kab_kota` VALUES (77, 5, 'KAB. INDRAGIRI HULU', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '29319', 148, 26);
  INSERT INTO `master_kab_kota` VALUES (78, 5, 'KAB. BENGKALIS', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '28719', 60, 26);
  INSERT INTO `master_kab_kota` VALUES (79, 5, 'KAB. INDRAGIRI HILIR', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '29212', 147, 26);
  INSERT INTO `master_kab_kota` VALUES (80, 5, 'KAB. PELALAWAN', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '28311', 351, 26);
  INSERT INTO `master_kab_kota` VALUES (81, 5, 'KAB. ROKAN HULU', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '28511', 382, 26);
  INSERT INTO `master_kab_kota` VALUES (82, 5, 'KAB. ROKAN HILIR', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '28992', 381, 26);
  INSERT INTO `master_kab_kota` VALUES (83, 5, 'KAB. SIAK', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '28623', 406, 26);
  INSERT INTO `master_kab_kota` VALUES (84, 5, 'KAB. KUANTAN SINGINGI', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '29519', 207, 26);
  INSERT INTO `master_kab_kota` VALUES (85, 5, 'KAB. KEPULAUAN MERANTI', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '28791', 187, 26);
  INSERT INTO `master_kab_kota` VALUES (86, 5, 'KOTA PEKAN BARU', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, NULL, NULL, NULL);
  INSERT INTO `master_kab_kota` VALUES (87, 5, 'KOTA DUMAI', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '28811', 120, 26);
  INSERT INTO `master_kab_kota` VALUES (88, 6, 'KAB. KERINCI', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '37167', 194, 8);
  INSERT INTO `master_kab_kota` VALUES (89, 6, 'KAB. MERANGIN', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '37319', 280, 8);
  INSERT INTO `master_kab_kota` VALUES (90, 6, 'KAB. SAROLANGUN', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '37419', 393, 8);
  INSERT INTO `master_kab_kota` VALUES (91, 6, 'KAB. BATANG HARI', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '36613', 50, 8);
  INSERT INTO `master_kab_kota` VALUES (92, 6, 'KAB. MUARO JAMBI', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '36311', 293, 8);
  INSERT INTO `master_kab_kota` VALUES (93, 6, 'KAB. TANJUNG JABUNG BARAT', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '36513', 460, 8);
  INSERT INTO `master_kab_kota` VALUES (94, 6, 'KAB. TANJUNG JABUNG TIMUR', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '36719', 461, 8);
  INSERT INTO `master_kab_kota` VALUES (95, 6, 'KAB. BUNGO', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '37216', 97, 8);
  INSERT INTO `master_kab_kota` VALUES (96, 6, 'KAB. TEBO', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '37519', 471, 8);
  INSERT INTO `master_kab_kota` VALUES (97, 6, 'KOTA JAMBI', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '36111', 156, 8);
  INSERT INTO `master_kab_kota` VALUES (98, 6, 'KOTA SUNGAI PENUH', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, NULL, NULL, NULL);
  INSERT INTO `master_kab_kota` VALUES (99, 7, 'KAB. OGAN KOMERING ULU', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '32112', 314, 33);
  INSERT INTO `master_kab_kota` VALUES (100, 7, 'KAB. OGAN KOMERING ILIR', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '30618', 313, 33);
  INSERT INTO `master_kab_kota` VALUES (101, 7, 'KAB. MUARA ENIM', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '31315', 292, 33);
  INSERT INTO `master_kab_kota` VALUES (102, 7, 'KAB. LAHAT', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '31419', 220, 33);
  INSERT INTO `master_kab_kota` VALUES (103, 7, 'KAB. MUSI RAWAS', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '31661', 298, 33);
  INSERT INTO `master_kab_kota` VALUES (104, 7, 'KAB. MUSI BANYUASIN', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '30719', 297, 33);
  INSERT INTO `master_kab_kota` VALUES (105, 7, 'KAB. BANYUASIN', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '30911', 40, 33);
  INSERT INTO `master_kab_kota` VALUES (106, 7, 'KAB. OKU TIMUR', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, NULL, NULL, NULL);
  INSERT INTO `master_kab_kota` VALUES (107, 7, 'KAB. OKU SELATAN', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, NULL, NULL, NULL);
  INSERT INTO `master_kab_kota` VALUES (108, 7, 'KAB. OGAN ILIR', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '30811', 312, 33);
  INSERT INTO `master_kab_kota` VALUES (109, 7, 'KAB. EMPAT LAWANG', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '31811', 121, 33);
  INSERT INTO `master_kab_kota` VALUES (110, 7, 'KOTA PALEMBANG', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '30111', 327, 33);
  INSERT INTO `master_kab_kota` VALUES (111, 7, 'KOTA PAGAR ALAM', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '31512', 324, 33);
  INSERT INTO `master_kab_kota` VALUES (112, 7, 'KOTA LUBUK LINGGAU', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '31614', 242, 33);
  INSERT INTO `master_kab_kota` VALUES (113, 7, 'KOTA PRABUMULIH', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '31121', 367, 33);
  INSERT INTO `master_kab_kota` VALUES (114, 8, 'KAB. BENGKULU SELATAN', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '38519', 63, 4);
  INSERT INTO `master_kab_kota` VALUES (115, 8, 'KAB. REJANG LEBONG', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '39112', 379, 4);
  INSERT INTO `master_kab_kota` VALUES (116, 8, 'KAB. BENGKULU UTARA', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '38619', 65, 4);
  INSERT INTO `master_kab_kota` VALUES (117, 8, 'KAB. KAUR', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '38911', 175, 4);
  INSERT INTO `master_kab_kota` VALUES (118, 8, 'KAB. SELUMA', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '38811', 397, 4);
  INSERT INTO `master_kab_kota` VALUES (119, 8, 'KAB. MUKO MUKO', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '38715', 294, 4);
  INSERT INTO `master_kab_kota` VALUES (120, 8, 'KAB. LEBONG', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '39264', 233, 4);
  INSERT INTO `master_kab_kota` VALUES (121, 8, 'KAB. KEPAHIANG', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '39319', 183, 4);
  INSERT INTO `master_kab_kota` VALUES (122, 8, 'KAB. BENGKULU TENGAH', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '38319', 64, 4);
  INSERT INTO `master_kab_kota` VALUES (123, 8, 'KOTA BENGKULU', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '38229', 62, 4);
  INSERT INTO `master_kab_kota` VALUES (124, 9, 'KAB. LAMPUNG SELATAN', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '35511', 224, 18);
  INSERT INTO `master_kab_kota` VALUES (125, 9, 'KAB. LAMPUNG TENGAH', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '34212', 225, 18);
  INSERT INTO `master_kab_kota` VALUES (126, 9, 'KAB. LAMPUNG UTARA', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '34516', 227, 18);
  INSERT INTO `master_kab_kota` VALUES (127, 9, 'KAB. LAMPUNG BARAT', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '34814', 223, 18);
  INSERT INTO `master_kab_kota` VALUES (128, 9, 'KAB. TULANG BAWANG', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '34613', 490, 18);
  INSERT INTO `master_kab_kota` VALUES (129, 9, 'KAB. TANGGAMUS', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '35619', 458, 18);
  INSERT INTO `master_kab_kota` VALUES (130, 9, 'KAB. LAMPUNG TIMUR', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '34319', 226, 18);
  INSERT INTO `master_kab_kota` VALUES (131, 9, 'KAB. WAY KANAN', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '34711', 496, 18);
  INSERT INTO `master_kab_kota` VALUES (132, 9, 'KAB. PESAWARAN', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '35312', 355, 18);
  INSERT INTO `master_kab_kota` VALUES (133, 9, 'KAB. PRINGSEWU', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '35719', 368, 18);
  INSERT INTO `master_kab_kota` VALUES (134, 9, 'KAB. MESUJI', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '34911', 282, 18);
  INSERT INTO `master_kab_kota` VALUES (135, 9, 'KAB. TULANG BAWANG BARAT', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '34419', 491, 18);
  INSERT INTO `master_kab_kota` VALUES (136, 9, 'KOTA BANDAR LAMPUNG', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '35139', 21, 18);
  INSERT INTO `master_kab_kota` VALUES (137, 9, 'KOTA METRO', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '34111', 283, 18);
  INSERT INTO `master_kab_kota` VALUES (138, 10, 'KAB. BANGKA', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '33212', 27, 2);
  INSERT INTO `master_kab_kota` VALUES (139, 10, 'KAB. BELITUNG', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '33419', 56, 2);
  INSERT INTO `master_kab_kota` VALUES (140, 10, 'KAB. BANGKA SELATAN', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '33719', 29, 2);
  INSERT INTO `master_kab_kota` VALUES (141, 10, 'KAB. BANGKA TENGAH', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '33613', 30, 2);
  INSERT INTO `master_kab_kota` VALUES (142, 10, 'KAB. BANGKA BARAT', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '33315', 28, 2);
  INSERT INTO `master_kab_kota` VALUES (143, 10, 'KAB. BELITUNG TIMUR', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '33519', 57, 2);
  INSERT INTO `master_kab_kota` VALUES (144, 10, 'KOTA PANGKAL PINANG', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '33115', 334, 2);
  INSERT INTO `master_kab_kota` VALUES (145, 11, 'KAB. BINTAN', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '29135', 71, 17);
  INSERT INTO `master_kab_kota` VALUES (146, 11, 'KAB. KARIMUN', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '29611', 172, 17);
  INSERT INTO `master_kab_kota` VALUES (147, 11, 'KAB. NATUNA', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '29711', 302, 17);
  INSERT INTO `master_kab_kota` VALUES (148, 11, 'KAB. LINGGA', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '29811', 237, 17);
  INSERT INTO `master_kab_kota` VALUES (149, 11, 'KAB. KEPULAUAN ANAMBAS', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '29991', 184, 17);
  INSERT INTO `master_kab_kota` VALUES (150, 11, 'KOTA BATAM', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '29413', 48, 17);
  INSERT INTO `master_kab_kota` VALUES (151, 11, 'KOTA TANJUNG PINANG', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '29111', 462, 17);
  INSERT INTO `master_kab_kota` VALUES (152, 12, 'KAB. ADM. KEP. SERIBU', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, NULL, NULL, NULL);
  INSERT INTO `master_kab_kota` VALUES (153, 12, 'KODYA JAKARTA PUSAT', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, NULL, NULL, NULL);
  INSERT INTO `master_kab_kota` VALUES (154, 12, 'KODYA JAKARTA UTARA', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, NULL, NULL, NULL);
  INSERT INTO `master_kab_kota` VALUES (155, 12, 'KODYA JAKARTA BARAT', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, NULL, NULL, NULL);
  INSERT INTO `master_kab_kota` VALUES (156, 12, 'KODYA JAKARTA SELATAN', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, NULL, NULL, NULL);
  INSERT INTO `master_kab_kota` VALUES (157, 12, 'KODYA JAKARTA TIMUR', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, NULL, NULL, NULL);
  INSERT INTO `master_kab_kota` VALUES (158, 13, 'KAB. BOGOR', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '16911', 78, 9);
  INSERT INTO `master_kab_kota` VALUES (159, 13, 'KAB. SUKABUMI', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '43311', 430, 9);
  INSERT INTO `master_kab_kota` VALUES (160, 13, 'KAB. CIANJUR', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '43217', 104, 9);
  INSERT INTO `master_kab_kota` VALUES (161, 13, 'KAB. BANDUNG', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '40311', 22, 9);
  INSERT INTO `master_kab_kota` VALUES (162, 13, 'KAB. GARUT', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '44126', 126, 9);
  INSERT INTO `master_kab_kota` VALUES (163, 13, 'KAB. TASIKMALAYA', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '46411', 468, 9);
  INSERT INTO `master_kab_kota` VALUES (164, 13, 'KAB. CIAMIS', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '46211', 103, 9);
  INSERT INTO `master_kab_kota` VALUES (165, 13, 'KAB. KUNINGAN', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '45511', 211, 9);
  INSERT INTO `master_kab_kota` VALUES (166, 13, 'KAB. CIREBON', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '45611', 108, 9);
  INSERT INTO `master_kab_kota` VALUES (167, 13, 'KAB. MAJALENGKA', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '45412', 252, 9);
  INSERT INTO `master_kab_kota` VALUES (168, 13, 'KAB. SUMEDANG', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '45326', 440, 9);
  INSERT INTO `master_kab_kota` VALUES (169, 13, 'KAB. INDRAMAYU', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '45214', 149, 9);
  INSERT INTO `master_kab_kota` VALUES (170, 13, 'KAB. SUBANG', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '41215', 428, 9);
  INSERT INTO `master_kab_kota` VALUES (171, 13, 'KAB. PURWAKARTA', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '41119', 376, 9);
  INSERT INTO `master_kab_kota` VALUES (172, 13, 'KAB. KARAWANG', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '41311', 171, 9);
  INSERT INTO `master_kab_kota` VALUES (173, 13, 'KAB. BEKASI', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '17837', 54, 9);
  INSERT INTO `master_kab_kota` VALUES (174, 13, 'KAB. BANDUNG BARAT', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '40721', 24, 9);
  INSERT INTO `master_kab_kota` VALUES (175, 13, 'KOTA BOGOR', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '16119', 79, 9);
  INSERT INTO `master_kab_kota` VALUES (176, 13, 'KOTA SUKABUMI', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '43114', 431, 9);
  INSERT INTO `master_kab_kota` VALUES (177, 13, 'KOTA BANDUNG', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '40111', 23, 9);
  INSERT INTO `master_kab_kota` VALUES (178, 13, 'KOTA CIREBON', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '45116', 109, 9);
  INSERT INTO `master_kab_kota` VALUES (179, 13, 'KOTA BEKASI', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '17121', 55, 9);
  INSERT INTO `master_kab_kota` VALUES (180, 13, 'KOTA DEPOK', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '16416', 115, 9);
  INSERT INTO `master_kab_kota` VALUES (181, 13, 'KOTA CIMAHI', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '40512', 107, 9);
  INSERT INTO `master_kab_kota` VALUES (182, 13, 'KOTA TASIKMALAYA', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '46116', 469, 9);
  INSERT INTO `master_kab_kota` VALUES (183, 13, 'KOTA BANJAR', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '46311', 34, 9);
  INSERT INTO `master_kab_kota` VALUES (184, 14, 'KAB. CILACAP', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '53211', 105, 10);
  INSERT INTO `master_kab_kota` VALUES (185, 14, 'KAB. BANYUMAS', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '53114', 41, 10);
  INSERT INTO `master_kab_kota` VALUES (186, 14, 'KAB. PURBALINGGA', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '53312', 375, 10);
  INSERT INTO `master_kab_kota` VALUES (187, 14, 'KAB. BANJARNEGARA', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '53419', 37, 10);
  INSERT INTO `master_kab_kota` VALUES (188, 14, 'KAB. KEBUMEN', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '54319', 177, 10);
  INSERT INTO `master_kab_kota` VALUES (189, 14, 'KAB. PURWOREJO', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '54111', 377, 10);
  INSERT INTO `master_kab_kota` VALUES (190, 14, 'KAB. WONOSOBO', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '56311', 498, 10);
  INSERT INTO `master_kab_kota` VALUES (191, 14, 'KAB. MAGELANG', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '56519', 249, 10);
  INSERT INTO `master_kab_kota` VALUES (192, 14, 'KAB. BOYOLALI', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '57312', 91, 10);
  INSERT INTO `master_kab_kota` VALUES (193, 14, 'KAB. KLATEN', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '57411', 196, 10);
  INSERT INTO `master_kab_kota` VALUES (194, 14, 'KAB. SUKOHARJO', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '57514', 433, 10);
  INSERT INTO `master_kab_kota` VALUES (195, 14, 'KAB. WONOGIRI', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '57619', 497, 10);
  INSERT INTO `master_kab_kota` VALUES (196, 14, 'KAB. KARANGANYAR', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '57718', 169, 10);
  INSERT INTO `master_kab_kota` VALUES (197, 14, 'KAB. SRAGEN', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '57211', 427, 10);
  INSERT INTO `master_kab_kota` VALUES (198, 14, 'KAB. GROBOGAN', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '58111', 134, 10);
  INSERT INTO `master_kab_kota` VALUES (199, 14, 'KAB. BLORA', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '58219', 76, 10);
  INSERT INTO `master_kab_kota` VALUES (200, 14, 'KAB. REMBANG', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '59219', 380, 10);
  INSERT INTO `master_kab_kota` VALUES (201, 14, 'KAB. PATI', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '59114', 344, 10);
  INSERT INTO `master_kab_kota` VALUES (202, 14, 'KAB. KUDUS', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '59311', 209, 10);
  INSERT INTO `master_kab_kota` VALUES (203, 14, 'KAB. JEPARA', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '59419', 163, 10);
  INSERT INTO `master_kab_kota` VALUES (204, 14, 'KAB. DEMAK', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '59519', 113, 10);
  INSERT INTO `master_kab_kota` VALUES (205, 14, 'KAB. SEMARANG', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '50511', 398, 10);
  INSERT INTO `master_kab_kota` VALUES (206, 14, 'KAB. TEMANGGUNG', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '56212', 476, 10);
  INSERT INTO `master_kab_kota` VALUES (207, 14, 'KAB. KENDAL', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '51314', 181, 10);
  INSERT INTO `master_kab_kota` VALUES (208, 14, 'KAB. BATANG', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '51211', 49, 10);
  INSERT INTO `master_kab_kota` VALUES (209, 14, 'KAB. PEKALONGAN', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '51161', 348, 10);
  INSERT INTO `master_kab_kota` VALUES (210, 14, 'KAB. PEMALANG', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '52319', 352, 10);
  INSERT INTO `master_kab_kota` VALUES (211, 14, 'KAB. TEGAL', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '52419', 472, 10);
  INSERT INTO `master_kab_kota` VALUES (212, 14, 'KAB. BREBES', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '52212', 92, 10);
  INSERT INTO `master_kab_kota` VALUES (213, 14, 'KOTA MAGELANG', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '56133', 250, 10);
  INSERT INTO `master_kab_kota` VALUES (214, 14, 'KOTA SURAKARTA', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, NULL, NULL, NULL);
  INSERT INTO `master_kab_kota` VALUES (215, 14, 'KOTA SALATIGA', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '50711', 386, 10);
  INSERT INTO `master_kab_kota` VALUES (216, 14, 'KOTA SEMARANG', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '50135', 399, 10);
  INSERT INTO `master_kab_kota` VALUES (217, 14, 'KOTA PEKALONGAN', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '51122', 349, 10);
  INSERT INTO `master_kab_kota` VALUES (218, 14, 'KOTA TEGAL', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '52114', 473, 10);
  INSERT INTO `master_kab_kota` VALUES (219, 15, 'KAB. KULON PROGO', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '55611', 210, 5);
  INSERT INTO `master_kab_kota` VALUES (220, 15, 'KAB. BANTUL', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '55715', 39, 5);
  INSERT INTO `master_kab_kota` VALUES (221, 15, 'KAB. GUNUNG KIDUL', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '55812', 135, 5);
  INSERT INTO `master_kab_kota` VALUES (222, 15, 'KAB. SLEMAN', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '55513', 419, 5);
  INSERT INTO `master_kab_kota` VALUES (223, 15, 'KOTA YOGYAKARTA', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '55111', 501, 5);
  INSERT INTO `master_kab_kota` VALUES (224, 16, 'KAB. PACITAN', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '63512', 317, 11);
  INSERT INTO `master_kab_kota` VALUES (225, 16, 'KAB. PONOROGO', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '63411', 363, 11);
  INSERT INTO `master_kab_kota` VALUES (226, 16, 'KAB. TRENGGALEK', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '66312', 487, 11);
  INSERT INTO `master_kab_kota` VALUES (227, 16, 'KAB. TULUNGAGUNG', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '66212', 492, 11);
  INSERT INTO `master_kab_kota` VALUES (228, 16, 'KAB. BLITAR', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '66171', 74, 11);
  INSERT INTO `master_kab_kota` VALUES (229, 16, 'KAB. KEDIRI', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '64184', 178, 11);
  INSERT INTO `master_kab_kota` VALUES (230, 16, 'KAB. MALANG', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '65163', 255, 11);
  INSERT INTO `master_kab_kota` VALUES (231, 16, 'KAB. LUMAJANG', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '67319', 243, 11);
  INSERT INTO `master_kab_kota` VALUES (232, 16, 'KAB. JEMBER', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '68113', 160, 11);
  INSERT INTO `master_kab_kota` VALUES (233, 16, 'KAB. BANYUWANGI', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '68416', 42, 11);
  INSERT INTO `master_kab_kota` VALUES (234, 16, 'KAB. BONDOWOSO', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '68219', 86, 11);
  INSERT INTO `master_kab_kota` VALUES (235, 16, 'KAB. SITUBONDO', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '68316', 418, 11);
  INSERT INTO `master_kab_kota` VALUES (236, 16, 'KAB. PROBOLINGGO', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '67282', 369, 11);
  INSERT INTO `master_kab_kota` VALUES (237, 16, 'KAB. PASURUAN', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '67153', 342, 11);
  INSERT INTO `master_kab_kota` VALUES (238, 16, 'KAB. SIDOARJO', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '61219', 409, 11);
  INSERT INTO `master_kab_kota` VALUES (239, 16, 'KAB. MOJOKERTO', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '61382', 289, 11);
  INSERT INTO `master_kab_kota` VALUES (240, 16, 'KAB. JOMBANG', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '61415', 164, 11);
  INSERT INTO `master_kab_kota` VALUES (241, 16, 'KAB. NGANJUK', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '64414', 305, 11);
  INSERT INTO `master_kab_kota` VALUES (242, 16, 'KAB. MADIUN', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '63153', 247, 11);
  INSERT INTO `master_kab_kota` VALUES (243, 16, 'KAB. MAGETAN', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '63314', 251, 11);
  INSERT INTO `master_kab_kota` VALUES (244, 16, 'KAB. NGAWI', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '63219', 306, 11);
  INSERT INTO `master_kab_kota` VALUES (245, 16, 'KAB. BOJONEGORO', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '62119', 80, 11);
  INSERT INTO `master_kab_kota` VALUES (246, 16, 'KAB. TUBAN', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '62319', 489, 11);
  INSERT INTO `master_kab_kota` VALUES (247, 16, 'KAB. LAMONGAN', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '64125', 222, 11);
  INSERT INTO `master_kab_kota` VALUES (248, 16, 'KAB. GRESIK', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '61115', 133, 11);
  INSERT INTO `master_kab_kota` VALUES (249, 16, 'KAB. BANGKALAN', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '69118', 31, 11);
  INSERT INTO `master_kab_kota` VALUES (250, 16, 'KAB. SAMPANG', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '69219', 390, 11);
  INSERT INTO `master_kab_kota` VALUES (251, 16, 'KAB. PAMEKASAN', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '69319', 330, 11);
  INSERT INTO `master_kab_kota` VALUES (252, 16, 'KAB. SUMENEP', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '69413', 441, 11);
  INSERT INTO `master_kab_kota` VALUES (253, 16, 'KOTA KEDIRI', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '64125', 179, 11);
  INSERT INTO `master_kab_kota` VALUES (254, 16, 'KOTA BLITAR', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '66124', 75, 11);
  INSERT INTO `master_kab_kota` VALUES (255, 16, 'KOTA MALANG', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '65112', 256, 11);
  INSERT INTO `master_kab_kota` VALUES (256, 16, 'KOTA PROBOLINGGO', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '67215', 370, 11);
  INSERT INTO `master_kab_kota` VALUES (257, 16, 'KOTA PASURUAN', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '67118', 343, 11);
  INSERT INTO `master_kab_kota` VALUES (258, 16, 'KOTA MOJOKERTO', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '61316', 290, 11);
  INSERT INTO `master_kab_kota` VALUES (259, 16, 'KOTA MADIUN', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '63122', 248, 11);
  INSERT INTO `master_kab_kota` VALUES (260, 16, 'KOTA SURABAYA', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '60119', 444, 11);
  INSERT INTO `master_kab_kota` VALUES (261, 16, 'KOTA BATU', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '65311', 51, 11);
  INSERT INTO `master_kab_kota` VALUES (262, 17, 'KAB. PANDEGLANG', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '42212', 331, 3);
  INSERT INTO `master_kab_kota` VALUES (263, 17, 'KAB. LEBAK', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '42319', 232, 3);
  INSERT INTO `master_kab_kota` VALUES (264, 17, 'KAB. TANGERANG', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '15914', 455, 3);
  INSERT INTO `master_kab_kota` VALUES (265, 17, 'KAB. SERANG', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '42182', 402, 3);
  INSERT INTO `master_kab_kota` VALUES (266, 17, 'KOTA TANGERANG', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '15111', 456, 3);
  INSERT INTO `master_kab_kota` VALUES (267, 17, 'KOTA CILEGON', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '42417', 106, 3);
  INSERT INTO `master_kab_kota` VALUES (268, 17, 'KOTA SERANG', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '42111', 403, 3);
  INSERT INTO `master_kab_kota` VALUES (269, 17, 'KOTA TANGERANG SELATAN', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '15332', 457, 3);
  INSERT INTO `master_kab_kota` VALUES (270, 18, 'KAB. JEMBRANA', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '82251', 161, 1);
  INSERT INTO `master_kab_kota` VALUES (271, 18, 'KAB. TABANAN', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '82119', 447, 1);
  INSERT INTO `master_kab_kota` VALUES (272, 18, 'KAB. BADUNG', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '80351', 17, 1);
  INSERT INTO `master_kab_kota` VALUES (273, 18, 'KAB. GIANYAR', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '80519', 128, 1);
  INSERT INTO `master_kab_kota` VALUES (274, 18, 'KAB. KLUNGKUNG', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '80719', 197, 1);
  INSERT INTO `master_kab_kota` VALUES (275, 18, 'KAB. BANGLI', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '80619', 32, 1);
  INSERT INTO `master_kab_kota` VALUES (276, 18, 'KAB. KARANGASEM', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '80819', 170, 1);
  INSERT INTO `master_kab_kota` VALUES (277, 18, 'KAB. BULELENG', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '81111', 94, 1);
  INSERT INTO `master_kab_kota` VALUES (278, 18, 'KOTA DENPASAR', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '80227', 114, 1);
  INSERT INTO `master_kab_kota` VALUES (279, 19, 'KAB. LOMBOK BARAT', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '83311', 238, 22);
  INSERT INTO `master_kab_kota` VALUES (280, 19, 'KAB. LOMBOK TENGAH', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '83511', 239, 22);
  INSERT INTO `master_kab_kota` VALUES (281, 19, 'KAB. LOMBOK TIMUR', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '83612', 240, 22);
  INSERT INTO `master_kab_kota` VALUES (282, 19, 'KAB. SUMBAWA', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '84315', 438, 22);
  INSERT INTO `master_kab_kota` VALUES (283, 19, 'KAB. DOMPU', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '84217', 118, 22);
  INSERT INTO `master_kab_kota` VALUES (284, 19, 'KAB. BIMA', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '84171', 68, 22);
  INSERT INTO `master_kab_kota` VALUES (285, 19, 'KAB. SUMBAWA BARAT', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '84419', 439, 22);
  INSERT INTO `master_kab_kota` VALUES (286, 19, 'KAB. LOMBOK UTARA', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '83711', 241, 22);
  INSERT INTO `master_kab_kota` VALUES (287, 19, 'KOTA MATARAM', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '83131', 276, 22);
  INSERT INTO `master_kab_kota` VALUES (288, 19, 'KOTA BIMA', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '84139', 69, 22);
  INSERT INTO `master_kab_kota` VALUES (289, 20, 'KAB. KUPANG', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '85362', 212, 23);
  INSERT INTO `master_kab_kota` VALUES (290, 20, 'KAB. TIMOR TENGAH SELATAN', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '85562', 479, 23);
  INSERT INTO `master_kab_kota` VALUES (291, 20, 'KAB. TIMOR TENGAH UTARA', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '85612', 480, 23);
  INSERT INTO `master_kab_kota` VALUES (292, 20, 'KAB. BELU', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '85711', 58, 23);
  INSERT INTO `master_kab_kota` VALUES (293, 20, 'KAB. ALOR', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '85811', 13, 23);
  INSERT INTO `master_kab_kota` VALUES (294, 20, 'KAB. FLORES TIMUR', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '86213', 125, 23);
  INSERT INTO `master_kab_kota` VALUES (295, 20, 'KAB. SIKKA', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '86121', 412, 23);
  INSERT INTO `master_kab_kota` VALUES (296, 20, 'KAB. ENDE', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '86351', 122, 23);
  INSERT INTO `master_kab_kota` VALUES (297, 20, 'KAB. NGADA', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '86413', 304, 23);
  INSERT INTO `master_kab_kota` VALUES (298, 20, 'KAB. MANGGARAI', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '86551', 269, 23);
  INSERT INTO `master_kab_kota` VALUES (299, 20, 'KAB. SUMBA TIMUR', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '87112', 437, 23);
  INSERT INTO `master_kab_kota` VALUES (300, 20, 'KAB. SUMBA BARAT', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '87219', 434, 23);
  INSERT INTO `master_kab_kota` VALUES (301, 20, 'KAB. LEMBATA', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '86611', 234, 23);
  INSERT INTO `master_kab_kota` VALUES (302, 20, 'KAB. ROTE NDAO', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '85982', 383, 23);
  INSERT INTO `master_kab_kota` VALUES (303, 20, 'KAB. MANGGARAI BARAT', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '86711', 270, 23);
  INSERT INTO `master_kab_kota` VALUES (304, 20, 'KAB. NAGEKEO', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '86911', 301, 23);
  INSERT INTO `master_kab_kota` VALUES (305, 20, 'KAB. SUMBA TENGAH', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '87358', 436, 23);
  INSERT INTO `master_kab_kota` VALUES (306, 20, 'KAB. SUMBA BARAT DAYA', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '87453', 435, 23);
  INSERT INTO `master_kab_kota` VALUES (307, 20, 'KAB. MANGGARAI TIMUR', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '86811', 271, 23);
  INSERT INTO `master_kab_kota` VALUES (308, 20, 'KAB. SABU RAIJUA', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '85391', 385, 23);
  INSERT INTO `master_kab_kota` VALUES (309, 20, 'KOTA KUPANG', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '85119', 213, 23);
  INSERT INTO `master_kab_kota` VALUES (310, 21, 'KAB. SAMBAS', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '79453', 388, 12);
  INSERT INTO `master_kab_kota` VALUES (311, 21, 'KOTA PONTIANAK', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '78112', 365, 12);
  INSERT INTO `master_kab_kota` VALUES (312, 21, 'KAB. SANGGAU', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '78557', 391, 12);
  INSERT INTO `master_kab_kota` VALUES (313, 21, 'KAB. KETAPANG', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '78874', 195, 12);
  INSERT INTO `master_kab_kota` VALUES (314, 21, 'KAB. SINTANG', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '78619', 417, 12);
  INSERT INTO `master_kab_kota` VALUES (315, 21, 'KAB. KAPUAS HULU', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '78719', 168, 12);
  INSERT INTO `master_kab_kota` VALUES (316, 21, 'KAB. BENGKAYANG', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '79213', 61, 12);
  INSERT INTO `master_kab_kota` VALUES (317, 21, 'KAB. LANDAK', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '78319', 228, 12);
  INSERT INTO `master_kab_kota` VALUES (318, 21, 'KAB. SEKADAU', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '79583', 395, 12);
  INSERT INTO `master_kab_kota` VALUES (319, 21, 'KAB. MELAWI', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '78619', 279, 12);
  INSERT INTO `master_kab_kota` VALUES (320, 21, 'KAB. KAYONG UTARA', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '78852', 176, 12);
  INSERT INTO `master_kab_kota` VALUES (321, 21, 'KAB. KUBU RAYA', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '78311', 208, 12);
  INSERT INTO `master_kab_kota` VALUES (322, 22, 'KAB. KOTAWARINGIN BARAT', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '74119', 205, 14);
  INSERT INTO `master_kab_kota` VALUES (323, 22, 'KAB. KOTAWARINGIN TIMUR', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '74364', 206, 14);
  INSERT INTO `master_kab_kota` VALUES (324, 22, 'KAB. KAPUAS', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '73583', 167, 14);
  INSERT INTO `master_kab_kota` VALUES (325, 22, 'KAB. BARITO SELATAN', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '73711', 44, 14);
  INSERT INTO `master_kab_kota` VALUES (326, 22, 'KAB. BARITO UTARA', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '73881', 46, 14);
  INSERT INTO `master_kab_kota` VALUES (327, 22, 'KAB. KATINGAN', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '74411', 174, 14);
  INSERT INTO `master_kab_kota` VALUES (328, 22, 'KAB. SERUYAN', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '74211', 405, 14);
  INSERT INTO `master_kab_kota` VALUES (329, 22, 'KAB. SUKAMARA', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '74712', 432, 14);
  INSERT INTO `master_kab_kota` VALUES (330, 22, 'KAB. LAMANDAU', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '74611', 221, 14);
  INSERT INTO `master_kab_kota` VALUES (331, 22, 'KAB. GUNUNGMAS', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, NULL, NULL, NULL);
  INSERT INTO `master_kab_kota` VALUES (332, 22, 'KAB. PULANG PISAU', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '74811', 371, 14);
  INSERT INTO `master_kab_kota` VALUES (333, 22, 'KAB. MURUNG RAYA', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '73911', 296, 14);
  INSERT INTO `master_kab_kota` VALUES (334, 22, 'KAB. BARITO TIMUR', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '73671', 45, 14);
  INSERT INTO `master_kab_kota` VALUES (335, 22, 'KOTA PALANGKARAYA', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, NULL, NULL, NULL);
  INSERT INTO `master_kab_kota` VALUES (336, 23, 'KAB. TANAH LAUT', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '70811', 454, 13);
  INSERT INTO `master_kab_kota` VALUES (337, 23, 'KAB. KOTABARU', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '72119', 203, 13);
  INSERT INTO `master_kab_kota` VALUES (338, 23, 'KAB. BANJAR', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '70619', 33, 13);
  INSERT INTO `master_kab_kota` VALUES (339, 23, 'KAB. BARITO KUALA', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '70511', 43, 13);
  INSERT INTO `master_kab_kota` VALUES (340, 23, 'KAB. TAPIN', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '71119', 466, 13);
  INSERT INTO `master_kab_kota` VALUES (341, 23, 'KAB. HULU SUNGAI SELATAN', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '71212', 143, 13);
  INSERT INTO `master_kab_kota` VALUES (342, 23, 'KAB. HULU SUNGAI TENGAH', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '71313', 144, 13);
  INSERT INTO `master_kab_kota` VALUES (343, 23, 'KAB. HULU SUNGAI UTARA', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '71419', 145, 13);
  INSERT INTO `master_kab_kota` VALUES (344, 23, 'KAB. TABALONG', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '71513', 446, 13);
  INSERT INTO `master_kab_kota` VALUES (345, 23, 'KAB. TANAH BUMBU', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '72211', 452, 13);
  INSERT INTO `master_kab_kota` VALUES (346, 23, 'KAB. BALANGAN', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '71611', 18, 13);
  INSERT INTO `master_kab_kota` VALUES (347, 23, 'KOTA BANJARMASIN', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '70117', 36, 13);
  INSERT INTO `master_kab_kota` VALUES (348, 23, 'KOTA BANJARBARU', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '70712', 35, 13);
  INSERT INTO `master_kab_kota` VALUES (349, 24, 'KAB. PASER', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '76211', 341, 15);
  INSERT INTO `master_kab_kota` VALUES (350, 24, 'KAB. KUTAI KARTANEGARA', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '75511', 215, 15);
  INSERT INTO `master_kab_kota` VALUES (351, 24, 'KAB. BERAU', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '77311', 66, 15);
  INSERT INTO `master_kab_kota` VALUES (352, 35, 'KAB. BULUNGAN', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, NULL, NULL, NULL);
  INSERT INTO `master_kab_kota` VALUES (353, 35, 'KAB. NUNUKAN', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '77421', 311, 16);
  INSERT INTO `master_kab_kota` VALUES (354, 35, 'KAB. MALINAU', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '77511', 257, 16);
  INSERT INTO `master_kab_kota` VALUES (355, 24, 'KAB. KUTAI BARAT', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '75711', 214, 15);
  INSERT INTO `master_kab_kota` VALUES (356, 24, 'KAB. KUTAI TIMUR', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '75611', 216, 15);
  INSERT INTO `master_kab_kota` VALUES (357, 24, 'KAB. PENAJAM PASER UTARA', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '76311', 354, 15);
  INSERT INTO `master_kab_kota` VALUES (358, 35, 'KAB. TANA TIDUNG', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '77611', 450, 16);
  INSERT INTO `master_kab_kota` VALUES (359, 24, 'KOTA BALIKPAPAN', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '76111', 19, 15);
  INSERT INTO `master_kab_kota` VALUES (360, 24, 'KOTA SAMARINDA', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '75133', 387, 15);
  INSERT INTO `master_kab_kota` VALUES (361, 35, 'KOTA TARAKAN', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '77114', 467, 16);
  INSERT INTO `master_kab_kota` VALUES (362, 24, 'KOTA BONTANG', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '75313', 89, 15);
  INSERT INTO `master_kab_kota` VALUES (363, 25, 'KAB. BOLAANG MONGONDOW', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, NULL, NULL, NULL);
  INSERT INTO `master_kab_kota` VALUES (364, 25, 'KAB. MINAHASA', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '95614', 285, 31);
  INSERT INTO `master_kab_kota` VALUES (365, 25, 'KAB. KEPULAUAN SANGIHE', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '95819', 188, 31);
  INSERT INTO `master_kab_kota` VALUES (366, 25, 'KAB. KEPULAUAN TALAUD', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '95885', 192, 31);
  INSERT INTO `master_kab_kota` VALUES (367, 25, 'KAB. MINAHASA SELATAN', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '95914', 286, 31);
  INSERT INTO `master_kab_kota` VALUES (368, 25, 'KAB. MINAHASA UTARA', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '95316', 288, 31);
  INSERT INTO `master_kab_kota` VALUES (369, 25, 'KAB. MINAHASA TENGGARA', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '95995', 287, 31);
  INSERT INTO `master_kab_kota` VALUES (370, 25, 'KAB. BOLAANG MONGONDOW UTARA', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '95765', 84, 31);
  INSERT INTO `master_kab_kota` VALUES (371, 25, 'KAB. KEP. SITARO', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, NULL, NULL, NULL);
  INSERT INTO `master_kab_kota` VALUES (372, 25, 'KAB. BOLAANG MONGONDOW TIMUR', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '95783', 83, 31);
  INSERT INTO `master_kab_kota` VALUES (373, 25, 'KAB. BOLAANG MONGONDOW SELATAN', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '95774', 82, 31);
  INSERT INTO `master_kab_kota` VALUES (374, 25, 'KOTA MANADO', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '95247', 267, 31);
  INSERT INTO `master_kab_kota` VALUES (375, 25, 'KOTA BITUNG', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '95512', 73, 31);
  INSERT INTO `master_kab_kota` VALUES (376, 25, 'KOTA TOMOHON', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '95416', 485, 31);
  INSERT INTO `master_kab_kota` VALUES (377, 25, 'KOTA KOTAMOBAGU', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '95711', 204, 31);
  INSERT INTO `master_kab_kota` VALUES (378, 26, 'KAB. BANGGAI', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '94711', 25, 29);
  INSERT INTO `master_kab_kota` VALUES (379, 26, 'KAB. POSO', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '94615', 366, 29);
  INSERT INTO `master_kab_kota` VALUES (380, 26, 'KAB. DONGGALA', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '94341', 119, 29);
  INSERT INTO `master_kab_kota` VALUES (381, 26, 'KAB. TOLI TOLI', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, NULL, NULL, NULL);
  INSERT INTO `master_kab_kota` VALUES (382, 26, 'KAB. BUOL', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '94564', 98, 29);
  INSERT INTO `master_kab_kota` VALUES (383, 26, 'KAB. MOROWALI', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '94911', 291, 29);
  INSERT INTO `master_kab_kota` VALUES (384, 26, 'KAB. BANGGAI KEPULAUAN', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '94881', 26, 29);
  INSERT INTO `master_kab_kota` VALUES (385, 26, 'KAB. PARIGI MOUTONG', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '94411', 338, 29);
  INSERT INTO `master_kab_kota` VALUES (386, 26, 'KAB. TOJO UNA UNA', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, NULL, NULL, NULL);
  INSERT INTO `master_kab_kota` VALUES (387, 26, 'KAB. SIGI', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '94364', 410, 29);
  INSERT INTO `master_kab_kota` VALUES (388, 26, 'KOTA PALU', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '94111', 329, 29);
  INSERT INTO `master_kab_kota` VALUES (389, 27, 'KAB. KEPULAUAN SELAYAR', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, NULL, NULL, NULL);
  INSERT INTO `master_kab_kota` VALUES (390, 27, 'KAB. BULUKUMBA', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '92511', 95, 28);
  INSERT INTO `master_kab_kota` VALUES (391, 27, 'KAB. BANTAENG', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '92411', 38, 28);
  INSERT INTO `master_kab_kota` VALUES (392, 27, 'KAB. JENEPONTO', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '92319', 162, 28);
  INSERT INTO `master_kab_kota` VALUES (393, 27, 'KAB. TAKALAR', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '92212', 448, 28);
  INSERT INTO `master_kab_kota` VALUES (394, 27, 'KAB. GOWA', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '92111', 132, 28);
  INSERT INTO `master_kab_kota` VALUES (395, 27, 'KAB. SINJAI', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '92615', 416, 28);
  INSERT INTO `master_kab_kota` VALUES (396, 27, 'KAB. BONE', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '92713', 87, 28);
  INSERT INTO `master_kab_kota` VALUES (397, 27, 'KAB. MAROS', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '90511', 275, 28);
  INSERT INTO `master_kab_kota` VALUES (398, 27, 'KAB. PANGKAJENE KEP.', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, NULL, NULL, NULL);
  INSERT INTO `master_kab_kota` VALUES (399, 27, 'KAB. BARRU', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '90719', 47, 28);
  INSERT INTO `master_kab_kota` VALUES (400, 27, 'KAB. SOPPENG', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '90812', 423, 28);
  INSERT INTO `master_kab_kota` VALUES (401, 27, 'KAB. WAJO', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '90911', 493, 28);
  INSERT INTO `master_kab_kota` VALUES (402, 27, 'KAB. SIDENRENG RAPPANG', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, NULL, NULL, NULL);
  INSERT INTO `master_kab_kota` VALUES (403, 27, 'KAB. PINRANG', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '91251', 360, 28);
  INSERT INTO `master_kab_kota` VALUES (404, 27, 'KAB. ENREKANG', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '91719', 123, 28);
  INSERT INTO `master_kab_kota` VALUES (405, 27, 'KAB. LUWU', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '91994', 244, 28);
  INSERT INTO `master_kab_kota` VALUES (406, 27, 'KAB. TANA TORAJA', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '91819', 451, 28);
  INSERT INTO `master_kab_kota` VALUES (407, 27, 'KAB. POLEWALI MAMASA', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, NULL, NULL, NULL);
  INSERT INTO `master_kab_kota` VALUES (408, 27, 'KAB. MAJENE', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '91411', 253, 27);
  INSERT INTO `master_kab_kota` VALUES (409, 27, 'KAB. MAMUJU', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '91519', 265, 27);
  INSERT INTO `master_kab_kota` VALUES (410, 27, 'KAB. LUWU UTARA', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '92911', 246, 28);
  INSERT INTO `master_kab_kota` VALUES (411, 27, 'KAB. MAMASA', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '91362', 262, 27);
  INSERT INTO `master_kab_kota` VALUES (412, 27, 'KAB. LUWU TIMUR', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '92981', 245, 28);
  INSERT INTO `master_kab_kota` VALUES (413, 27, 'KAB. MAMUJU UTARA', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '91571', 266, 27);
  INSERT INTO `master_kab_kota` VALUES (414, 27, 'KAB. TORAJA UTARA', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '91831', 486, 28);
  INSERT INTO `master_kab_kota` VALUES (415, 27, 'KOTA MAKASAR', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, NULL, NULL, NULL);
  INSERT INTO `master_kab_kota` VALUES (416, 27, 'KOTA PARE PARE', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, NULL, NULL, NULL);
  INSERT INTO `master_kab_kota` VALUES (417, 27, 'KOTA PALOPO', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '91911', 328, 28);
  INSERT INTO `master_kab_kota` VALUES (418, 28, 'KAB. KOLAKA', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '93511', 198, 30);
  INSERT INTO `master_kab_kota` VALUES (419, 28, 'KAB. KONAWE', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '93411', 200, 30);
  INSERT INTO `master_kab_kota` VALUES (420, 28, 'KAB. MUNA', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '93611', 295, 30);
  INSERT INTO `master_kab_kota` VALUES (421, 28, 'KAB. BUTON', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '93754', 101, 30);
  INSERT INTO `master_kab_kota` VALUES (422, 28, 'KAB. KONAWE SELATAN', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '93811', 201, 30);
  INSERT INTO `master_kab_kota` VALUES (423, 28, 'KAB. BOMBANA', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '93771', 85, 30);
  INSERT INTO `master_kab_kota` VALUES (424, 28, 'KAB. WAKATOBI', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '93791', 494, 30);
  INSERT INTO `master_kab_kota` VALUES (425, 28, 'KAB. KOLAKA UTARA', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '93911', 199, 30);
  INSERT INTO `master_kab_kota` VALUES (426, 28, 'KAB. KONAWE UTARA', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '93311', 202, 30);
  INSERT INTO `master_kab_kota` VALUES (427, 28, 'KAB. BUTON UTARA', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '93745', 102, 30);
  INSERT INTO `master_kab_kota` VALUES (428, 28, 'KOTA KENDARI', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '93126', 182, 30);
  INSERT INTO `master_kab_kota` VALUES (429, 28, 'KOTA BAU BAU', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, NULL, NULL, NULL);
  INSERT INTO `master_kab_kota` VALUES (430, 29, 'KAB. GORONTALO', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '96218', 129, 7);
  INSERT INTO `master_kab_kota` VALUES (431, 29, 'KAB. BOALEMO', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '96319', 77, 7);
  INSERT INTO `master_kab_kota` VALUES (432, 29, 'KAB. BONE BOLANGO', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '96511', 88, 7);
  INSERT INTO `master_kab_kota` VALUES (433, 29, 'KAB. PAHUWATO', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, NULL, NULL, NULL);
  INSERT INTO `master_kab_kota` VALUES (434, 29, 'KAB.GORONTALO UTARA', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '96611', 131, 7);
  INSERT INTO `master_kab_kota` VALUES (435, 29, 'KOTA GORONTALO', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '96115', 130, 7);
  INSERT INTO `master_kab_kota` VALUES (436, 30, 'KAB. PASANGKAYU', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, NULL, NULL, NULL);
  INSERT INTO `master_kab_kota` VALUES (437, 30, 'KAB. MAMUJU', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '91519', 265, 27);
  INSERT INTO `master_kab_kota` VALUES (438, 30, 'KAB. MAMASA', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '91362', 262, 27);
  INSERT INTO `master_kab_kota` VALUES (439, 30, 'KAB. POLEWALI MANDAR', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '91311', 362, 27);
  INSERT INTO `master_kab_kota` VALUES (440, 30, 'KAB. MAJENE', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '91411', 253, 27);
  INSERT INTO `master_kab_kota` VALUES (441, 31, 'KAB. MALUKU TENGAH', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '97513', 259, 19);
  INSERT INTO `master_kab_kota` VALUES (442, 31, 'KAB. MALUKU TENGGARA', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '97651', 260, 19);
  INSERT INTO `master_kab_kota` VALUES (443, 31, 'KAB. MALUKU TENGGARA BARAT', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '97465', 261, 19);
  INSERT INTO `master_kab_kota` VALUES (444, 31, 'KAB. BURU', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '97371', 99, 19);
  INSERT INTO `master_kab_kota` VALUES (445, 31, 'KAB. SERAM BAGIAN TIMUR', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '97581', 401, 19);
  INSERT INTO `master_kab_kota` VALUES (446, 31, 'KAB. SERAM BAGIAN BARAT', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '97561', 400, 19);
  INSERT INTO `master_kab_kota` VALUES (447, 31, 'KAB. KEPULAUAN ARU', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '97681', 185, 19);
  INSERT INTO `master_kab_kota` VALUES (448, 31, 'KAB. MALUKU BARAT DAYA', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '97451', 258, 19);
  INSERT INTO `master_kab_kota` VALUES (449, 31, 'KAB. BURU SELATAN', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '97351', 100, 19);
  INSERT INTO `master_kab_kota` VALUES (450, 31, 'KOTA AMBON', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '97222', 14, 19);
  INSERT INTO `master_kab_kota` VALUES (451, 31, 'KOTA TUAL', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '97612', 488, 19);
  INSERT INTO `master_kab_kota` VALUES (452, 32, 'KAB. HALMAHERA BARAT', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '97757', 138, 20);
  INSERT INTO `master_kab_kota` VALUES (453, 32, 'KAB. HALMAHERA TENGAH', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '97853', 140, 20);
  INSERT INTO `master_kab_kota` VALUES (454, 32, 'KAB. HALMAHERA UTARA', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '97762', 142, 20);
  INSERT INTO `master_kab_kota` VALUES (455, 32, 'KAB. HALMAHERA SELATAN', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '97911', 139, 20);
  INSERT INTO `master_kab_kota` VALUES (456, 32, 'KAB. KEPULAUAN SULA', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '97995', 191, 20);
  INSERT INTO `master_kab_kota` VALUES (457, 32, 'KAB. HALMAHERA TIMUR', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '97862', 141, 20);
  INSERT INTO `master_kab_kota` VALUES (458, 32, 'KAB. PULAU MOROTAI', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '97771', 372, 20);
  INSERT INTO `master_kab_kota` VALUES (459, 32, 'KOTA TERNATE', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '97714', 477, 20);
  INSERT INTO `master_kab_kota` VALUES (460, 32, 'KOTA TIDORE KEPULAUAN', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '97815', 478, 20);
  INSERT INTO `master_kab_kota` VALUES (461, 33, 'KAB. MERAUKE', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '99613', 281, 24);
  INSERT INTO `master_kab_kota` VALUES (462, 33, 'KAB. JAYAWIJAYA', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '99511', 159, 24);
  INSERT INTO `master_kab_kota` VALUES (463, 33, 'KAB. JAYAPURA', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '99352', 157, 24);
  INSERT INTO `master_kab_kota` VALUES (464, 33, 'KAB. NABIRE', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '98816', 299, 24);
  INSERT INTO `master_kab_kota` VALUES (465, 33, 'KAB. KEPULAUAN YAPEN', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, NULL, NULL, NULL);
  INSERT INTO `master_kab_kota` VALUES (466, 33, 'KAB. BIAK NUMFOR', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '98119', 67, 24);
  INSERT INTO `master_kab_kota` VALUES (467, 33, 'KAB. PUNCAK JAYA', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '98979', 374, 24);
  INSERT INTO `master_kab_kota` VALUES (468, 33, 'KAB. PANIAI', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '98765', 335, 24);
  INSERT INTO `master_kab_kota` VALUES (469, 33, 'KAB. MIMIKA', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '99962', 284, 24);
  INSERT INTO `master_kab_kota` VALUES (470, 33, 'KAB. SARMI', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '99373', 392, 24);
  INSERT INTO `master_kab_kota` VALUES (471, 33, 'KAB. KEEROM', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '99461', 180, 24);
  INSERT INTO `master_kab_kota` VALUES (472, 33, 'KAB. PEGUNUNGAN BINTANG', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '99573', 347, 24);
  INSERT INTO `master_kab_kota` VALUES (473, 33, 'KAB. YAHUKIMO', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '99041', 499, 24);
  INSERT INTO `master_kab_kota` VALUES (474, 33, 'KAB. TOLIKARA', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '99411', 484, 24);
  INSERT INTO `master_kab_kota` VALUES (475, 33, 'KAB. WAROPEN', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '98269', 495, 24);
  INSERT INTO `master_kab_kota` VALUES (476, 33, 'KAB. BOVEN DIGOEL', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '99662', 90, 24);
  INSERT INTO `master_kab_kota` VALUES (477, 33, 'KAB. MAPPI', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '99853', 274, 24);
  INSERT INTO `master_kab_kota` VALUES (478, 33, 'KAB. ASMAT', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '99777', 16, 24);
  INSERT INTO `master_kab_kota` VALUES (479, 33, 'KAB. SUPIORI', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '98164', 443, 24);
  INSERT INTO `master_kab_kota` VALUES (480, 33, 'KAB. MAMBERAMO RAYA', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '99381', 263, 24);
  INSERT INTO `master_kab_kota` VALUES (481, 33, 'KAB. MAMBERAMO TENGAH', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '99553', 264, 24);
  INSERT INTO `master_kab_kota` VALUES (482, 33, 'KAB. YALIMO', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '99481', 500, 24);
  INSERT INTO `master_kab_kota` VALUES (483, 33, 'KAB. LANNY JAYA', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '99531', 231, 24);
  INSERT INTO `master_kab_kota` VALUES (484, 33, 'KAB. NDUGA', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '99541', 303, 24);
  INSERT INTO `master_kab_kota` VALUES (485, 33, 'KAB. PUNCAK', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '98981', 373, 24);
  INSERT INTO `master_kab_kota` VALUES (486, 33, 'KAB. DOGIYAI', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '98866', 117, 24);
  INSERT INTO `master_kab_kota` VALUES (487, 33, 'KAB. INTAN JAYA', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '98771', 150, 24);
  INSERT INTO `master_kab_kota` VALUES (488, 33, 'KAB. DEIYAI', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, NULL, NULL, NULL);
  INSERT INTO `master_kab_kota` VALUES (489, 33, 'KOTA JAYAPURA', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '99114', 158, 24);
  INSERT INTO `master_kab_kota` VALUES (490, 34, 'KAB. SORONG', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '98431', 424, 25);
  INSERT INTO `master_kab_kota` VALUES (491, 34, 'KAB. MANOKWARI', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '98311', 272, 25);
  INSERT INTO `master_kab_kota` VALUES (492, 34, 'KAB. FAK FAK', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, NULL, NULL, NULL);
  INSERT INTO `master_kab_kota` VALUES (493, 34, 'KAB. SORONG SELATAN', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '98454', 426, 25);
  INSERT INTO `master_kab_kota` VALUES (494, 34, 'KAB. RAJA AMPAT', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '98489', 378, 25);
  INSERT INTO `master_kab_kota` VALUES (495, 34, 'KAB. TELUK BENTUNI', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, NULL, NULL, NULL);
  INSERT INTO `master_kab_kota` VALUES (496, 34, 'KAB. TELUK WONDAMA', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '98591', 475, 25);
  INSERT INTO `master_kab_kota` VALUES (497, 34, 'KAB. KAIMANA', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '98671', 165, 25);
  INSERT INTO `master_kab_kota` VALUES (498, 34, 'KAB. TAMBRAUW', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '98475', 449, 25);
  INSERT INTO `master_kab_kota` VALUES (499, 34, 'KAB. MAYBRAT', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '98051', 277, 25);
  INSERT INTO `master_kab_kota` VALUES (500, 34, 'KOTA SORONG', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '98411', 425, 25);
  INSERT INTO `master_kab_kota` VALUES (501, 24, 'KAB. MAHAKAM ULU', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, NULL, NULL, NULL);
  INSERT INTO `master_kab_kota` VALUES (502, 28, 'KAB. KOLAKA TIMUR', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, NULL, NULL, NULL);
  INSERT INTO `master_kab_kota` VALUES (503, 26, 'KAB. MOROWALI UTARA', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, NULL, NULL, NULL);
  INSERT INTO `master_kab_kota` VALUES (504, 7, 'KAB. MUSI RAWAS UTARA', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, NULL, NULL, NULL);
  INSERT INTO `master_kab_kota` VALUES (505, 32, 'KAB. PULAU TALIABU', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, NULL, NULL, NULL);
  INSERT INTO `master_kab_kota` VALUES (506, 28, 'KAB. BUTON TENGAH', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, NULL, NULL, NULL);
  INSERT INTO `master_kab_kota` VALUES (507, 21, 'KAB. MEMPAWAH', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, NULL, NULL, NULL);
  INSERT INTO `master_kab_kota` VALUES (508, 13, 'KAB. PANGANDARAN', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '46511', 332, 9);
  INSERT INTO `master_kab_kota` VALUES (509, 9, 'KAB. PESISIR BARAT', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, '35974', 356, 18);
  INSERT INTO `master_kab_kota` VALUES (510, 28, 'KAB. KONAWE KEPULAUAN', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, NULL, NULL, NULL);
  INSERT INTO `master_kab_kota` VALUES (511, 28, 'KAB. MUNA BARAT', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, NULL, NULL, NULL);
  INSERT INTO `master_kab_kota` VALUES (512, 28, 'KAB. BUTON SELATAN', '2021-01-01 00:00:00.000000', NULL, NULL, NULL, NULL, NULL, NULL);
  
  -- ----------------------------
  -- Table structure for master_kategori
  -- ----------------------------
  DROP TABLE IF EXISTS `master_kategori`;
  CREATE TABLE `master_kategori`  (
    `kode_kategori` int(11) NOT NULL AUTO_INCREMENT,
    `nama_kategori` char(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
    `created_at` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),
    `updated_at` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),
    PRIMARY KEY (`kode_kategori`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of master_kategori
  -- ----------------------------
  INSERT INTO `master_kategori` VALUES (1, 'Shirt', '2021-04-01 20:17:47', '2021-04-01 20:17:47');
  INSERT INTO `master_kategori` VALUES (2, 'T-Shirt', '2021-04-01 20:18:01', '2021-04-01 20:18:01');
  
  -- ----------------------------
  -- Table structure for master_kode_warna
  -- ----------------------------
  DROP TABLE IF EXISTS `master_kode_warna`;
  CREATE TABLE `master_kode_warna`  (
    `kode_warna` int(11) NOT NULL AUTO_INCREMENT,
    `nama_warna` char(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    `created_at` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),
    `updated_at` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),
    PRIMARY KEY (`kode_warna`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
  
  -- ----------------------------
  -- Records of master_kode_warna
  -- ----------------------------
  INSERT INTO `master_kode_warna` VALUES (1, 'MAROON', '2021-04-05 04:56:56', '2021-04-05 04:56:56');
  INSERT INTO `master_kode_warna` VALUES (2, 'YELLOW', '2021-04-05 04:57:06', '2021-04-05 04:57:06');
  INSERT INTO `master_kode_warna` VALUES (3, 'LIGHT GREY', '2021-04-05 04:57:12', '2021-04-05 04:57:12');
  
  -- ----------------------------
  -- Table structure for master_produk
  -- ----------------------------
  DROP TABLE IF EXISTS `master_produk`;
  CREATE TABLE `master_produk`  (
    `initial_produk` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    `kode_kategori` int(11) NOT NULL,
    `kode_admin` int(11) NULL DEFAULT NULL COMMENT '?',
    `nama_produk` varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    `harga_produk` decimal(12, 2) NOT NULL,
    `status_produk` int(11) NOT NULL DEFAULT 1,
    `created_by` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    `updated_by` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    `created_at` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0),
    `updated_at` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0),
    `deskripsi_produk` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
    `berat_produk` decimal(20, 2) NULL DEFAULT NULL,
    PRIMARY KEY (`initial_produk`) USING BTREE
  ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
  
  -- ----------------------------
  -- Records of master_produk
  -- ----------------------------
  INSERT INTO `master_produk` VALUES ('NS-0001', 1, 1, 'CREW NECK JUMPER PARDON MY FRENCH CLUB', 130000.00, 1, '1', NULL, '2021-05-22 12:38:32', NULL, 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. In convallis tempor libero quis sollicitudin. Nunc convallis semper lorem eget accumsan. Phasellus consectetur consequat risus, sed vestibulum felis tincidunt id. Integer in lacinia purus, vitae tempor risus. Aliquam dignissim eros eget elit fringilla venenatis.', 0.22);
  INSERT INTO `master_produk` VALUES ('NS-0002', 1, 1, 'BOMBER ZIPPED WORLD FLAGS', 120000.00, 1, '1', NULL, '2021-05-22 14:52:27', NULL, 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. In convallis tempor libero quis sollicitudin. Nunc convallis semper lorem eget accumsan. Phasellus consectetur consequat risus, sed vestibulum felis tincidunt id. Integer in lacinia purus, vitae tempor risus. Aliquam dignissim eros eget elit fringilla venenatis.', 0.22);
  INSERT INTO `master_produk` VALUES ('NS-0003', 2, 1, 'T-SHIRT PARDON MY FRENCH', 312000.00, 1, '1', NULL, '2021-05-22 14:53:07', NULL, 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. In convallis tempor libero quis sollicitudin. Nunc convallis semper lorem eget accumsan. Phasellus consectetur consequat risus, sed vestibulum felis tincidunt id. Integer in lacinia purus, vitae tempor risus. Aliquam dignissim eros eget elit fringilla venenatis.', 0.22);
  INSERT INTO `master_produk` VALUES ('NS-0004', 2, 1, 'T-SHIRT LONG SLEEVES PARDON MY FRENCH', 120000.00, 1, '1', NULL, '2021-05-22 14:53:36', NULL, 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. In convallis tempor libero quis sollicitudin. Nunc convallis semper lorem eget accumsan. Phasellus consectetur consequat risus, sed vestibulum felis tincidunt id. Integer in lacinia purus, vitae tempor risus. Aliquam dignissim eros eget elit fringilla venenatis.', 0.22);
  
  -- ----------------------------
  -- Table structure for master_produk_detail
  -- ----------------------------
  DROP TABLE IF EXISTS `master_produk_detail`;
  CREATE TABLE `master_produk_detail`  (
    `id_detail_produk` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    `initial_produk` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    `ukuran` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    `warna` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    PRIMARY KEY (`id_detail_produk`) USING BTREE
  ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
  
  -- ----------------------------
  -- Records of master_produk_detail
  -- ----------------------------
  INSERT INTO `master_produk_detail` VALUES ('BN-NS-0001-296', 'NS-0001', 'L', '1');
  INSERT INTO `master_produk_detail` VALUES ('BN-NS-0001-380', 'NS-0001', 'M', '1');
  INSERT INTO `master_produk_detail` VALUES ('BN-NS-0001-520', 'NS-0001', 'S', '1');
  INSERT INTO `master_produk_detail` VALUES ('BN-NS-0001-558', 'NS-0001', 'L', '2');
  INSERT INTO `master_produk_detail` VALUES ('BN-NS-0001-664', 'NS-0001', 'M', '2');
  INSERT INTO `master_produk_detail` VALUES ('BN-NS-0001-976', 'NS-0001', 'S', '2');
  INSERT INTO `master_produk_detail` VALUES ('BN-NS-0002-226', 'NS-0002', 'XL', '2');
  INSERT INTO `master_produk_detail` VALUES ('BN-NS-0002-232', 'NS-0002', 'M', '2');
  INSERT INTO `master_produk_detail` VALUES ('BN-NS-0002-26', 'NS-0002', 'L', '2');
  INSERT INTO `master_produk_detail` VALUES ('BN-NS-0002-358', 'NS-0002', 'M', '3');
  INSERT INTO `master_produk_detail` VALUES ('BN-NS-0002-640', 'NS-0002', 'XL', '3');
  INSERT INTO `master_produk_detail` VALUES ('BN-NS-0002-851', 'NS-0002', 'L', '3');
  INSERT INTO `master_produk_detail` VALUES ('BN-NS-0003-19', 'NS-0003', 'S', '1');
  INSERT INTO `master_produk_detail` VALUES ('BN-NS-0003-666', 'NS-0003', 'L', '1');
  INSERT INTO `master_produk_detail` VALUES ('BN-NS-0003-705', 'NS-0003', 'M', '1');
  INSERT INTO `master_produk_detail` VALUES ('BN-NS-0004-200', 'NS-0004', 'L', '1');
  INSERT INTO `master_produk_detail` VALUES ('BN-NS-0004-356', 'NS-0004', 'L', '3');
  INSERT INTO `master_produk_detail` VALUES ('BN-NS-0004-511', 'NS-0004', 'XL', '1');
  INSERT INTO `master_produk_detail` VALUES ('BN-NS-0004-563', 'NS-0004', 'M', '3');
  INSERT INTO `master_produk_detail` VALUES ('BN-NS-0004-58', 'NS-0004', 'XL', '1');
  INSERT INTO `master_produk_detail` VALUES ('BN-NS-0004-808', 'NS-0004', 'M', '3');
  
  -- ----------------------------
  -- Table structure for master_produk_inventori
  -- ----------------------------
  DROP TABLE IF EXISTS `master_produk_inventori`;
  CREATE TABLE `master_produk_inventori`  (
    `id_produk_inventori` int(11) NOT NULL AUTO_INCREMENT,
    `initial_produk` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    `in` decimal(6, 0) NULL DEFAULT NULL,
    `out` decimal(6, 0) NULL DEFAULT NULL,
    `stock` decimal(6, 0) NULL DEFAULT NULL,
    `created_at` timestamp(6) NULL DEFAULT NULL,
    `updated_at` timestamp(6) NULL DEFAULT NULL,
    `deleted_at` timestamp(6) NULL DEFAULT NULL,
    PRIMARY KEY (`id_produk_inventori`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 22 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
  
  -- ----------------------------
  -- Records of master_produk_inventori
  -- ----------------------------
  INSERT INTO `master_produk_inventori` VALUES (1, 'BN-NS-0001-520', 100, NULL, 100, '2021-05-22 12:38:32.000000', NULL, NULL);
  INSERT INTO `master_produk_inventori` VALUES (2, 'BN-NS-0001-664', 100, NULL, 100, '2021-05-22 12:38:32.000000', NULL, NULL);
  INSERT INTO `master_produk_inventori` VALUES (3, 'BN-NS-0001-296', 100, NULL, 100, '2021-05-22 12:38:32.000000', NULL, NULL);
  INSERT INTO `master_produk_inventori` VALUES (4, 'BN-NS-0001-976', 100, NULL, 100, '2021-05-22 12:38:32.000000', NULL, NULL);
  INSERT INTO `master_produk_inventori` VALUES (5, 'BN-NS-0001-380', 100, NULL, 100, '2021-05-22 12:38:32.000000', NULL, NULL);
  INSERT INTO `master_produk_inventori` VALUES (6, 'BN-NS-0001-558', 100, NULL, 100, '2021-05-22 12:38:32.000000', NULL, NULL);
  INSERT INTO `master_produk_inventori` VALUES (7, 'BN-NS-0002-232', 100, NULL, 100, '2021-05-22 14:52:27.000000', NULL, NULL);
  INSERT INTO `master_produk_inventori` VALUES (8, 'BN-NS-0002-26', 100, NULL, 100, '2021-05-22 14:52:27.000000', NULL, NULL);
  INSERT INTO `master_produk_inventori` VALUES (9, 'BN-NS-0002-226', 100, NULL, 100, '2021-05-22 14:52:27.000000', NULL, NULL);
  INSERT INTO `master_produk_inventori` VALUES (10, 'BN-NS-0002-358', 100, NULL, 100, '2021-05-22 14:52:27.000000', NULL, NULL);
  INSERT INTO `master_produk_inventori` VALUES (11, 'BN-NS-0002-851', 100, NULL, 100, '2021-05-22 14:52:28.000000', NULL, NULL);
  INSERT INTO `master_produk_inventori` VALUES (12, 'BN-NS-0002-640', 100, NULL, 100, '2021-05-22 14:52:28.000000', NULL, NULL);
  INSERT INTO `master_produk_inventori` VALUES (13, 'BN-NS-0003-19', 100, NULL, 100, '2021-05-22 14:53:07.000000', NULL, NULL);
  INSERT INTO `master_produk_inventori` VALUES (14, 'BN-NS-0003-705', 100, 0, 100, '2021-05-22 14:53:07.000000', NULL, NULL);
  INSERT INTO `master_produk_inventori` VALUES (15, 'BN-NS-0003-666', 100, NULL, 100, '2021-05-22 14:53:07.000000', NULL, NULL);
  INSERT INTO `master_produk_inventori` VALUES (16, 'BN-NS-0004-563', 100, 2, 100, '2021-05-22 14:53:36.000000', NULL, NULL);
  INSERT INTO `master_produk_inventori` VALUES (17, 'BN-NS-0004-356', 100, NULL, 100, '2021-05-22 14:53:36.000000', NULL, NULL);
  INSERT INTO `master_produk_inventori` VALUES (18, 'BN-NS-0004-58', 100, NULL, 100, '2021-05-22 14:53:36.000000', NULL, NULL);
  INSERT INTO `master_produk_inventori` VALUES (19, 'BN-NS-0004-808', 100, NULL, 100, '2021-05-22 14:53:36.000000', NULL, NULL);
  INSERT INTO `master_produk_inventori` VALUES (20, 'BN-NS-0004-200', 100, NULL, 100, '2021-05-22 14:53:37.000000', NULL, NULL);
  INSERT INTO `master_produk_inventori` VALUES (21, 'BN-NS-0004-511', 100, NULL, 100, '2021-05-22 14:53:37.000000', NULL, NULL);
  
  -- ----------------------------
  -- Table structure for master_produk_picture
  -- ----------------------------
  DROP TABLE IF EXISTS `master_produk_picture`;
  CREATE TABLE `master_produk_picture`  (
    `id_produk_picture` int(11) NOT NULL AUTO_INCREMENT,
    `initial_produk` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    `path_file` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
    `nama_file` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    `created_at` timestamp(6) NULL DEFAULT NULL,
    `updated_at` timestamp(6) NULL DEFAULT NULL,
    `deleted_at` timestamp(6) NULL DEFAULT NULL,
    PRIMARY KEY (`id_produk_picture`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
  
  -- ----------------------------
  -- Records of master_produk_picture
  -- ----------------------------
  INSERT INTO `master_produk_picture` VALUES (1, 'NS-0001', '/uploads/temp/', '60a8fb4541b92_photo1.jpg', '2021-05-22 12:38:32.000000', NULL, NULL);
  INSERT INTO `master_produk_picture` VALUES (2, 'NS-0001', '/uploads/temp/', '60a8fb4547385_photo2.jpg', '2021-05-22 12:38:32.000000', NULL, NULL);
  INSERT INTO `master_produk_picture` VALUES (3, 'NS-0001', '/uploads/temp/', '60a8fb45605b1_photo3.jpg', '2021-05-22 12:38:32.000000', NULL, NULL);
  INSERT INTO `master_produk_picture` VALUES (4, 'NS-0001', '/uploads/temp/', '60a8fb456361d_photo4.jpg', '2021-05-22 12:38:32.000000', NULL, NULL);
  INSERT INTO `master_produk_picture` VALUES (5, 'NS-0002', '/uploads/temp/', '60a91aa8be110_photo18.jpg', '2021-05-22 14:52:28.000000', NULL, NULL);
  INSERT INTO `master_produk_picture` VALUES (6, 'NS-0002', '/uploads/temp/', '60a91aa8bf8d0_photo17.jpg', '2021-05-22 14:52:28.000000', NULL, NULL);
  INSERT INTO `master_produk_picture` VALUES (7, 'NS-0002', '/uploads/temp/', '60a91aa8e0077_photo19.jpg', '2021-05-22 14:52:28.000000', NULL, NULL);
  INSERT INTO `master_produk_picture` VALUES (8, 'NS-0003', '/uploads/temp/', '60a91ad07c61c_photo25.jpg', '2021-05-22 14:53:07.000000', NULL, NULL);
  INSERT INTO `master_produk_picture` VALUES (9, 'NS-0003', '/uploads/temp/', '60a91ad07d014_photo26.jpg', '2021-05-22 14:53:08.000000', NULL, NULL);
  INSERT INTO `master_produk_picture` VALUES (10, 'NS-0004', '/uploads/temp/', '60a91aedb0dae_photo12.jpg', '2021-05-22 14:53:37.000000', NULL, NULL);
  INSERT INTO `master_produk_picture` VALUES (11, 'NS-0004', '/uploads/temp/', '60a91aedb0d36_photo11.jpg', '2021-05-22 14:53:37.000000', NULL, NULL);
  
  -- ----------------------------
  -- Table structure for master_promo
  -- ----------------------------
  DROP TABLE IF EXISTS `master_promo`;
  CREATE TABLE `master_promo`  (
    `id_promo` int(11) NOT NULL AUTO_INCREMENT,
    `potongan_harga` decimal(20, 2) NULL DEFAULT NULL,
    `kode_promo` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
    `created_at` timestamp(6) NULL DEFAULT NULL,
    `updated_at` timestamp(6) NULL DEFAULT NULL,
    `deleted_at` timestamp(6) NULL DEFAULT NULL,
    `tgl_mulai` date NULL DEFAULT NULL,
    `tgl_berakhir` date NULL DEFAULT NULL,
    PRIMARY KEY (`id_promo`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
  
  -- ----------------------------
  -- Records of master_promo
  -- ----------------------------
  INSERT INTO `master_promo` VALUES (1, 12000.00, 'a', '2021-05-24 17:13:51.000000', '2021-07-15 14:47:29.000000', NULL, '2021-07-11', '2021-07-14');
  INSERT INTO `master_promo` VALUES (3, 13000.00, 'brayen', '2021-07-15 14:53:26.000000', '2021-07-15 14:53:39.000000', NULL, '2021-07-14', '2021-07-20');
  
  -- ----------------------------
  -- Table structure for master_provinsi
  -- ----------------------------
  DROP TABLE IF EXISTS `master_provinsi`;
  CREATE TABLE `master_provinsi`  (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `nama_prov` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
    `kode_provinsi` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
    `created_at` timestamp(6) NULL DEFAULT NULL,
    `updated_at` timestamp(6) NULL DEFAULT NULL,
    `deleted_at` timestamp(6) NULL DEFAULT NULL,
    `status_active` int(11) NULL DEFAULT NULL,
    `id_api` int(11) NULL DEFAULT NULL,
    PRIMARY KEY (`id`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 36 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
  
  -- ----------------------------
  -- Records of master_provinsi
  -- ----------------------------
  INSERT INTO `master_provinsi` VALUES (2, 'ACEH', 'id-ac', NULL, NULL, NULL, NULL, 21);
  INSERT INTO `master_provinsi` VALUES (3, 'SUMATERA UTARA', 'id-su', NULL, NULL, NULL, NULL, 34);
  INSERT INTO `master_provinsi` VALUES (4, 'SUMATERA BARAT', 'id-sb', NULL, NULL, NULL, NULL, 32);
  INSERT INTO `master_provinsi` VALUES (5, 'RIAU', 'id-ri', NULL, NULL, NULL, NULL, 26);
  INSERT INTO `master_provinsi` VALUES (6, 'JAMBI', 'id-ja', NULL, NULL, NULL, NULL, 8);
  INSERT INTO `master_provinsi` VALUES (7, 'SUMATERA SELATAN', 'id-sl', NULL, NULL, NULL, NULL, 33);
  INSERT INTO `master_provinsi` VALUES (8, 'BENGKULU', 'id-be', NULL, NULL, NULL, NULL, 4);
  INSERT INTO `master_provinsi` VALUES (9, 'LAMPUNG', 'id-1024', NULL, NULL, NULL, NULL, 18);
  INSERT INTO `master_provinsi` VALUES (10, 'KEPULAUAN BANGKA BELITUNG', 'id-bb', NULL, NULL, NULL, NULL, 2);
  INSERT INTO `master_provinsi` VALUES (11, 'KEPULAUAN RIAU', 'id-kr', NULL, NULL, NULL, NULL, 17);
  INSERT INTO `master_provinsi` VALUES (12, 'DKI JAKARTA', 'id-jk', NULL, NULL, NULL, NULL, 6);
  INSERT INTO `master_provinsi` VALUES (13, 'JAWA BARAT', 'id-jr', NULL, NULL, NULL, NULL, 9);
  INSERT INTO `master_provinsi` VALUES (14, 'JAWA TENGAH', 'id-jt', NULL, NULL, NULL, NULL, 10);
  INSERT INTO `master_provinsi` VALUES (15, 'DI. YOGYAKARTA', 'id-yo', NULL, NULL, NULL, NULL, 5);
  INSERT INTO `master_provinsi` VALUES (16, 'JAWA TIMUR', 'id-ji', NULL, NULL, NULL, NULL, 11);
  INSERT INTO `master_provinsi` VALUES (17, 'BANTEN', 'id-bt', NULL, NULL, NULL, NULL, 3);
  INSERT INTO `master_provinsi` VALUES (18, 'BALI', 'id-ba', NULL, NULL, NULL, NULL, 1);
  INSERT INTO `master_provinsi` VALUES (19, 'NUSA TENGGARA BARAT', 'id-nb', NULL, NULL, NULL, NULL, 22);
  INSERT INTO `master_provinsi` VALUES (20, 'NUSA TENGGARA TIMUR', 'id-nt', NULL, NULL, NULL, NULL, 23);
  INSERT INTO `master_provinsi` VALUES (21, 'KALIMANTAN BARAT', 'id-kb', NULL, NULL, NULL, NULL, 12);
  INSERT INTO `master_provinsi` VALUES (22, 'KALIMANTAN TENGAH', 'id-kt', NULL, NULL, NULL, NULL, 14);
  INSERT INTO `master_provinsi` VALUES (23, 'KALIMANTAN SELATAN', 'id-ks', NULL, NULL, NULL, NULL, 13);
  INSERT INTO `master_provinsi` VALUES (24, 'KALIMANTAN TIMUR', 'id-ki', NULL, NULL, NULL, NULL, 15);
  INSERT INTO `master_provinsi` VALUES (25, 'SULAWESI UTARA', 'id-sw', NULL, NULL, NULL, NULL, 31);
  INSERT INTO `master_provinsi` VALUES (26, 'SULAWESI TENGAH', 'id-st', NULL, NULL, NULL, NULL, 29);
  INSERT INTO `master_provinsi` VALUES (27, 'SULAWESI SELATAN', 'id-se', NULL, NULL, NULL, NULL, 28);
  INSERT INTO `master_provinsi` VALUES (28, 'SULAWESI TENGGARA', 'id-sg', NULL, NULL, NULL, NULL, 30);
  INSERT INTO `master_provinsi` VALUES (29, 'GORONTALO', 'id-go', NULL, NULL, NULL, NULL, 7);
  INSERT INTO `master_provinsi` VALUES (30, 'SULAWESI BARAT', 'id-sr', NULL, NULL, NULL, NULL, 27);
  INSERT INTO `master_provinsi` VALUES (31, 'MALUKU', 'id-ma', NULL, NULL, NULL, NULL, 19);
  INSERT INTO `master_provinsi` VALUES (32, 'MALUKU UTARA', 'id-la', NULL, NULL, NULL, NULL, 20);
  INSERT INTO `master_provinsi` VALUES (33, 'PAPUA', 'id-pa', NULL, NULL, NULL, NULL, 24);
  INSERT INTO `master_provinsi` VALUES (34, 'PAPUA BARAT', 'id-ib', NULL, NULL, NULL, NULL, 25);
  INSERT INTO `master_provinsi` VALUES (35, 'KALIMANTAN UTARA', 'id-ku', NULL, NULL, NULL, NULL, 16);
  
  -- ----------------------------
  -- Table structure for master_ukuran
  -- ----------------------------
  DROP TABLE IF EXISTS `master_ukuran`;
  CREATE TABLE `master_ukuran`  (
    `kode_ukuran` int(11) NOT NULL AUTO_INCREMENT,
    `nama_ukuran` char(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    `created_at` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),
    `updated_at` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),
    PRIMARY KEY (`kode_ukuran`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
  
  -- ----------------------------
  -- Records of master_ukuran
  -- ----------------------------
  INSERT INTO `master_ukuran` VALUES (1, 'S', '2021-04-01 20:18:19', '2021-04-01 20:18:19');
  INSERT INTO `master_ukuran` VALUES (2, 'M', '2021-04-01 20:18:21', '2021-04-01 20:18:21');
  INSERT INTO `master_ukuran` VALUES (3, 'L', '2021-04-01 20:18:23', '2021-04-01 20:18:23');
  INSERT INTO `master_ukuran` VALUES (4, 'XL', '2021-04-01 20:18:24', '2021-04-01 20:18:24');
  INSERT INTO `master_ukuran` VALUES (5, 'XS', '2021-04-01 20:18:27', '2021-04-01 20:18:27');
  INSERT INTO `master_ukuran` VALUES (6, 'SALAH', '2021-07-11 06:02:42', '2021-07-11 06:03:03');
  
  -- ----------------------------
  -- Table structure for migrations
  -- ----------------------------
  DROP TABLE IF EXISTS `migrations`;
  CREATE TABLE `migrations`  (
    `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
    `migration` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    `batch` int(11) NOT NULL,
    PRIMARY KEY (`id`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
  
  -- ----------------------------
  -- Records of migrations
  -- ----------------------------
  INSERT INTO `migrations` VALUES (1, '2014_10_12_000000_create_users_table', 1);
  INSERT INTO `migrations` VALUES (2, '2014_10_12_100000_create_password_resets_table', 1);
  
  -- ----------------------------
  -- Table structure for password_resets
  -- ----------------------------
  DROP TABLE IF EXISTS `password_resets`;
  CREATE TABLE `password_resets`  (
    `email` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    `token` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    `created_at` timestamp(0) NULL DEFAULT NULL,
    INDEX `password_resets_email_index`(`email`) USING BTREE
  ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
  
  -- ----------------------------
  -- Records of password_resets
  -- ----------------------------
  INSERT INTO `password_resets` VALUES ('aboutteddybear@gmail.com', '$2y$10$EjZhagyxEhJzQBnBqrEm..qEIFOfYntOnHOi0hCr2TCqisGJTOigG', '2021-07-11 06:22:07');
  INSERT INTO `password_resets` VALUES ('brayenprayoga41@gmail.com', '$2y$10$xc8N3Anoah2icvuhnD5H.eCnUxg0Yt9RzCgdomJ47sRWlZo9CPG2W', '2021-07-11 06:26:25');
  
  -- ----------------------------
  -- Table structure for users
  -- ----------------------------
  DROP TABLE IF EXISTS `users`;
  CREATE TABLE `users`  (
    `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
    `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    `email` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    `email_verified_at` timestamp(0) NULL DEFAULT NULL,
    `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    `remember_token` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    `created_at` timestamp(0) NULL DEFAULT NULL,
    `updated_at` timestamp(0) NULL DEFAULT NULL,
    `tipe_user` int(11) NULL DEFAULT NULL,
    `active` int(11) NULL DEFAULT NULL,
    `alamat` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    `no_hp` varchar(13) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    PRIMARY KEY (`id`) USING BTREE,
    UNIQUE INDEX `users_email_unique`(`email`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
  
  -- ----------------------------
  -- Records of users
  -- ----------------------------
  INSERT INTO `users` VALUES (1, 'bani', 'admin@gmail.com', NULL, '$2y$10$Zxj13XyvCiaRpd5qqNxode3AOAGJIBlh0Yp1wKmjRbBz3f.no1g5u', NULL, '2021-03-13 06:30:01', '2021-03-13 06:30:01', 1, 1, NULL, NULL);
  INSERT INTO `users` VALUES (2, 'user', 'user@gmail.com', NULL, '$2y$10$Zxj13XyvCiaRpd5qqNxode3AOAGJIBlh0Yp1wKmjRbBz3f.no1g5u', NULL, '2021-03-13 06:30:45', '2021-03-13 06:30:45', NULL, 1, NULL, NULL);
  INSERT INTO `users` VALUES (8, 'Brayen Prayoga', 'brayen@gmail.com', NULL, '$2y$10$VZoOkXVUR68A4f11l0EzuupKYVYFn1N584lBLFFtaPtcSgXXMn2U.', NULL, '2021-07-18 16:38:08', '2021-07-18 16:38:08', NULL, NULL, 'Centex', '56789765');
  
  -- ----------------------------
  -- Table structure for users_pelanggan_detail
  -- ----------------------------
  DROP TABLE IF EXISTS `users_pelanggan_detail`;
  CREATE TABLE `users_pelanggan_detail`  (
    `kode_pelanggan` int(11) NOT NULL AUTO_INCREMENT,
    `username` char(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    `nama_lengkap_pelanggan` char(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    `jenis_kelamin` int(11) NOT NULL DEFAULT 1,
    `tempat_lahir` char(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    `tanggal_lahir` datetime(0) NOT NULL,
    `alamat` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    `no_hp` char(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    `email` char(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    `password` char(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    `pelanggan_foto_folder_path` mediumtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    `created_at` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),
    `updated_at` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0),
    `deteled_at` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0),
    PRIMARY KEY (`kode_pelanggan`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
  
  SET FOREIGN_KEY_CHECKS = 1;
  