【文件属性】:
文件名称:全国城市乡镇sql脚本
文件大小:36KB
文件格式:ZIP
更新时间:2022-08-20 03:14:17
mysql city
CREATE TABLE `town_` (
`id_` varchar(36) NOT NULL,
`city_code_` varchar(255) DEFAULT NULL,
`ct_` datetime DEFAULT NULL,
`is_delete_` int(11) DEFAULT NULL,
`lat_` decimal(19,6) DEFAULT NULL,
`lng_` decimal(19,6) DEFAULT NULL,
`name_` varchar(255) DEFAULT NULL,
`targer_name_` varchar(255) DEFAULT NULL,
`show_index_` int(9) DEFAULT NULL,
`cid_` varchar(255) DEFAULT '' COMMENT '公司id',
`city_name_` char(255) DEFAULT NULL COMMENT '城市名称',
`city_id_` char(36) DEFAULT NULL COMMENT '城市id',
`ct_id_` varchar(36) DEFAULT NULL COMMENT '创建人id',
`et_` datetime DEFAULT NULL COMMENT '修改时间',
`et_id_` varchar(36) DEFAULT NULL COMMENT '修改人id',
`g_c_id_` varchar(36) DEFAULT NULL COMMENT '公司ID',
PRIMARY KEY (`id_`),
KEY `NewIndex1` (`city_id_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Records of town_
-- ----------------------------
INSERT INTO `town_` VALUES ('00113ea047594f0cbc91a11abc37a0ba', '023', '2016-07-12 18:59:52', '1', '29.555236', '106.546967', '渝中', null, '100', '', '重庆市', '8a92c1c5-dec2-11e5-bcc3-00163e1c066c', null, null, null, null);
INSERT INTO `town_` VALUES ('004c2e1a384c4b15ab3a70c05940fc8f', '020', '2016-12-22 13:43:39', '1', '22.747632', '113.502645', '横沥', null, null, '', '广州市', '87a7daf8-dec4-11e5-bcc3-00163e1c066c', null, null, null, null);
INSERT INTO `town_` VALUES ('0187a9af37ee4169b4c09d11cde3aefc', '020', '2016-12-22 13:43:40', '1', '23.446661', '113.220176', '花都', null, null, '', '广州市', '87a7daf8-dec4-11e5-bcc3-00163e1c066c', null, null, null, null);
INSERT INTO `town_` VALUES ('01b263a3053a4116b887bf060ce8658a', '0411', '2017-01-03 22:36:47', '1', '39.620006', '122.274257', '普兰店', null, null, '', '大连市', '86389da7-dec4-11e5-bcc3-00163e1c066c', null, null, null, null);
INSERT INTO `town_` VALUES ('01e552d12230438e83404a886d879313', '', '2017-02-09 13:42:12', '1', '22.806493', '108.297234', '仙葫', null, null, '', '南宁市', 'fe12fb1f-ee89-11e6-ac77-00163e031edd', null, null, null, null);
INSERT INTO `town_` VALUES ('034060663f254efeb46d73d5d19639b9', '0536', '2018-11-07 16:45:14', '1', null, null, '滨海新区', null, null, '', '潍坊市',
CREATE TABLE `city_` (
`id_` varchar(36) NOT NULL,
`city_code_` varchar(45) DEFAULT NULL,
`content_` varchar(255) DEFAULT NULL,
`ct_` datetime DEFAULT NULL,
`is_delete_` smallint(9) DEFAULT NULL,
`jian_` varchar(255) DEFAULT NULL,
`lat_` decimal(9,6) DEFAULT NULL,
`lng_` decimal(9,6) DEFAULT NULL,
`name_` varchar(255) DEFAULT NULL,
`province_id_` varchar(36) DEFAULT NULL,
`quan_` varchar(255) DEFAULT NULL,
`show_index_` smallint(11) DEFAULT NULL,
`targer_name_` varchar(255) DEFAULT NULL,
`city_name_` char(255) DEFAULT NULL COMMENT '省名称',
`city_id_` char(36) DEFAULT NULL COMMENT '省id',
`ct_id_` varchar(36) DEFAULT NULL COMMENT '创建人id',
`et_` datetime DEFAULT NULL COMMENT '修改时间',
`et_id_` varchar(36) DEFAULT NULL COMMENT '修改人id',
`tbl_index_` bigint(11) NOT NULL AUTO_INCREMENT COMMENT '下标',
PRIMARY KEY (`id_`),
UNIQUE KEY `tbl_index_` (`tbl_index_`),
KEY `NewIndex1` (`city_code_`)
) ENGINE=InnoDB AUTO_INCREMENT=256 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
-- ----------------------------
-- Records of city_
-- ----------------------------
INSERT INTO `city_` VALUES ('0563c58d-db26-11e7-be6b-00163e06854a', '0825', '', '2017-12-07 16:10:00', '1', null, '30.533872', '105.591373', '遂宁市', '56afdb02-dec0-11e5-bcc3-00163e1c066c', null, null, null, null, null, null, null, null, '253');
INSERT INTO `city_` VALUES ('14a8db26-73d8-11e8-bf8c-7cd30ae45df2', null, '8710', '2018-06-20 00:00:56', '1', null, '38.489977', '106.236771', '银川市', '56c6f68c-dec0-11e5-bcc3-00163e1c066c', null, null, null, null, null, null, null, null, '255');
INSERT INTO `city_` VALUES ('15f5e037250e44b69aadfc9ccba92e46', '0852', '系统导入', '2016-07-25 18:31:30', '1', 'zy', null, null, '遵义市', '56b1d412-dec0-11e5-bcc3-00163e1c066c', 'zunyi', null, null, null, null, null, null, null, '1');
INSERT INTO `city_` VALUES ('3430a6c9602b45c28e174a9da7cf9bfc', '0851', '系统导入', '2016-07-25 18:18:11', '1', 'gy', '26.622004', '106.685684', '贵阳市', '56b1d412-dec0-11e5-bcc3-00163e1c066c', 'giuyang', null, null, null, null, null, null, null, '2');
【文件预览】:
city_.sql
town_.sql