-- 创建表
CREATE TABLE `area`  (
    `area_id` int(11) NOT NULL COMMENT '地区ID',
    `area_pid` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '地区父ID',
    `area_name` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '地区名称',
    `sname` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '地名简称',
    `level` int(11) UNSIGNED NOT NULL DEFAULT 1 COMMENT '区域等级',
    `citycode` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '区域编码',
    `yzcode` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮政编码',
    `area_ip_desc` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所属',
    `lng` float NULL DEFAULT NULL COMMENT '精度',
    `lat` float NULL DEFAULT NULL COMMENT '维度',
    `first_pinyin` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '地名拼音',
    `pinyin` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '首字母',
    `area_sort` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '排序',
    `status` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '开启 1是 0否',
    PRIMARY KEY (`area_id`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '省市区' ROW_FORMAT = Dynamic;

-- 添加数据
INSERT INTO `area` VALUES (110000, 0, '北京', '北京', 1, '', '', '中国,北京', 116.405, 39.905, 'Beijing', 'B', 0, 1);
INSERT INTO `area` VALUES (110100, 110000, '北京市', '北京', 2, '010', '100000', '中国,北京,北京市', 116.405, 39.905, 'Beijing', 'B', 0, 1);
INSERT INTO `area` VALUES (110101, 110100, '东城区', '东城', 3, '010', '100010', '中国,北京,北京市,东城区', 116.41, 39.9316, 'Dongcheng', 'D', 0, 1);
INSERT INTO `area` VALUES (110102, 110100, '西城区', '西城', 3, '010', '100032', '中国,北京,北京市,西城区', 116.36, 39.9305, 'Xicheng', 'X', 0, 1);
INSERT INTO `area` VALUES (110105, 110100, '朝阳区', '朝阳', 3, '010', '100020', '中国,北京,北京市,朝阳区', 116.485, 39.9484, 'Chaoyang', 'C', 0, 1);
INSERT INTO `area` VALUES (110106, 110100, '丰台区', '丰台', 3, '010', '100071', '中国,北京,北京市,丰台区', 116.286, 39.8585, 'Fengtai', 'F', 0, 1);
INSERT INTO `area` VALUES (110107, 110100, '石景山区', '石景山', 3, '010', '100043', '中国,北京,北京市,石景山区', 116.223, 39.9056, 'Shijingshan', 'S', 0, 1);
INSERT INTO `area` VALUES (110108, 110100, '海淀区', '海淀', 3, '010', '100089', '中国,北京,北京市,海淀区', 116.298, 39.9593, 'Haidian', 'H', 0, 1);
INSERT INTO `area` VALUES (110109, 110100, '门头沟区', '门头沟', 3, '010', '102300', '中国,北京,北京市,门头沟区', 116.101, 39.9404, 'Mentougou', 'M', 0, 1);
INSERT INTO `area` VALUES (110111, 110100, '房山区', '房山', 3, '010', '102488', '中国,北京,北京市,房山区', 116.143, 39.7479, 'Fangshan', 'F', 0, 1);
INSERT INTO `area` VALUES (110112, 110100, '通州区', '通州', 3, '010', '101149', '中国,北京,北京市,通州区', 116.657, 39.9097, 'Tongzhou', 'T', 0, 1);
INSERT INTO `area` VALUES (110113, 110100, '顺义区', '顺义', 3, '010', '101300', '中国,北京,北京市,顺义区', 116.654, 40.1302, 'Shunyi', 'S', 0, 1);
INSERT INTO `area` VALUES (110114, 110100, '昌平区', '昌平', 3, '010', '102200', '中国,北京,北京市,昌平区', 116.231, 40.2207, 'Changping', 'C', 0, 1);
INSERT INTO `area` VALUES (110115, 110100, '大兴区', '大兴', 3, '010', '102600', '中国,北京,北京市,大兴区', 116.341, 39.7267, 'Daxing', 'D', 0, 1);
INSERT INTO `area` VALUES (110116, 110100, '怀柔区', '怀柔', 3, '010', '101400', '中国,北京,北京市,怀柔区', 116.632, 40.316, 'Huairou', 'H', 0, 1);
INSERT INTO `area` VALUES (110117, 110100, '平谷区', '平谷', 3, '010', '101200', '中国,北京,北京市,平谷区', 117.121, 40.1406, 'Pinggu', 'P', 0, 1);
INSERT INTO `area` VALUES (110228, 110100, '密云县', '密云', 3, '010', '101500', '中国,北京,北京市,密云县', 116.843, 40.3762, 'Miyun', 'M', 0, 1);
INSERT INTO `area` VALUES (110229, 110100, '延庆县', '延庆', 3, '010', '102100', '中国,北京,北京市,延庆县', 115.975, 40.4567, 'Yanqing', 'Y', 0, 1);
INSERT INTO `area` VALUES (120000, 0, '天津', '天津', 1, '', '', '中国,天津', 117.19, 39.1256, 'Tianjin', 'T', 0, 0);
INSERT INTO `area` VALUES (120100, 120000, '天津市', '天津', 2, '022', '300000', '中国,天津,天津市', 117.19, 39.1256, 'Tianjin', 'T', 0, 1);
INSERT INTO `area` VALUES (120101, 120100, '和平区', '和平', 3, '022', '300041', '中国,天津,天津市,和平区', 117.215, 39.1172, 'Heping', 'H', 0, 1);
INSERT INTO `area` VALUES (120102, 120100, '河东区', '河东', 3, '022', '300171', '中国,天津,天津市,河东区', 117.226, 39.1232, 'Hedong', 'H', 0, 1);
INSERT INTO `area` VALUES (120103, 120100, '河西区', '河西', 3, '022', '300202', '中国,天津,天津市,河西区', 117.223, 39.1096, 'Hexi', 'H', 0, 1);
INSERT INTO `area` VALUES (120104, 120100, '南开区', '南开', 3, '022', '300110', '中国,天津,天津市,南开区', 117.151, 39.1382, 'Nankai', 'N', 0, 1);
INSERT INTO `area` VALUES (120105, 120100, '河北区', '河北', 3, '022', '300143', '中国,天津,天津市,河北区', 117.197, 39.1482, 'Hebei', 'H', 0, 1);
INSERT INTO `area` VALUES (120106, 120100, '红桥区', '红桥', 3, '022', '300131', '中国,天津,天津市,红桥区', 117.151, 39.1671, 'Hongqiao', 'H', 0, 1);
INSERT INTO `area` VALUES (120110, 120100, '东丽区', '东丽', 3, '022', '300300', '中国,天津,天津市,东丽区', 117.314, 39.0863, 'Dongli', 'D', 0, 1);
INSERT INTO `area` VALUES (120111, 120100, '西青区', '西青', 3, '022', '300380', '中国,天津,天津市,西青区', 117.009, 39.1412, 'Xiqing', 'X', 0, 1);
INSERT INTO `area` VALUES (120112, 120100, '津南区', '津南', 3, '022', '300350', '中国,天津,天津市,津南区', 117.385, 38.9914, 'Jinnan', 'J', 0, 1);
INSERT INTO `area` VALUES (120113, 120100, '北辰区', '北辰', 3, '022', '300400', '中国,天津,天津市,北辰区', 117.132, 39.2213, 'Beichen', 'B', 0, 1);
INSERT INTO `area` VALUES (120114, 120100, '武清区', '武清', 3, '022', '301700', '中国,天津,天津市,武清区', 117.044, 39.3842, 'Wuqing', 'W', 0, 1);
INSERT INTO `area` VALUES (120115, 120100, '宝坻区', '宝坻', 3, '022', '301800', '中国,天津,天津市,宝坻区', 117.31, 39.7176, 'Baodi', 'B', 0, 1);
INSERT INTO `area` VALUES (120116, 120100, '滨海新区', '滨海新区', 3, '022', '300451', '中国,天津,天津市,滨海新区', 117.702, 39.0267, 'Binhaixinqu', 'B', 0, 1);
INSERT INTO `area` VALUES (120221, 120100, '宁河县', '宁河', 3, '022', '301500', '中国,天津,天津市,宁河县', 117.826, 39.3305, 'Ninghe', 'N', 0, 1);
INSERT INTO `area` VALUES (120223, 120100, '静海县', '静海', 3, '022', '301600', '中国,天津,天津市,静海县', 116.974, 38.9458, 'Jinghai', 'J', 0, 1);
INSERT INTO `area` VALUES (120225, 120100, '蓟县', '蓟县', 3, '022', '301900', '中国,天津,天津市,蓟县', 117.408, 40.0457, 'Jixian', 'J', 0, 1);
INSERT INTO `area` VALUES (130000, 0, '河北省', '河北', 1, '', '', '中国,河北省', 114.502, 38.0455, 'Hebei', 'H', 0, 1);
INSERT INTO `area` VALUES (130100, 130000,