/*
Navicat Premium Data Transfer
Source Server : localhost_mysql
Source Server Type : MySQL
Source Server Version : 50553
Source Host : localhost:3306
Source Schema : citycode
Target Server Type : MySQL
Target Server Version : 50553
File Encoding : 65001
Date: 21/01/2022 20:28:41
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for ms_citycode
-- ----------------------------
DROP TABLE IF EXISTS `ms_citycode`;
CREATE TABLE `ms_citycode` (
`id` int(4) NOT NULL AUTO_INCREMENT,
`code` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '城市代码',
`pid` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '上级',
`mname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '名称',
`shortname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '简称',
`numbers` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '当前编号',
`typenum` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '类型代码',
`years` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '年份',
`level` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '层级',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 268767 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of ms_citycode
-- ----------------------------
INSERT INTO `ms_citycode` VALUES (1, '110000000000', '0', '北京市', '北京', '11', '0', '2020', '1');
INSERT INTO `ms_citycode` VALUES (2, '120000000000', '0', '天津市', '天津', '12', '0', '2020', '1');
INSERT INTO `ms_citycode` VALUES (3, '130000000000', '0', '河北省', '河北', '13', '0', '2020', '1');
INSERT INTO `ms_citycode` VALUES (4, '140000000000', '0', '山西省', '山西', '14', '0', '2020', '1');
INSERT INTO `ms_citycode` VALUES (5, '150000000000', '0', '内蒙古自治区', '内蒙古', '15', '0', '2020', '1');
INSERT INTO `ms_citycode` VALUES (6, '210000000000', '0', '辽宁省', '辽宁', '21', '0', '2020', '1');
INSERT INTO `ms_citycode` VALUES (7, '220000000000', '0', '吉林省', '吉林', '22', '0', '2020', '1');
INSERT INTO `ms_citycode` VALUES (8, '230000000000', '0', '黑龙江省', '黑龙江', '23', '0', '2020', '1');
INSERT INTO `ms_citycode` VALUES (9, '310000000000', '0', '上海市', '上海', '31', '0', '2020', '1');
INSERT INTO `ms_citycode` VALUES (10, '320000000000', '0', '江苏省', '江苏', '32', '0', '2020', '1');
INSERT INTO `ms_citycode` VALUES (11, '330000000000', '0', '浙江省', '浙江', '33', '0', '2020', '1');
INSERT INTO `ms_citycode` VALUES (12, '340000000000', '0', '安徽省', '安徽', '34', '0', '2020', '1');
INSERT INTO `ms_citycode` VALUES (13, '350000000000', '0', '福建省', '福建', '35', '0', '2020', '1');
INSERT INTO `ms_citycode` VALUES (14, '360000000000', '0', '江西省', '江西', '36', '0', '2020', '1');
INSERT INTO `ms_citycode` VALUES (15, '370000000000', '0', '山东省', '山东', '37', '0', '2020', '1');
INSERT INTO `ms_citycode` VALUES (16, '410000000000', '0', '河南省', '河南', '41', '0', '2020', '1');
INSERT INTO `ms_citycode` VALUES (17, '420000000000', '0', '湖北省', '湖北', '42', '0', '2020', '1');
INSERT INTO `ms_citycode` VALUES (18, '430000000000', '0', '湖南省', '湖南', '43', '0', '2020', '1');
INSERT INTO `ms_citycode` VALUES (19, '440000000000', '0', '广东省', '广东', '44', '0', '2020', '1');
INSERT INTO `ms_citycode` VALUES (20, '450000000000', '0', '广西壮族自治区', '广西', '45', '0', '2020', '1');
INSERT INTO `ms_citycode` VALUES (21, '460000000000', '0', '海南省', '海南', '46', '0', '2020', '1');
INSERT INTO `ms_citycode` VALUES (22, '500000000000', '0', '重庆市', '重庆', '50', '0', '2020', '1');
INSERT INTO `ms_citycode` VALUES (23, '510000000000', '0', '四川省', '四川', '51', '0', '2020', '1');
INSERT INTO `ms_citycode` VALUES (24, '520000000000', '0', '贵州省', '贵州', '52', '0', '2020', '1');
INSERT INTO `ms_citycode` VALUES (25, '530000000000', '0', '云南省', '云南', '53', '0', '2020', '1');
INSERT INTO `ms_citycode` VALUES (26, '540000000000', '0', '西藏自治区', '西藏', '54', '0', '2020', '1');
INSERT INTO `ms_citycode` VALUES (27, '610000000000', '0', '陕西省', '陕西', '61', '0', '2020', '1');
INSERT INTO `ms_citycode` VALUES (28, '620000000000', '0', '甘肃省', '甘肃', '62', '0', '2020', '1');
INSERT INTO `ms_citycode` VALUES (29, '630000000000', '0', '青海省', '青海', '63', '0', '2020', '1');
INSERT INTO `ms_citycode` VALUES (30, '640000000000', '0', '宁夏回族自治区', '宁夏', '64', '0', '2020', '1');
INSERT INTO `ms_citycode` VALUES (31, '650000000000', '0', '新疆维吾尔自治区', '新疆', '65', '0', '2020', '1');
INSERT INTO `ms_citycode` VALUES (32, '110100000000', '1', '市辖区', '辖区', '1101', '0', '2020', '2');
INSERT INTO `ms_citycode` VALUES (33, '110102000000', '32', '西城区', '西城区', '110102', '0', '2020', '3');
INSERT INTO `ms_citycode` VALUES (34, '110105000000', '32', '朝阳区', '朝阳区', '110105', '0', '2020', '3');
INSERT INTO `ms_citycode` VALUES (35, '110106000000', '32', '丰台区', '丰台区', '110106', '0', '2020', '3');
INSERT INTO `ms_citycode` VALUES (36, '110107000000', '32', '石景山区', '石景山区', '110107', '0', '2020', '3');
INSERT INTO `ms_citycode` VALUES (37, '110108000000', '32', '海淀区', '海淀区', '110108', '0', '2020', '3');
INSERT INTO `ms_citycode` VALUES (38, '110109000000', '32', '门头沟区', '门头沟区', '110109', '0', '2020', '3');
INSERT INTO `ms_citycode` VALUES (39, '110111000000', '32', '房山区', '房山区', '110111', '0', '2020', '3');
INSERT INTO `ms_citycode` VALUES (40, '110112000000', '32', '通州区', '通州区', '110112', '0', '2020', '3');
INSERT INTO `ms_citycode` VALUES (41, '110113000000', '32', '顺义区', '顺义区', '110113', '0', '2020', '3');
INSERT INTO `ms_citycode` VALUES (42, '110114000000', '32', '昌平区', '昌平区', '110114', '0', '2020', '3');
INSERT INTO `ms_citycode` VALUES (43, '110115000000', '32', '大兴区', '大兴区', '110115', '0', '2020', '3');
INSERT INTO `ms_citycode` VALUES (44, '110116000000', '32', '怀柔区', '怀柔区', '110116', '0', '2020', '3');
INSERT INTO `ms_citycode` VALUES (45, '110117000000', '32', '平谷区', '平谷区', '110117', '0', '2020', '3');
INSERT INTO `ms_citycode` VALUES (46, '110118000000', '32', '密云区', '密云区', '110118', '0', '2020', '3');
INSERT INTO `ms_citycode` VALUES (47, '110119000000', '32', '延庆区', '延庆区', '110119', '0', '2020', '3');
INSERT INTO `ms_citycode` VALUES (48, '110119001000', '47', '百泉街道', '百泉街道', '110119001', '0', '2020', '4');
INSERT INTO `ms_citycode` VALUES (49, '110119002000', '47', '香水园街道', '香水园街道', '110119002', '0', '2020', '4');
INSERT INTO `ms_citycode` VALUES (50, '110119003000', '47', '儒林街道', '儒林街道', '110119003', '0', '2020', '4');
INSERT INTO `ms_citycode` VALUES (51, '110119100000', '47', '延庆镇', '延庆镇', '110119100', '0', '2020', '4');
INSERT INTO `ms_citycode` VALUES (52, '110119101000', '47', '康庄镇', '康庄镇', '110119101', '0', '2020', '4');
INSERT INTO `ms_citycode` VALUES (53, '110119102000', '47', '八达岭镇', '八达岭镇', '110119102', '0', '2020', '4');
INSERT INTO `ms_citycode` VALUES (54, '110119103000', '47', '永宁镇', '永宁镇', '110119103', '0', '2020', '4');
INSERT INTO `ms_citycode` VALUES (55, '110119104000', '47', '旧县镇', '旧镇', '110119104', '0', '2020', '4');
INSERT INTO `ms_citycode` VALUES (56, '110119105000', '47', '张山营镇', '张山营镇', '110119105', '0'
评论3