代码拉取完成,页面将自动刷新
/*
Navicat MySQL Data Transfer
Source Server : mysql
Source Server Version : 50717
Source Host : localhost:3306
Source Database : zsshop
Target Server Type : MYSQL
Target Server Version : 50717
File Encoding : 65001
Date: 2017-04-19 14:32:19
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for sys_area
-- ----------------------------
DROP TABLE IF EXISTS `sys_area`;
CREATE TABLE `sys_area` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
`parent_id` bigint(20) NOT NULL COMMENT '父级编号',
`parent_ids` varchar(2000) DEFAULT NULL COMMENT '所有父级编号',
`code` varchar(100) DEFAULT NULL COMMENT '区域编码',
`name` varchar(100) NOT NULL COMMENT '区域名称',
`type` char(1) DEFAULT NULL COMMENT '区域类型',
`create_by` bigint(64) DEFAULT NULL COMMENT '创建者',
`create_date` datetime DEFAULT NULL COMMENT '创建时间',
`update_by` varchar(64) DEFAULT NULL COMMENT '更新者',
`update_date` datetime DEFAULT NULL COMMENT '更新时间',
`remarks` varchar(255) DEFAULT NULL COMMENT '备注信息',
`del_flag` char(1) DEFAULT '0' COMMENT '删除标记(0活null 正常 1,删除)',
`icon` varchar(64) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `sys_area_parent_id` (`parent_id`),
KEY `sys_area_parent_ids` (`parent_ids`(255)),
KEY `sys_area_del_flag` (`del_flag`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='区域表';
-- ----------------------------
-- Records of sys_area
-- ----------------------------
INSERT INTO `sys_area` VALUES ('1', '2', '0,0,2,', 'bj', '北京', '1', '2', '2016-12-22 20:11:20', null, null, '', '0', 'fa fa-calculator');
INSERT INTO `sys_area` VALUES ('2', '0', '0,0,', 'china', '中国', '1', '2', '2016-12-22 20:12:37', null, null, '', '0', 'fa fa-meanpath');
-- ----------------------------
-- Table structure for sys_dict
-- ----------------------------
DROP TABLE IF EXISTS `sys_dict`;
CREATE TABLE `sys_dict` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
`label` varchar(100) NOT NULL COMMENT '标签名',
`value` varchar(100) NOT NULL COMMENT '数据值',
`type` varchar(100) NOT NULL COMMENT '类型',
`description` varchar(100) NOT NULL COMMENT '描述',
`sort` int(11) NOT NULL DEFAULT '1' COMMENT '排序(升序)',
`create_by` bigint(64) DEFAULT NULL COMMENT '创建者',
`create_date` datetime DEFAULT NULL COMMENT '创建时间',
`update_by` varchar(64) DEFAULT NULL COMMENT '更新者',
`update_date` datetime DEFAULT NULL COMMENT '更新时间',
`remarks` varchar(255) DEFAULT NULL COMMENT '备注信息',
`del_flag` char(1) NOT NULL DEFAULT '0' COMMENT '删除标记',
PRIMARY KEY (`id`),
KEY `sys_dict_value` (`value`),
KEY `sys_dict_label` (`label`),
KEY `sys_dict_del_flag` (`del_flag`)
) ENGINE=InnoDB AUTO_INCREMENT=67 DEFAULT CHARSET=utf8 COMMENT='字典表';
-- ----------------------------
-- Records of sys_dict
-- ----------------------------
INSERT INTO `sys_dict` VALUES ('1', '正常', '0', 'del_flag', '删除标记', '10', '1', '2013-05-27 08:00:00', '2,超级管理员', '2015-02-28 23:07:13', null, '0');
INSERT INTO `sys_dict` VALUES ('2', '删除', '1', 'del_flag', '删除标记', '20', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
INSERT INTO `sys_dict` VALUES ('3', '显示', '1', 'show_hide', '显示/隐藏', '10', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
INSERT INTO `sys_dict` VALUES ('4', '隐藏', '0', 'show_hide', '显示/隐藏', '20', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
INSERT INTO `sys_dict` VALUES ('5', '是', '1', 'yes_no', '是/否', '10', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
INSERT INTO `sys_dict` VALUES ('6', '否', '0', 'yes_no', '是/否', '20', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
INSERT INTO `sys_dict` VALUES ('17', '国家', '1', 'sys_area_type', '区域类型', '10', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
INSERT INTO `sys_dict` VALUES ('18', '省份、直辖市', '2', 'sys_area_type', '区域类型', '20', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
INSERT INTO `sys_dict` VALUES ('19', '地市', '3', 'sys_area_type', '区域类型', '30', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
INSERT INTO `sys_dict` VALUES ('20', '区县', '4', 'sys_area_type', '区域类型', '40', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
INSERT INTO `sys_dict` VALUES ('22', '部门', '2', 'sys_office_type', '机构类型', '70', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
INSERT INTO `sys_dict` VALUES ('23', '一级', '1', 'sys_office_grade', '机构等级', '10', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
INSERT INTO `sys_dict` VALUES ('24', '二级', '2', 'sys_office_grade', '机构等级', '20', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
INSERT INTO `sys_dict` VALUES ('25', '三级', '3', 'sys_office_grade', '机构等级', '30', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
INSERT INTO `sys_dict` VALUES ('26', '四级', '4', 'sys_office_grade', '机构等级', '40', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
INSERT INTO `sys_dict` VALUES ('27', '所有数据', '1', 'sys_data_scope', '数据范围', '10', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
INSERT INTO `sys_dict` VALUES ('28', '所在公司及以下数据', '2', 'sys_data_scope', '数据范围', '20', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
INSERT INTO `sys_dict` VALUES ('29', '所在公司数据', '3', 'sys_data_scope', '数据范围', '30', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
INSERT INTO `sys_dict` VALUES ('30', '所在部门及以下数据', '4', 'sys_data_scope', '数据范围', '40', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
INSERT INTO `sys_dict` VALUES ('31', '所在部门数据', '5', 'sys_data_scope', '数据范围', '50', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
INSERT INTO `sys_dict` VALUES ('32', '仅本人数据', '8', 'sys_data_scope', '数据范围', '90', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
INSERT INTO `sys_dict` VALUES ('33', '按明细设置', '9', 'sys_data_scope', '数据范围', '100', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
INSERT INTO `sys_dict` VALUES ('34', '系统管理', '1', 'sys_user_type', '用户类型', '10', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
INSERT INTO `sys_dict` VALUES ('35', '部门经理', '2', 'sys_user_type', '用户类型', '20', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
INSERT INTO `sys_dict` VALUES ('36', '普通用户', '3', 'sys_user_type', '用户类型', '30', '1', '2013-05-27 08:00:00', '1', '2013-05-27 08:00:00', null, '0');
INSERT INTO `sys_dict` VALUES ('62', '操作日志', '1', 'sys_log_type', '日志类型', '30', '1', '2013-06-03 08:00:00', '1', '2013-06-03 08:00:00', null, '0');
INSERT INTO `sys_dict` VALUES ('63', '异常日志', '2', 'sys_log_type', '日志类型', '40', '1', '2013-06-03 08:00:00', '1', '2013-06-03 08:00:00', null, '0');
INSERT INTO `sys_dict` VALUES ('64', '单表增删改查', 'single', 'prj_template_type', '代码模板', '10', '1', '2013-06-03 08:00:00', '1', '2013-06-03 08:00:00', null, '0');
INSERT INTO `sys_dict` VALUES ('65', '所有entity和dao', 'entityAndDao', 'prj_template_type', '代码模板', '20', '1', '2013-06-03 08:00:00', '1', '2013-06-03 08:00:00', null, '0');
INSERT INTO `sys_dict` VALUES ('66', '公司', '1', 'sys_office_type', '', '1', null, '2015-01-10 22:15:43', null, '2015-01-10 22:15:43', null, '0');
-- ----------------------------
-- Table structure for sys_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_log`;
CREATE TABLE `sys_log` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
`type` char(1) DEFAULT '1' COMMENT '日志类型',
`create_by` varchar(64) DEFAULT NULL COMMENT '创建者',
`create_date` datetime DEFAULT NULL COMMENT '创建时间',
`remote_addr` varchar(255) DEFAULT NULL COMMENT '操作IP地址',
`user_agent` varchar(255) DEFAULT NULL COMMENT '用户代理',
`request_uri` varchar(255) DEFAULT NULL COMMENT '请求URI',
`method` varchar(5) DEFAULT NULL COMMENT '操作方式',
`params` text COMMENT '操作提交的数据',
`exception` text COMMENT '异常信息',
`description` text COMMENT '描述',
PRIMARY KEY (`id`),
KEY `sys_log_create_by` (`create_by`),
KEY `sys_log_request_uri` (`request_uri`),
KEY `sys_log_type` (`type`),
KEY `sys_log_create_date` (`create_date`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8 COMMENT='日志表';
-- ----------------------------
-- Records of sys_log
-- ----------------------------
INSERT INTO `sys_log` VALUES ('20', '2', '2,超级管理员', '2015-03-01 14:23:57', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/31.0.1650.63 Safari/537.36', '/mytemplate/test/area/save', 'POST', '[参数1,类型:SysArea,值:{\"updateBy\":\"2,超级管理员\",\"id\":1,\"parentId\":0,\"icon\":\"fa fa-institution\",\"parentIds\":\"0,\",\"oldParentIds\":\"0,\",\"name\":\"中国\",\"remarks\":\"\",\"code\":\"100000\",\"type\":\"1\",\"updateDate\":1425191037467}]', 'java.lang.ArithmeticException: / by zero', null);
INSERT INTO `sys_log` VALUES ('21', '2', '2,超级管理员', '2015-03-01 14:24:42', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/31.0.1650.63 Safari/537.36', '/mytemplate/test/area/save', 'POST', '[参数1,类型:SysArea,值:{\"updateBy\":\"2,超级管理员\",\"id\":1,\"parentId\":0,\"icon\":\"fa fa-institution\",\"parentIds\":\"0,\",\"oldParentIds\":\"0,\",\"name\":\"中国\",\"remarks\":\"\",\"code\":\"100000\",\"type\":\"1\",\"updateDate\":1425191082730}]', 'java.lang.ArithmeticException: / by zero', null);
INSERT INTO `sys_log` VALUES ('22', '2', '2,超级管理员', '2015-03-01 14:25:53', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/31.0.1650.63 Safari/537.36', '/mytemplate/test/area/save', 'POST', '[参数1,类型:SysArea,值:{\"updateBy\":\"2,超级管理员\",\"id\":1,\"parentId\":0,\"icon\":\"fa fa-institution\",\"parentIds\":\"0,\",\"oldParentIds\":\"0,\",\"name\":\"中国\",\"remarks\":\"\",\"code\":\"100000\",\"type\":\"1\",\"updateDate\":1425191153080}]', 'java.lang.ArithmeticException: / by zero', null);
INSERT INTO `sys_log` VALUES ('23', '2', '2,超级管理员', '2015-03-01 14:30:23', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/31.0.1650.63 Safari/537.36', '/mytemplate/test/area/save', 'POST', '[参数1,类型:SysArea,值:{\"updateBy\":\"2,超级管理员\",\"id\":1,\"parentId\":0,\"icon\":\"fa fa-institution\",\"parentIds\":\"0,\",\"oldParentIds\":\"0,\",\"name\":\"中国\",\"remarks\":\"\",\"code\":\"100000\",\"type\":\"1\",\"updateDate\":1425191423732}]', 'java.lang.ArithmeticException: / by zero', null);
INSERT INTO `sys_log` VALUES ('24', '2', '2,超级管理员', '2015-03-01 14:39:04', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/31.0.1650.63 Safari/537.36', '/mytemplate/test/area/save', 'POST', '[参数1,类型:SysArea,值:{\"updateBy\":\"2,超级管理员\",\"id\":1,\"parentId\":0,\"icon\":\"fa fa-institution\",\"parentIds\":\"0,\",\"oldParentIds\":\"0,\",\"name\":\"中国\",\"remarks\":\"\",\"code\":\"100000\",\"type\":\"1\",\"updateDate\":1425191923185}]', 'java.lang.ArithmeticException: / by zero', null);
INSERT INTO `sys_log` VALUES ('25', '2', '2,超级管理员', '2015-03-29 17:18:50', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/31.0.1650.63 Safari/537.36', '/mytemplate/menu/list', 'POST', '[参数1,类型:LinkedHashMap,值:{name=, id=, pageNum=1, pageSize=10, _ORIGINAL_PARAMETER_OBJECT=(this Map), First_PageHelper=0, Second_PageHelper=10}]', 'org.springframework.jdbc.BadSqlGrammarException: \r\n### Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column \'sr.code\' in \'field list\'\r\n### The error may exist in file [E:\\develop_software\\Tomcat\\apache-tomcat-8.0.20\\webapps\\mytemplate\\WEB-INF\\classes\\com\\template\\web\\sys\\mapper\\SysResourceMapper.xml]\r\n### The error may involve defaultParameterMap\r\n### The error occurred while setting parameters\r\n### SQL: select sr.id,sr.code,sr.description,sr.icon,sr.name,sr.sort,sr.common,sr.pos, sr.status,sr.type,sr.url,srp.name pname,srp.id pid from sys_resource sr left join sys_resource srp ON sr.parent_id=srp.id ORDER BY sr.update_date desc limit ?,?\r\n### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column \'sr.code\' in \'field list\'\n; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column \'sr.code\' in \'field list\'', null);
INSERT INTO `sys_log` VALUES ('26', '2', '2,超级管理员', '2016-12-01 16:33:31', '0:0:0:0:0:0:0:1', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/54.0.2840.99 Safari/537.36', '/licese/buyLicense/audit', 'POST', '[参数1,类型:BuyLicense,值:{\"id\":1,\"auditcontent\":\"已经付完钱了\",\"status\":1}]', 'java.lang.NullPointerException', null);
-- ----------------------------
-- Table structure for sys_office
-- ----------------------------
DROP TABLE IF EXISTS `sys_office`;
CREATE TABLE `sys_office` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
`parent_id` bigint(20) NOT NULL COMMENT '父级编号',
`parent_ids` varchar(2000) NOT NULL COMMENT '所有父级编号',
`area_id` bigint(20) NOT NULL COMMENT '归属区域',
`code` varchar(100) DEFAULT NULL COMMENT '区域编码',
`name` varchar(100) NOT NULL COMMENT '机构名称',
`type` char(1) DEFAULT NULL COMMENT '机构类型',
`grade` char(1) DEFAULT NULL COMMENT '机构等级',
`address` varchar(255) DEFAULT NULL COMMENT '联系地址',
`zip_code` varchar(100) DEFAULT NULL COMMENT '邮政编码',
`master` varchar(100) DEFAULT NULL COMMENT '负责人',
`phone` varchar(200) DEFAULT NULL COMMENT '电话',
`fax` varchar(200) DEFAULT NULL COMMENT '传真',
`email` varchar(200) DEFAULT NULL COMMENT '邮箱',
`create_by` bigint(64) DEFAULT NULL COMMENT '创建者',
`create_date` datetime DEFAULT NULL COMMENT '创建时间',
`update_by` varchar(64) DEFAULT NULL COMMENT '更新者',
`update_date` datetime DEFAULT NULL COMMENT '更新时间',
`remarks` varchar(255) DEFAULT NULL COMMENT '备注信息',
`del_flag` char(1) NOT NULL DEFAULT '0' COMMENT '删除标记',
`icon` varchar(64) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `sys_office_parent_id` (`parent_id`),
KEY `sys_office_parent_ids` (`parent_ids`(255)),
KEY `sys_office_del_flag` (`del_flag`)
) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT CHARSET=utf8 COMMENT='机构表';
-- ----------------------------
-- Records of sys_office
-- ----------------------------
INSERT INTO `sys_office` VALUES ('50', '0', '0,', '1', null, '北京zscat科技有限公司', '1', '1', '', null, 'zscat', '', '', '', '2', '2016-12-22 20:14:09', null, null, '', '0', 'fa fa-cc-mastercard');
-- ----------------------------
-- Table structure for sys_resource
-- ----------------------------
DROP TABLE IF EXISTS `sys_resource`;
CREATE TABLE `sys_resource` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`name` varchar(64) DEFAULT NULL COMMENT '资源名称',
`common` char(1) DEFAULT '0' COMMENT '是否是公共资源(0.不是 1.是)',
`icon` varchar(64) DEFAULT NULL COMMENT '图标',
`sort` int(11) DEFAULT '1' COMMENT '排序号',
`parent_id` bigint(20) DEFAULT NULL COMMENT '父级id',
`type` char(1) DEFAULT '0' COMMENT '类型(0.菜单 1.按钮)',
`url` varchar(255) DEFAULT NULL COMMENT '链接',
`description` varchar(255) DEFAULT NULL COMMENT '描述',
`status` char(1) DEFAULT '0' COMMENT '状态(0.正常 1.禁用)',
`parent_ids` varchar(2000) DEFAULT NULL COMMENT '父级集合',
`create_date` datetime DEFAULT NULL,
`update_date` datetime DEFAULT NULL,
`create_by` varchar(64) DEFAULT NULL,
`update_by` varchar(64) DEFAULT NULL,
`del_flag` char(1) DEFAULT '0',
`permission_str` varchar(100) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=250 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of sys_resource
-- ----------------------------
INSERT INTO `sys_resource` VALUES ('1', '菜单配置', '0', 'fa fa-list', '1', '188', '0', 'menu', '', '0', '0,188,', null, '2015-03-11 23:12:27', null, '2,超级管理员', '0', null);
INSERT INTO `sys_resource` VALUES ('181', '区域管理', '0', 'fa fa-globe', '9', '188', '0', 'sysarea', '', '0', '0,188,', null, '2016-12-01 14:45:27', null, '2,超级管理员', '0', null);
INSERT INTO `sys_resource` VALUES ('188', '系统管理', '0', 'fa fa-cogs', '1', '0', '0', '', '', '0', '0,', null, '2015-03-12 23:57:18', null, '2,超级管理员', '0', null);
INSERT INTO `sys_resource` VALUES ('190', '字典管理', '0', 'fa fa-calculator', '1', '188', '0', 'dict', '', '0', '0,188,', null, '2015-03-11 23:12:41', null, '2,超级管理员', '0', null);
INSERT INTO `sys_resource` VALUES ('192', '机构管理', '0', 'fa fa-sitemap', '1', '188', '0', 'office', '', '0', '0,188,', null, '2016-12-01 14:44:54', null, '2,超级管理员', '0', null);
INSERT INTO `sys_resource` VALUES ('193', '用户管理', '0', 'fa fa-user', '1', '188', '0', 'sysuser', '', '0', '0,188,', null, '2016-12-01 14:45:06', null, '2,超级管理员', '0', null);
INSERT INTO `sys_resource` VALUES ('194', '角色管理', '0', 'fa fa-graduation-cap', '2', '188', '0', 'role', '', '0', '0,188,', null, '2016-12-01 14:45:15', null, '2,超级管理员', '0', null);
INSERT INTO `sys_resource` VALUES ('195', '日志查询', '0', 'fa fa-copy', '1', '188', '0', 'syslog', '', '0', '0,188,', null, null, null, null, '0', null);
INSERT INTO `sys_resource` VALUES ('203', '搜索按钮', '0', 'fa fa-angellist', '1', '181', '1', 'sys:area:find', '这是一个按钮级别的示例,页面为添加,请添加@if(auth.hasPermission(\"sys:area:find\")){}测试', '0', '0,188,181,', '2015-01-20 20:50:16', '2015-01-20 20:57:38', '22', '22', '0', null);
INSERT INTO `sys_resource` VALUES ('204', '系统监控', '0', 'fa fa-binoculars', '6', '0', '0', '', '', '0', '0,', '2015-03-03 20:11:10', '2015-03-11 23:12:56', '2,超级管理员', '2,超级管理员', '0', null);
INSERT INTO `sys_resource` VALUES ('205', 'Ehcache监控', '0', 'fa fa-crosshairs', '1', '204', '0', 'monitor/ehcache', '', '0', '0,204,', '2015-03-03 20:11:19', '2015-03-11 23:15:52', '2,超级管理员', '2,超级管理员', '0', null);
INSERT INTO `sys_resource` VALUES ('206', 'jvm监控', '0', 'fa fa-flash', '1', '204', '0', 'monitor/jvm', '', '0', '0,204,', '2015-03-08 11:17:00', '2015-03-11 23:20:19', '2,超级管理员', '2,超级管理员', '0', null);
INSERT INTO `sys_resource` VALUES ('207', '执行sql', '0', 'fa fa-ge', '1', '204', '0', 'monitor/db/sql', '', '0', '0,204,', '2015-03-09 21:07:49', '2015-03-11 23:18:39', '2,超级管理员', '2,超级管理员', '0', null);
INSERT INTO `sys_resource` VALUES ('208', '数据库监控', '0', 'fa fa-github-alt', '1', '204', '0', 'monitor/db/druid', '', '0', '0,204,', '2015-03-10 21:11:20', '2015-03-11 23:19:56', '2,超级管理员', '2,超级管理员', '0', null);
INSERT INTO `sys_resource` VALUES ('219', 'database', '0', '', '1', '204', '0', 'database', '', '0', '0,204,', '2016-12-02 11:55:58', '2016-12-02 11:55:58', null, null, '0', null);
INSERT INTO `sys_resource` VALUES ('226', '项目管理', '0', 'fa fa-cc-mastercard', '1', '0', '0', '', '', '0', '0,', '2016-12-22 09:51:14', null, '2', null, '0', null);
INSERT INTO `sys_resource` VALUES ('227', '项目列表', '0', '', '1', '226', '0', 'product', '', '0', '0,226,', '2016-12-22 09:51:33', null, '2', null, '0', null);
INSERT INTO `sys_resource` VALUES ('228', '项目类型', '0', '', '2', '226', '0', 'productType', '', '0', '0,226,', '2016-12-22 09:51:54', null, '2', null, '0', null);
INSERT INTO `sys_resource` VALUES ('229', '产品类别', '0', '', '1', '226', '0', 'productClass', '', '0', '0,226,', '2016-12-22 14:16:27', null, '2', null, '0', null);
INSERT INTO `sys_resource` VALUES ('230', '楼层管理', '0', '', '4', '226', '0', 'floor', '', '0', '0,226,', '2016-12-22 14:16:52', null, '2', null, '0', null);
INSERT INTO `sys_resource` VALUES ('231', '博客管理', '0', 'fa fa-meanpath', '1', '0', '0', '', '', '0', '0,', '2016-12-22 18:12:52', null, '2', null, '0', null);
INSERT INTO `sys_resource` VALUES ('232', '博客类型', '0', '', '2', '231', '0', 'blogType', '', '0', '0,231,', '2016-12-22 18:13:17', null, '2', null, '0', null);
INSERT INTO `sys_resource` VALUES ('233', '文章管理', '0', '', '1', '231', '0', 'blog', '', '0', '0,231,', '2016-12-22 18:13:32', null, '2', null, '0', null);
INSERT INTO `sys_resource` VALUES ('234', '模板管理', '0', '', '4', '231', '0', 'blogTemplate', '', '0', '0,231,', '2016-12-22 18:13:46', null, '2', null, '0', null);
INSERT INTO `sys_resource` VALUES ('235', '留言管理', '0', '', '5', '231', '0', 'comment', '', '0', '0,231,', '2016-12-22 18:13:58', null, '2', null, '0', null);
INSERT INTO `sys_resource` VALUES ('236', '友好链接', '0', '', '1', '231', '0', 'link', '', '0', '0,231,', '2016-12-22 18:14:09', null, '2', null, '0', null);
INSERT INTO `sys_resource` VALUES ('237', '图表展示', '0', '', '7', '188', '0', 'chart', '', '0', '0,188,', '2016-12-22 18:14:24', null, '2', null, '0', null);
INSERT INTO `sys_resource` VALUES ('238', '商城公告', '0', '', '1', '231', '0', 'article', '', '0', '0,231,', '2016-12-23 09:58:07', null, '28', null, '0', null);
INSERT INTO `sys_resource` VALUES ('239', '增加', '0', '', '1', '233', '1', 'blog:blog:add', '', '0', '0,231,233,', '2016-12-23 11:11:57', null, '28', null, '0', null);
INSERT INTO `sys_resource` VALUES ('240', '修改', '0', '', '1', '233', '1', 'blog:blog:edit', '', '0', '0,231,233,', '2016-12-23 11:12:12', null, '28', null, '0', null);
INSERT INTO `sys_resource` VALUES ('241', '删除', '0', '', '1', '233', '1', 'blog:blog:delete', '', '0', '0,231,233,', '2016-12-23 11:12:24', null, '28', null, '0', null);
INSERT INTO `sys_resource` VALUES ('242', '订单管理', '0', 'fa fa-calculator', '13', '0', '0', '', '', '0', '0,', '2016-12-23 13:34:21', null, '28', null, '0', null);
INSERT INTO `sys_resource` VALUES ('243', '订单列表', '0', '', '1', '242', '0', 'order', '', '0', '0,242,', '2016-12-23 13:34:45', null, '28', null, '0', null);
INSERT INTO `sys_resource` VALUES ('244', '村通管理', '0', 'fa fa-calculator', '1', '0', '0', '', '', '0', '0,', '2017-01-19 10:22:23', null, '2', null, '0', null);
INSERT INTO `sys_resource` VALUES ('245', '村庄管理', '0', '', '1', '244', '0', 'dvillage', '', '0', '0,244,', '2017-01-19 10:22:42', null, '2', null, '0', null);
INSERT INTO `sys_resource` VALUES ('246', '成员管理', '0', '', '2', '244', '0', 'dviname', '', '0', '0,244,', '2017-01-19 10:23:27', null, '2', null, '0', null);
INSERT INTO `sys_resource` VALUES ('248', '类别管理', '0', '', '3', '244', '0', 'dproducttype', '', '0', '0,244,', '2017-01-19 11:56:12', null, '2', null, '0', null);
INSERT INTO `sys_resource` VALUES ('249', '商品管理', '0', '', '1', '244', '0', 'dproduct', '', '0', '0,244,', '2017-01-19 11:56:38', null, '2', null, '0', null);
-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
`office_id` bigint(20) DEFAULT NULL COMMENT '归属机构',
`name` varchar(100) NOT NULL COMMENT '角色名称',
`data_scope` char(1) DEFAULT NULL COMMENT '数据范围',
`create_by` bigint(64) DEFAULT NULL COMMENT '创建者',
`create_date` datetime DEFAULT NULL COMMENT '创建时间',
`update_by` varchar(64) DEFAULT NULL COMMENT '更新者',
`update_date` datetime DEFAULT NULL COMMENT '更新时间',
`remarks` varchar(255) DEFAULT NULL COMMENT '备注信息',
`del_flag` char(1) NOT NULL DEFAULT '0' COMMENT '删除标记',
PRIMARY KEY (`id`),
KEY `sys_role_del_flag` (`del_flag`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8 COMMENT='角色表';
-- ----------------------------
-- Records of sys_role
-- ----------------------------
INSERT INTO `sys_role` VALUES ('19', '50', '客户', '8', '2', '2016-12-22 20:14:44', null, null, null, '0');
-- ----------------------------
-- Table structure for sys_role_office
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_office`;
CREATE TABLE `sys_role_office` (
`role_id` bigint(20) NOT NULL COMMENT '角色编号',
`office_id` bigint(20) NOT NULL COMMENT '机构编号',
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`create_by` varchar(64) DEFAULT NULL,
`create_date` datetime DEFAULT NULL,
`update_by` varchar(64) DEFAULT NULL,
`update_date` datetime DEFAULT NULL,
`del_flag` char(1) DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='角色-机构';
-- ----------------------------
-- Records of sys_role_office
-- ----------------------------
-- ----------------------------
-- Table structure for sys_role_resource
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_resource`;
CREATE TABLE `sys_role_resource` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`role_id` bigint(20) DEFAULT NULL,
`resource_id` bigint(20) DEFAULT NULL,
`create_by` varchar(64) DEFAULT NULL,
`create_date` datetime DEFAULT NULL,
`update_by` varchar(64) DEFAULT NULL,
`update_date` datetime DEFAULT NULL,
`del_flag` char(1) DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1499 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of sys_role_resource
-- ----------------------------
INSERT INTO `sys_role_resource` VALUES ('1479', '19', '188', null, null, null, null, '0');
INSERT INTO `sys_role_resource` VALUES ('1480', '19', '193', null, null, null, null, '0');
INSERT INTO `sys_role_resource` VALUES ('1481', '19', '195', null, null, null, null, '0');
INSERT INTO `sys_role_resource` VALUES ('1482', '19', '237', null, null, null, null, '0');
INSERT INTO `sys_role_resource` VALUES ('1483', '19', '226', null, null, null, null, '0');
INSERT INTO `sys_role_resource` VALUES ('1484', '19', '227', null, null, null, null, '0');
INSERT INTO `sys_role_resource` VALUES ('1485', '19', '230', null, null, null, null, '0');
INSERT INTO `sys_role_resource` VALUES ('1486', '19', '231', null, null, null, null, '0');
INSERT INTO `sys_role_resource` VALUES ('1487', '19', '233', null, null, null, null, '0');
INSERT INTO `sys_role_resource` VALUES ('1488', '19', '236', null, null, null, null, '0');
INSERT INTO `sys_role_resource` VALUES ('1489', '19', '238', null, null, null, null, '0');
INSERT INTO `sys_role_resource` VALUES ('1490', '19', '232', null, null, null, null, '0');
INSERT INTO `sys_role_resource` VALUES ('1491', '19', '234', null, null, null, null, '0');
INSERT INTO `sys_role_resource` VALUES ('1492', '19', '235', null, null, null, null, '0');
INSERT INTO `sys_role_resource` VALUES ('1493', '19', '204', null, null, null, null, '0');
INSERT INTO `sys_role_resource` VALUES ('1494', '19', '205', null, null, null, null, '0');
INSERT INTO `sys_role_resource` VALUES ('1495', '19', '206', null, null, null, null, '0');
INSERT INTO `sys_role_resource` VALUES ('1496', '19', '207', null, null, null, null, '0');
INSERT INTO `sys_role_resource` VALUES ('1497', '19', '208', null, null, null, null, '0');
INSERT INTO `sys_role_resource` VALUES ('1498', '19', '219', null, null, null, null, '0');
-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
`company_id` bigint(20) NOT NULL COMMENT '归属公司',
`office_id` bigint(20) NOT NULL COMMENT '归属部门',
`username` varchar(100) NOT NULL COMMENT '登录名',
`password` varchar(100) NOT NULL COMMENT '密码',
`no` varchar(100) DEFAULT NULL COMMENT '工号',
`name` varchar(100) DEFAULT NULL COMMENT '姓名',
`email` varchar(200) DEFAULT NULL COMMENT '邮箱',
`phone` varchar(200) DEFAULT NULL COMMENT '电话',
`mobile` varchar(200) DEFAULT NULL COMMENT '手机',
`user_type` char(1) DEFAULT '0' COMMENT '用户类型(0.普通 1.系统超级管理员)',
`login_ip` varchar(100) DEFAULT NULL COMMENT '最后登陆IP',
`login_date` datetime DEFAULT NULL COMMENT '最后登陆时间',
`create_by` bigint(64) DEFAULT NULL COMMENT '创建者',
`create_date` datetime DEFAULT NULL COMMENT '创建时间',
`update_by` varchar(64) DEFAULT NULL COMMENT '更新者',
`update_date` datetime DEFAULT NULL COMMENT '更新时间',
`remarks` varchar(255) DEFAULT NULL COMMENT '备注信息',
`del_flag` char(1) NOT NULL DEFAULT '0' COMMENT '删除标记',
`status` char(1) DEFAULT '0',
`license_code` varchar(255) DEFAULT NULL,
`yue` varchar(255) DEFAULT NULL COMMENT '余额',
`jifen` varchar(255) DEFAULT NULL COMMENT '积分',
`villageid` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `sys_user_office_id` (`office_id`),
KEY `sys_user_company_id` (`company_id`),
KEY `sys_user_update_date` (`update_date`),
KEY `sys_user_del_flag` (`del_flag`),
KEY `sys_user_login_name` (`username`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='用户表';
-- ----------------------------
-- Records of sys_user
-- ----------------------------
INSERT INTO `sys_user` VALUES ('2', '50', '50', 'admin', '86f3059b228c8acf99e69734b6bb32cc', '0002', '超级管理员', '@163.com', '13146587711', '951449465', '1', '0:0:0:0:0:0:0:1', '2017-04-19 14:14:10', '1', '2013-05-27 08:00:00', '2,超级管理员', '2017-04-12 10:12:32', '管理员', '0', '0', null, null, null, '2');
INSERT INTO `sys_user` VALUES ('3', '50', '50', 'zscat', '0658e089de04e6046ec4716a30a7c361', null, 'zscat', null, null, null, '0', null, null, null, '2016-12-28 18:03:12', null, null, null, '0', '0', null, null, null, null);
INSERT INTO `sys_user` VALUES ('4', '50', '50', 'shen', 'e6449d1935ae1119a02d6d1f83158587', null, 'shen', 'shen', null, null, '1', '127.0.0.1', '2017-01-19 15:55:08', null, '2017-01-07 18:10:44', null, null, null, '0', '0', null, '11', '22', '3');
INSERT INTO `sys_user` VALUES ('5', '50', '50', 'wap', 'f913f5fb6bbb5fe61c46a9954fc18ad9', null, 'wap', null, null, 'wap', '0', null, null, null, '2017-01-17 20:42:31', null, null, null, '0', '0', null, null, null, null);
-- ----------------------------
-- Table structure for sys_user_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_role`;
CREATE TABLE `sys_user_role` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`role_id` bigint(20) DEFAULT NULL,
`user_id` bigint(20) DEFAULT NULL,
`create_by` varchar(64) DEFAULT NULL,
`create_date` datetime DEFAULT NULL,
`update_by` varchar(64) DEFAULT NULL,
`update_date` datetime DEFAULT NULL,
`del_flag` char(1) DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=82 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of sys_user_role
-- ----------------------------
INSERT INTO `sys_user_role` VALUES ('76', '19', '27', null, null, null, null, '0');
INSERT INTO `sys_user_role` VALUES ('77', '19', '28', null, null, null, null, '0');
INSERT INTO `sys_user_role` VALUES ('79', '19', '29', null, null, null, null, '0');
INSERT INTO `sys_user_role` VALUES ('80', '19', '4', null, null, null, null, '0');
INSERT INTO `sys_user_role` VALUES ('81', '19', '5', null, null, null, null, '0');
此处可能存在不合适展示的内容,页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容,可点击提交进行申诉,我们将尽快为您处理。