/*
Navicat MySQL Data Transfer
Source Server : test
Source Server Version : 50173
Source Database : jeesite
Target Server Type : MYSQL
Target Server Version : 50173
File Encoding : 65001
Date: 2017-12-06 11:58:09
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for sys_area
-- ----------------------------
DROP TABLE IF EXISTS `sys_area`;
CREATE TABLE `sys_area` (
`id` varchar(64) COLLATE utf8_bin NOT NULL COMMENT '编号',
`parent_id` varchar(64) COLLATE utf8_bin NOT NULL COMMENT '父级编号',
`parent_ids` varchar(2000) COLLATE utf8_bin NOT NULL COMMENT '所有父级编号',
`name` varchar(100) COLLATE utf8_bin NOT NULL COMMENT '名称',
`sort` decimal(10,0) NOT NULL COMMENT '排序',
`code` varchar(100) COLLATE utf8_bin DEFAULT NULL COMMENT '区域编码',
`type` char(1) COLLATE utf8_bin DEFAULT NULL COMMENT '区域类型',
`create_by` varchar(64) COLLATE utf8_bin NOT NULL COMMENT '创建者',
`create_date` datetime NOT NULL COMMENT '创建时间',
`update_by` varchar(64) COLLATE utf8_bin NOT NULL COMMENT '更新者',
`update_date` datetime NOT NULL COMMENT '更新时间',
`remarks` varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT '备注信息',
`del_flag` char(1) COLLATE utf8_bin NOT NULL DEFAULT '0' COMMENT '删除标记',
PRIMARY KEY (`id`),
KEY `sys_area_parent_id` (`parent_id`),
KEY `sys_area_del_flag` (`del_flag`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='区域表';
-- ----------------------------
-- Records of sys_area
-- ----------------------------
INSERT INTO `sys_area` VALUES ('0087ab5160db4b048a7366d43e86a120', '114', '0,11,114', '南浔区', '100', '330503', '4', '0', '2017-11-30 13:59:16', '0', '2017-11-30 13:59:16', null, '0');
INSERT INTO `sys_area` VALUES ('0089cf32db0b4feab56b68965650a777', '43', '0,3,43', '桥西区', '100', '130703', '4', '0', '2017-11-30 14:01:14', '0', '2017-11-30 14:01:14', null, '0');
INSERT INTO `sys_area` VALUES ('009bb7890bef44e4b26355ee0324694b', '380', '0,24,380', '焉耆回族自治县', '100', '652826', '4', '0', '2017-11-30 14:00:45', '0', '2017-11-30 14:00:45', null, '0');
INSERT INTO `sys_area` VALUES ('00afb4e0a0d74e8895992fdf4bb62f72', '168', '0,15,168', '郯城县', '100', '371322', '4', '0', '2017-11-30 13:59:44', '0', '2017-11-30 13:59:44', null, '0');
INSERT INTO `sys_area` VALUES ('00bbbd7384ff4745a2b35bc28af488d4', '310', '0,30,310', '巧家县', '100', '530622', '4', '0', '2017-11-30 14:01:21', '0', '2017-11-30 14:01:21', null, '0');
INSERT INTO `sys_area` VALUES ('00d0edbaec0744e6b06aefa31136b86b', '78', '0,7,78', '珲春市', '100', '222404', '4', '0', '2017-11-30 14:01:54', '0', '2017-11-30 14:01:54', null, '0');
INSERT INTO `sys_area` VALUES ('0103943a0e004e4a86c35f079af063e7', '45', '0,3,45', '开平区', '100', '130205', '4', '0', '2017-11-30 14:01:16', '0', '2017-11-30 14:01:16', null, '0');
INSERT INTO `sys_area` VALUES ('0122c6f8dab34fd6b8537da777925a74', '162', '0,15,162', '博山区', '100', '370304', '4', '0', '2017-11-30 13:59:40', '0', '2017-11-30 13:59:40', null, '0');
INSERT INTO `sys_area` VALUES ('0148fb0c736c46ac8fbfff1a53b395a0', '267', '0,28,267', '邻水县', '100', '511623', '4', '0', '2017-11-30 14:00:56', '0', '2017-11-30 14:00:56', null, '0');
INSERT INTO `sys_area` VALUES ('017af725b4c04b8cb735258138c190d6', '318', '0,30,318', '禄丰县', '100', '532331', '4', '0', '2017-11-30 14:01:27', '0', '2017-11-30 14:01:27', null, '0');
INSERT INTO `sys_area` VALUES ('018eade9f9dd4479a4d1ae842b2e13cb', '164', '0,15,164', '栖霞市', '100', '370686', '4', '0', '2017-11-30 13:59:42', '0', '2017-11-30 13:59:42', null, '0');
INSERT INTO `sys_area` VALUES ('01a243ed5cc745dda951010321492587', '262', '0,28,262', '贡井区', '100', '510303', '4', '0', '2017-11-30 14:00:53', '0', '2017-11-30 14:00:53', null, '0');
INSERT INTO `sys_area` VALUES ('01ee76c8395f495e9bdf8ea297b2258a', '121', '0,11,121', '黄岩区', '100', '331003', '4', '0', '2017-11-30 13:59:19', '0', '2017-11-30 13:59:19', null, '0');
INSERT INTO `sys_area` VALUES ('01eff676eb6c4b3cb14e1b722eaf3b52', '65', '0,6,65', '海城市', '100', '210381', '4', '0', '2017-11-30 14:01:49', '0', '2017-11-30 14:01:49', null, '0');
INSERT INTO `sys_area` VALUES ('0208ed04bdff43c8b6f80b6b76e81445', '107', '0,10,107', '海州区', '100', '320706', '4', '0', '2017-11-30 13:59:11', '0', '2017-11-30 13:59:11', null, '0');
INSERT INTO `sys_area` VALUES ('020b50a4882249c9b4a7816cb17463a0', '325', '0,25,325', '城北区', '100', '630105', '4', '0', '2017-11-30 14:00:48', '0', '2017-11-30 14:00:48', null, '0');
INSERT INTO `sys_area` VALUES ('020c084cdadc4d6da7ef154aaa66ac04', '79', '0,7,79', '铁西区', '100', '220302', '4', '0', '2017-11-30 14:01:54', '0', '2017-11-30 14:01:54', null, '0');
INSERT INTO `sys_area` VALUES ('02100377a31d48f38c80b2f92ac30727', '347', '0,21,347', '永福县', '100', '450326', '4', '0', '2017-11-30 14:00:24', '0', '2017-11-30 14:00:24', null, '0');
INSERT INTO `sys_area` VALUES ('021fd9f7c46c49a79f1e615b226fc8d2', '120', '0,11,120', '义乌市', '100', '330782', '4', '0', '2017-11-30 13:59:19', '0', '2017-11-30 13:59:19', null, '0');
INSERT INTO `sys_area` VALUES ('0253fe5600b34f569e55d60e6ba0efd2', '161', '0,15,161', '崂山区', '100', '370212', '4', '0', '2017-11-30 13:59:39', '0', '2017-11-30 13:59:39', null, '0');
INSERT INTO `sys_area` VALUES ('0273e283ab974cf183c0f5f76554c1d3', '310', '0,30,310', '大关县', '100', '530624', '4', '0', '2017-11-30 14:01:21', '0', '2017-11-30 14:01:21', null, '0');
INSERT INTO `sys_area` VALUES ('0286581a2d394eeda603f6543d0c2475', '150', '0,14,150', '南昌县', '100', '360121', '4', '0', '2017-11-30 13:59:33', '0', '2017-11-30 13:59:33', null, '0');
INSERT INTO `sys_area` VALUES ('02a09517941f49e0b32cad2702137923', '314', '0,30,314', '富源县', '100', '530325', '4', '0', '2017-11-30 14:01:25', '0', '2017-11-30 14:01:25', null, '0');
INSERT INTO `sys_area` VALUES ('02a2a12ad2964989bdf75892452122d8', '109', '0,10,109', '泰兴市', '100', '321283', '4', '0', '2017-11-30 13:59:12', '0', '2017-11-30 13:59:12', null, '0');
INSERT INTO `sys_area` VALUES ('02a5b2030d0c4b88ba046643cf3e304d', '347', '0,21,347', '恭城瑶族自治县', '100', '450332', '4', '0', '2017-11-30 14:00:24', '0', '2017-11-30 14:00:24', null, '0');
INSERT INTO `sys_area` VALUES ('02b472aefd9e4e88840d5fe8e91a244f', '391', '0,5,391', '科尔沁区', '100', '150502', '4', '0', '2017-11-30 14:01:43', '0', '2017-11-30 14:01:43', null, '0');
INSERT INTO `sys_area` VALUES ('02f4a21293394fcfa3982acb8fb7c573', '377', '0,24,377', '阜康市', '100', '652302', '4', '0', '2017-11-30 14:00:44', '0', '2017-11-30 14:00:44', null, '0');
INSERT INTO `sys_area` VALUES ('032fb7ac409b46a599e6f7a4af5e3b99', '122', '0,12,122', '蜀山区', '100', '340104', '4', '0', '2017-11-30 13:59:20', '0', '2017-11-30 13:59:20', null, '0');
INSERT INTO `sys_area` VALUES ('0337ce12070646f5a580bcffcc95fee8', '284', '0,29,284', '贵定县', '100', '522723', '4', '0', '2017-11-30 14:01:07', '0', '2017-11-30 14:01:07', null, '0');
INSERT INTO `sys_area` VALUES ('0370dc8e2fe04a069f891bb02dd98b59', '203', '0,17,203', '来凤县', '100', '422827', '4', '0', '2017-11-30 14:00:04', '0', '2017-11-30 14:00:04', null, '0');
INSERT INTO `sys_area` VALUES ('039f83199f6d45aca4d218106fd21d16', '280', '0,28,280', '苍溪县', '100', '510824', '4', '0', '2017-11-30 14:01:05', '0', '2017-11-30 14:01:05', null, '0');
INSERT INTO `sys_area` VALUES ('03b887f2b8894a959ca31871fe52b0d5', '195', '0,17,195', '宜城市', '100', '420684', '4', '0', '2017-11-30 14:00:00', '0', '2017-11-30 14:00:00', null, '0');
INSERT INTO `sys_area` VALUES ('04075d834a4848d6be89033737092618', '202', '0,17,202', '兴山县', '100', '420526', '4', '0', '2017-11-30 14:00:03', '0', '2017-11-30 14:00:03', null, '0');
INSERT INTO `sys_area` VALUES ('0413695799db4ab2b0e2da2675834a7d', '338',
vue省市区三级联动mysql,js,html/jsp
需积分: 10 56 浏览量
2017-12-06
19:49:48
上传
评论
收藏 264KB ZIP 举报
烤鸭的世界我们不懂
- 粉丝: 4279
- 资源: 8
最新资源
- CVE-2019-0708漏洞检测与利用工具
- STM32单片机FPGA毕设电路原理论文报告利用c8051f020系列单片机实现智能仪器开发
- STM32单片机FPGA毕设电路原理论文报告利用8位单片机实现与Internet网络通信应用研究
- STM32单片机FPGA毕设电路原理论文报告利用80C196单片机测量三相异步电动机功率因数
- STM32单片机FPGA毕设电路原理论文报告力学传感器与单片机的接口设计
- p107-u07FLT2.wav
- STM32单片机FPGA毕设电路原理论文报告雷达幅频特性测试仪的智能化研究
- STM32单片机FPGA毕设电路原理论文报告可组网电子温湿度测量仪的设计与实现
- STM32单片机FPGA毕设电路原理论文报告可在单片机上实现的语音混沌保密通信方法
- STM32单片机FPGA毕设电路原理论文报告可实现的基于MCS51单片机的恒温控制系统的设计
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈