· 6 years ago · Mar 11, 2019, 06:34 AM
1-- Adminer 4.7.0 MySQL dump
2
3SET NAMES utf8;
4SET time_zone = '+00:00';
5SET foreign_key_checks = 0;
6SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
7
8DROP TABLE IF EXISTS `region`;
9CREATE TABLE `region` (
10 `region_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
11 `country_id` varchar(100) DEFAULT NULL,
12 `code` varchar(100) DEFAULT NULL,
13 `default_name` varchar(100) DEFAULT NULL,
14 `mage 1` varchar(100) DEFAULT NULL,
15 PRIMARY KEY (`region_id`)
16) ENGINE=InnoDB DEFAULT CHARSET=latin1;
17
18INSERT INTO `region` (`region_id`, `country_id`, `code`, `default_name`, `mage 1`) VALUES
19(533, 'ID', 'ID-BA', 'BALI', 'Bali'),
20(534, 'ID', 'ID-BB', 'BANGKA BELITUNG', 'Bangka Belitung Islands'),
21(535, 'ID', 'ID-BT', 'BANTEN', 'Banten'),
22(536, 'ID', 'ID-BE', 'BENGKULU', 'Bengkulu'),
23(537, 'ID', 'ID-YO', 'D.I. YOGYAKARTA', 'Yogyakarta Special Territory'),
24(538, 'ID', 'ID-JK', 'DKI JAKARTA', 'DKI Jakarta'),
25(539, 'ID', 'ID-GO', 'GORONTALO', 'Gorontalo'),
26(540, 'ID', 'ID-JA', 'JAMBI', 'Jambi'),
27(541, 'ID', 'ID-JB', 'JAWA BARAT', 'West Java'),
28(542, 'ID', 'ID-JT', 'JAWA TENGAH', 'Central Java'),
29(543, 'ID', 'ID-JI', 'JAWA TIMUR', 'East Java'),
30(544, 'ID', 'ID-KB', 'KALIMANTAN BARAT', 'West Kalimantan'),
31(545, 'ID', 'ID-KS', 'KALIMANTAN SELATAN', 'South Kalimantan'),
32(546, 'ID', 'ID-KU', 'KALIMANTAN UTARA', ''),
33(547, 'ID', 'ID-KT', 'KALIMANTAN TENGAH', 'Central Kalimantan'),
34(548, 'ID', 'ID-KI', 'KALIMANTAN TIMUR', 'East Kalimantan'),
35(549, 'ID', 'ID-KR', 'KEPULAUAN RIAU', 'Riau Islands'),
36(550, 'ID', 'ID-LA', 'LAMPUNG', 'Lampung'),
37(551, 'ID', 'ID-MA', 'MALUKU', 'Maluku'),
38(552, 'ID', 'ID-MU', 'MALUKU UTARA', 'North Maluku'),
39(553, 'ID', 'ID-AC', 'NAD', 'Aceh'),
40(554, 'ID', 'ID-NB', 'NTB', 'West Nusa Tenggara'),
41(555, 'ID', 'ID-NT', 'NTT', 'East Nusa Tenggara'),
42(556, 'ID', 'ID-PA', 'PAPUA', 'Papua'),
43(557, 'ID', 'ID-PB', 'PAPUA BARAT', 'West Papua'),
44(558, 'ID', 'ID-RI', 'RIAU', 'Riau'),
45(559, 'ID', 'ID-SR', 'SULAWESI BARAT', 'West Sulawesi'),
46(560, 'ID', 'ID-SN', 'SULAWESI SELATAN', 'South Sulawesi'),
47(561, 'ID', 'ID-ST', 'SULAWESI TENGAH', 'Central Sulawesi'),
48(562, 'ID', 'ID-SG', 'SULAWESI TENGGARA', 'South East Sulawesi'),
49(563, 'ID', 'ID-SA', 'SULAWESI UTARA', 'North Sulawesi'),
50(564, 'ID', 'ID-SB', 'SUMATERA BARAT', 'West Sumatra'),
51(565, 'ID', 'ID-SS', 'SUMATERA SELATAN', 'South Sumatra'),
52(566, 'ID', 'ID-SU', 'SUMATERA UTARA', 'North Sumatra');
53
54-- 2019-03-11 06:30:09