/*
Navicat MySQL Data Transfer
Source Server : 本地
Source Server Version : 50553
Source Host : localhost:3306
Source Database : homestead
Target Server Type : MYSQL
Target Server Version : 50553
File Encoding : 65001
Date: 2019-05-21 14:29:02
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for districts
-- ----------------------------
DROP TABLE IF EXISTS `districts`;
CREATE TABLE `districts` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '自增编号',
`parent_id` int(11) NOT NULL DEFAULT '0' COMMENT '父级编号',
`name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '行政名称',
`level` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '行政级别',
`adcode` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '行政编码',
`center` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '经纬度',
`sortnum` int(11) NOT NULL DEFAULT '0' COMMENT '排序',
`enabled` enum('0','1') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0' COMMENT '是否启用[0-否 1-是]',
`gmt_created` datetime DEFAULT NULL,
`gmt_modified` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3726 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='地区表';
-- ----------------------------
-- Records of districts
-- ----------------------------
INSERT INTO `districts` VALUES ('1', '0', '河南省', 'province', '410000', '113.665412,34.757975', '99', '0', '2019-04-28 17:29:17', '2019-04-28 17:29:17');
INSERT INTO `districts` VALUES ('2', '1', '濮阳市', 'city', '410900', '115.041299,35.768234', '99', '0', '2019-04-28 17:29:17', '2019-04-28 17:29:17');
INSERT INTO `districts` VALUES ('3', '2', '南乐县', 'district', '410923', '115.204336,36.075204', '99', '0', '2019-04-28 17:29:17', '2019-04-28 17:29:17');
INSERT INTO `districts` VALUES ('4', '2', '台前县', 'district', '410927', '115.855681,35.996474', '99', '0', '2019-04-28 17:29:17', '2019-04-28 17:29:17');
INSERT INTO `districts` VALUES ('5', '2', '清丰县', 'district', '410922', '115.107287,35.902413', '99', '0', '2019-04-28 17:29:17', '2019-04-28 17:29:17');
INSERT INTO `districts` VALUES ('6', '2', '范县', 'district', '410926', '115.504212,35.851977', '99', '0', '2019-04-28 17:29:17', '2019-04-28 17:29:17');
INSERT INTO `districts` VALUES ('7', '2', '华龙区', 'district', '410902', '115.03184,35.760473', '99', '0', '2019-04-28 17:29:17', '2019-04-28 17:29:17');
INSERT INTO `districts` VALUES ('8', '2', '濮阳县', 'district', '410928', '115.023844,35.710349', '99', '0', '2019-04-28 17:29:17', '2019-04-28 17:29:17');
INSERT INTO `districts` VALUES ('9', '1', '洛阳市', 'city', '410300', '112.434468,34.663041', '99', '0', '2019-04-28 17:29:17', '2019-04-28 17:29:17');
INSERT INTO `districts` VALUES ('10', '9', '新安县', 'district', '410323', '112.141403,34.728679', '99', '0', '2019-04-28 17:29:17', '2019-04-28 17:29:17');
INSERT INTO `districts` VALUES ('11', '9', '栾川县', 'district', '410324', '111.618386,33.783195', '99', '0', '2019-04-28 17:29:17', '2019-04-28 17:29:17');
INSERT INTO `districts` VALUES ('12', '9', '汝阳县', 'district', '410326', '112.473789,34.15323', '99', '0', '2019-04-28 17:29:17', '2019-04-28 17:29:17');
INSERT INTO `districts` VALUES ('13', '9', '涧西区', 'district', '410305', '112.399243,34.654251', '99', '0', '2019-04-28 17:29:17', '2019-04-28 17:29:17');
INSERT INTO `districts` VALUES ('14', '9', '伊川县', 'district', '410329', '112.429384,34.423416', '99', '0', '2019-04-28 17:29:17', '2019-04-28 17:29:17');
INSERT INTO `districts` VALUES ('15', '9', '吉利区', 'district', '410306', '112.584796,34.899093', '99', '0', '2019-04-28 17:29:17', '2019-04-28 17:29:17');
INSERT INTO `districts` VALUES ('16', '9', '宜阳县', 'district', '410327', '112.179989,34.516478', '99', '0', '2019-04-28 17:29:17', '2019-04-28 17:29:17');
INSERT INTO `districts` VALUES ('17', '9', '洛宁县', 'district', '410328', '111.655399,34.387179', '99', '0', '2019-04-28 17:29:17', '2019-04-28 17:29:17');
INSERT INTO `districts` VALUES ('18', '9', '偃师市', 'district', '410381', '112.787739,34.723042', '99', '0', '2019-04-28 17:29:17', '2019-04-28 17:29:17');
INSERT INTO `districts` VALUES ('19', '9', '瀍河回族区', 'district', '410304', '112.491625,34.684738', '99', '0', '2019-04-28 17:29:17', '2019-04-28 17:29:17');
INSERT INTO `districts` VALUES ('20', '9', '洛龙区', 'district', '410311', '112.456634,34.618557', '99', '0', '2019-04-28 17:29:17', '2019-04-28 17:29:17');
INSERT INTO `districts` VALUES ('21', '9', '老城区', 'district', '410302', '112.477298,34.682945', '99', '0', '2019-04-28 17:29:17', '2019-04-28 17:29:17');
INSERT INTO `districts` VALUES ('22', '9', '西工区', 'district', '410303', '112.443232,34.667847', '99', '0', '2019-04-28 17:29:17', '2019-04-28 17:29:17');
INSERT INTO `districts` VALUES ('23', '9', '嵩县', 'district', '410325', '112.087765,34.131563', '99', '0', '2019-04-28 17:29:17', '2019-04-28 17:29:17');
INSERT INTO `districts` VALUES ('24', '9', '孟津县', 'district', '410322', '112.443892,34.826485', '99', '0', '2019-04-28 17:29:17', '2019-04-28 17:29:17');
INSERT INTO `districts` VALUES ('25', '1', '三门峡市', 'city', '411200', '111.194099,34.777338', '99', '0', '2019-04-28 17:29:17', '2019-04-28 17:29:17');
INSERT INTO `districts` VALUES ('26', '25', '湖滨区', 'district', '411202', '111.19487,34.77812', '99', '0', '2019-04-28 17:29:17', '2019-04-28 17:29:17');
INSERT INTO `districts` VALUES ('27', '25', '义马市', 'district', '411281', '111.869417,34.746868', '99', '0', '2019-04-28 17:29:17', '2019-04-28 17:29:17');
INSERT INTO `districts` VALUES ('28', '25', '渑池县', 'district', '411221', '111.762992,34.763487', '99', '0', '2019-04-28 17:29:17', '2019-04-28 17:29:17');
INSERT INTO `districts` VALUES ('29', '25', '卢氏县', 'district', '411224', '111.052649,34.053995', '99', '0', '2019-04-28 17:29:17', '2019-04-28 17:29:17');
INSERT INTO `districts` VALUES ('30', '25', '灵宝市', 'district', '411282', '110.88577,34.521264', '99', '0', '2019-04-28 17:29:17', '2019-04-28 17:29:17');
INSERT INTO `districts` VALUES ('31', '25', '陕州区', 'district', '411203', '111.103851,34.720244', '99', '0', '2019-04-28 17:29:18', '2019-04-28 17:29:18');
INSERT INTO `districts` VALUES ('32', '1', '漯河市', 'city', '411100', '114.026405,33.575855', '99', '0', '2019-04-28 17:29:18', '2019-04-28 17:29:18');
INSERT INTO `districts` VALUES ('33', '32', '临颍县', 'district', '411122', '113.938891,33.80609', '99', '0', '2019-04-28 17:29:18', '2019-04-28 17:29:18');
INSERT INTO `districts` VALUES ('34', '32', '源汇区', 'district', '411102', '114.017948,33.565441', '99', '0', '2019-04-28 17:29:18', '2019-04-28 17:29:18');
INSERT INTO `districts` VALUES ('35', '32', '舞阳县', 'district', '411121', '113.610565,33.436278', '99', '0', '2019-04-28 17:29:18', '2019-04-28 17:29:18');
INSERT INTO `districts` VALUES ('36', '32', '召陵区', 'district', '411104', '114.051686,33.567555', '99', '0', '2019-04-28 17:29:18', '2019-04-28 17:29:18');
INSERT INTO `districts` VALUES ('37', '32', '郾城区', 'district', '411103', '114.016813,33.588897', '99', '0', '2019-04-28 17:29:18', '2019-04-28 17:29:18');
INSERT INTO `districts` VALUES ('38', '1', '许昌市', 'city', '411000', '113.826063,34.022956', '99', '0', '2019-04-28 17:29:18', '2019-04-28 17:29:18');
INSERT INTO `districts` VALUES ('39', '38', '襄城县', 'district', '411025', '113.493166,33.855943', '99', '0', '2019-04-28 17:29:18', '2019-04-28 17:29:18');
INSERT INTO `districts` VALUES ('40', '38', '建安区', 'district', '411003', '113.842898,34.005018', '99', '0', '2019-04-28 17:29:18', '2019-04-28 17:29:18');
INSERT INTO `districts` VALUES ('41', '38', '魏都区', 'district', '411002', '113.828307,34.02711', '99', '0', '2019-04-28 17:29:18
评论0