SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0;
-- Table structure for zh_province
DROP TABLE IF EXISTS zh_province;
CREATE TABLE zh_province (
id int(11) NOT NULL AUTO_INCREMENT,
adcode varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT 'adcode',
province_name varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '名字',
lat double NULL DEFAULT NULL COMMENT '中心纬度',
lng double NULL DEFAULT NULL COMMENT '中心经度',
parent_adcode varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '所属国家',
citycode varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '区号',
PRIMARY KEY (id) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 87 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '省' ROW_FORMAT = Dynamic;
-- Records of zh_province
INSERT INTO zh_province VALUES (53, '110000', '北京市', 39.904989, 116.405285, '10000', '010');
INSERT INTO zh_province VALUES (54, '120000', '天津市', 39.125596, 117.190182, '10000', '022');
INSERT INTO zh_province VALUES (55, '130000', '河北省', 38.045474, 114.502461, '10000', '');
INSERT INTO zh_province VALUES (56, '140000', '山西省', 37.857014, 112.549248, '10000', '');
INSERT INTO zh_province VALUES (57, '150000', '内蒙古自治区', 40.818311, 111.670801, '10000', '');
INSERT INTO zh_province VALUES (58, '210000', '辽宁省', 41.796767, 123.429096, '10000', '');
INSERT INTO zh_province VALUES (59, '220000', '吉林省', 43.886841, 125.3245, '10000', '');
INSERT INTO zh_province VALUES (60, '230000', '黑龙江省', 45.756967, 126.642464, '10000', '');
INSERT INTO zh_province VALUES (61, '310000', '上海市', 31.231706, 121.472644, '10000', '021');
INSERT INTO zh_province VALUES (62, '320000', '江苏省', 32.041544, 118.767413, '10000', '');
INSERT INTO zh_province VALUES (63, '330000', '浙江省', 30.287459, 120.153576, '10000', '');
INSERT INTO zh_province VALUES (64, '340000', '安徽省', 31.86119, 117.283042, '10000', '');
INSERT INTO zh_province VALUES (65, '350000', '福建省', 26.075302, 119.306239, '10000', '');
INSERT INTO zh_province VALUES (66, '360000', '江西省', 28.676493, 115.892151, '10000', '');
INSERT INTO zh_province VALUES (67, '370000', '山东省', 36.675807, 117.000923, '10000', '');
INSERT INTO zh_province VALUES (68, '410000', '河南省', 34.757975, 113.665412, '10000', '');
INSERT INTO zh_province VALUES (69, '420000', '湖北省', 30.584355, 114.298572, '10000', '');
INSERT INTO zh_province VALUES (70, '430000', '湖南省', 28.19409, 112.982279, '10000', '');
INSERT INTO zh_province VALUES (71, '440000', '广东省', 23.125178, 113.280637, '10000', '');
INSERT INTO zh_province VALUES (72, '450000', '广西壮族自治区', 22.82402, 108.320004, '10000', '');
INSERT INTO zh_province VALUES (73, '460000', '海南省', 20.031971, 110.33119, '10000', '');
INSERT INTO zh_province VALUES (74, '500000', '重庆市', 29.533155, 106.504962, '10000', '023');
INSERT INTO zh_province VALUES (75, '510000', '四川省', 30.659462, 104.065735, '10000', '');
INSERT INTO zh_province VALUES (76, '520000', '贵州省', 26.578343, 106.713478, '10000', '');
INSERT INTO zh_province VALUES (77, '530000', '云南省', 25.040609, 102.712251, '10000', '');
INSERT INTO zh_province VALUES (78, '540000', '西藏自治区', 29.660361, 91.132212, '10000', '');
INSERT INTO zh_province VALUES (79, '610000', '陕西省', 34.263161, 108.948024, '10000', '');
INSERT INTO zh_province VALUES (80, '620000', '甘肃省', 36.058039, 103.823557, '10000', '');
INSERT INTO zh_province VALUES (81, '630000', '青海省', 36.623178, 101.778916, '10000', '');
INSERT INTO zh_province VALUES (82, '640000', '宁夏回族自治区', 38.46637, 106.278179, '10000', '');
INSERT INTO zh_province VALUES (83, '650000', '新疆维吾尔自治区', 43.792818, 87.617733, '10000', '');
INSERT INTO zh_province VALUES (84, '710000', '台湾省', 25.044332, 121.509062, '10000', '1886');
INSERT INTO zh_province VALUES (85, '810000', '香港特别行政区', 22.320048, 114.173355, '10000', '1852');
INSERT INTO zh_province VALUES (86, '820000', '澳门特别行政区', 22.198951, 113.54909, '10000', '1853');
SET FOREIGN_KEY_CHECKS = 1;
