代码拉取完成,页面将自动刷新
同步操作将从 sea/zb 强制同步,此操作会覆盖自 Fork 仓库以来所做的任何修改,且无法恢复!!!
确定后同步将在后台操作,完成时将刷新页面,请耐心等待。
/*
SQLyog 企业版 - MySQL GUI v8.14
MySQL - 5.7.17-log : Database - zb_server
*********************************************************************
*/
/*!40101 SET NAMES utf8 */;
/*!40101 SET SQL_MODE=''*/;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`zb_server` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `zb_server`;
/*Table structure for table `basic_config` */
DROP TABLE IF EXISTS `basic_config`;
CREATE TABLE `basic_config` (
`id` bigint(11) NOT NULL AUTO_INCREMENT,
`config_name` varchar(50) NOT NULL COMMENT '标识项目是否处于管理员调试、修改状态,用户登录之后会有相应的弹窗提醒',
`config_value` varchar(50) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='全局性配置';
/*Data for the table `basic_config` */
insert into `basic_config`(`id`,`config_name`,`config_value`) values (1,'project_debugging_tip','0');
/*Table structure for table `basic_source_download` */
DROP TABLE IF EXISTS `basic_source_download`;
CREATE TABLE `basic_source_download` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`name` varchar(100) NOT NULL COMMENT '资源名称',
`down_url` varchar(150) NOT NULL COMMENT '下载地址',
`icon_name` varchar(50) NOT NULL DEFAULT 'icon-download-alt' COMMENT '图标',
`sort_num` int(11) NOT NULL DEFAULT '0' COMMENT '排序',
`create_time` datetime NOT NULL,
`update_time` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=utf8;
/*Data for the table `basic_source_download` */
insert into `basic_source_download`(`id`,`name`,`down_url`,`icon_name`,`sort_num`,`create_time`,`update_time`) values (1,'ActiveMQ消息监听处理入门Demo(Spring简单集成).zip','http://pan.baidu.com/s/1hrH9DnY','icon-download-alt',0,'2016-11-03 15:17:37','2016-11-03 15:17:39'),(2,'apache tomcat集群环境搭建图文教程.zip','http://pan.baidu.com/s/1o7DtCsq','icon-download-alt',0,'2016-11-03 15:18:34','2016-11-03 15:18:36'),(3,'chatpush-在线聊天室(可选指定用户聊天).zip','http://pan.baidu.com/s/1eR521IM','icon-download-alt',0,'2016-11-03 15:19:33','2016-11-03 15:19:35'),(4,'crm后台系统源码(bootstrap).zip','http://pan.baidu.com/s/1i4TcT29','icon-download-alt',0,'2016-11-03 15:19:56','2016-11-03 15:19:57'),(5,'DateTimePicker_JQuery日期和时间插件.zip','http://pan.baidu.com/s/1o8eyaF4','icon-download-alt',0,'2016-11-03 15:20:20','2016-11-03 15:20:22'),(6,'dwrcomet-推送消息给指定用户Demo.zip','http://pan.baidu.com/s/1kVAslEn','icon-download-alt',0,'2016-11-03 15:20:42','2016-11-03 15:20:44'),(7,'DwrPush-模拟消息推送至所有当前在线的用户.zip','http://pan.baidu.com/s/1i5BclKh','icon-download-alt',0,'2016-11-03 15:21:03','2016-11-03 15:21:05'),(8,'dwz富客户端 springmvc ibatis简单Demo.zip','http://pan.baidu.com/s/1boRTofX','icon-download-alt',0,'2016-11-03 15:21:24','2016-11-03 15:21:26'),(9,'easyui完整Demo-各种功能_布局.zip','http://pan.baidu.com/s/1nvJb8G5','icon-download-alt',0,'2016-11-03 15:21:52','2016-11-03 15:21:54'),(10,'erp项目源码--bootstrap 选项卡切换.zip','http://pan.baidu.com/s/1boLhDLl','icon-download-alt',0,'2016-11-03 15:22:13','2016-11-03 15:22:15'),(11,'Highcharts简单实例Demo.zip','http://pan.baidu.com/s/1dFt91nF','icon-download-alt',0,'2016-11-03 15:22:37','2016-11-03 15:22:38'),(12,'HTML5 CSS3鼠标悬停图片特效.zip','http://pan.baidu.com/s/1eSLXIee','icon-download-alt',0,'2016-11-03 15:23:01','2016-11-03 15:23:03'),(13,'Java web项目:mybatis、springmvc、seajs、freemarker、分布式session、自定义taglib等.zip','http://pan.baidu.com/s/1qYzsFxU','icon-download-alt',0,'2016-11-03 15:23:21','2016-11-03 15:23:23'),(14,'Java后台系统-不同框架优点集成-bootstrap布局-权限角色管理(含sql)----1.0.0版本.zip','http://pan.baidu.com/s/1i4GlFql','icon-download-alt',0,'2016-11-03 15:23:43','2016-11-03 15:23:44'),(15,'java线程异步:异步发送email、回调接口定义、其他异步线程demo.zip','http://pan.baidu.com/s/1jIbOunO','icon-download-alt',0,'2016-11-03 15:24:06','2016-11-03 15:24:08'),(16,'JAVA之23种设计模式的完整实例代码.zip','http://pan.baidu.com/s/1o8NJsL0','icon-download-alt',0,'2016-11-03 15:24:28','2016-11-03 15:24:29'),(17,'jd-gui反编译jar_复制源码为java文件(自己写的工具).rar','http://pan.baidu.com/s/1dE8mrap','icon-download-alt',0,'2016-11-03 15:24:47','2016-11-03 15:24:50'),(18,'jquery点击图片选中特效.rar','http://pan.baidu.com/s/1jIJNEq6','icon-download-alt',0,'2016-11-03 15:25:12','2016-11-03 15:25:13'),(19,'jQuery轻量级圆形进度指示器插件.zip','http://pan.baidu.com/s/1o8Lbz4m','icon-download-alt',0,'2016-11-03 15:27:51','2016-11-03 15:27:53'),(20,'lucene基于本地磁盘的文件索引Demo.zip','http://pan.baidu.com/s/1jI8suqy','icon-download-alt',0,'2016-11-03 15:28:11','2016-11-03 15:28:13'),(21,'lucene基于内存的检索Demo.zip','http://pan.baidu.com/s/1qXEB2DA','icon-download-alt',0,'2016-11-03 15:28:31','2016-11-03 15:28:32'),(22,'lucene索引——增删改查.zip','http://pan.baidu.com/s/1bo2kKCf','icon-download-alt',0,'2016-11-03 15:28:49','2016-11-03 15:28:50'),(23,'MongoDB环境搭建与实例代码测试.rar','http://pan.baidu.com/s/1o7OiXMM','icon-download-alt',0,'2016-11-03 15:29:09','2016-11-03 15:29:10'),(24,'orm框架 微信框架 自定义拦截器 自定义注解 数据源切换等.zip','http://pan.baidu.com/s/1jHMVoiU','icon-download-alt',0,'2016-11-03 15:29:29','2016-11-03 15:29:31'),(25,'pdf文件打印(freemarker作为pdf模板,通过参数替换、遍历显示效果)(java版 spring).zip','http://pan.baidu.com/s/1kUWw8Vd','icon-download-alt',0,'2016-11-03 15:29:47','2016-11-03 15:29:49'),(26,'pluplaod文件分割上传Demo.zip','http://pan.baidu.com/s/1kV8Wpy3','icon-download-alt',0,'2016-11-03 15:30:05','2016-11-03 15:30:07'),(27,'SpringActiveMQ消息发送与接收(WEB版)-入门实例.zip','http://pan.baidu.com/s/1hsqL6vE','icon-download-alt',0,'2016-11-03 15:30:24','2016-11-03 15:30:26'),(28,'springbatch批处理(完整Demo).zip','http://pan.baidu.com/s/1hsgCgVq','icon-download-alt',0,'2016-11-03 15:30:47','2016-11-03 15:30:49'),(29,'springmvc mybatis集成—干净框架(直接使用).zip','http://pan.baidu.com/s/1i4XgFjR','icon-download-alt',0,'2016-11-03 15:31:09','2016-11-03 15:31:10'),(30,'springsecurity权限控制Demo.zip','http://pan.baidu.com/s/1i4MXsnr','icon-download-alt',0,'2016-11-03 15:31:30','2016-11-03 15:31:31'),(31,'spring_activemq消息发送接收(最终版-非WEB访问).zip','http://pan.baidu.com/s/1jIDcfII','icon-download-alt',0,'2016-11-03 15:31:47','2016-11-03 15:31:49'),(32,'spring_security3_详细配置(摘自网络).zip','http://pan.baidu.com/s/1kUAbWjl','icon-download-alt',0,'2016-11-03 15:32:09','2016-11-03 15:32:10'),(33,'SSO之CAS单点登录详细图文教程.zip','http://pan.baidu.com/s/1hrY4BBm','icon-download-alt',0,'2016-11-03 15:32:29','2016-11-03 15:32:30'),(34,'WebSocket消息聊天室Demo.zip','http://pan.baidu.com/s/1jI7CzAY','icon-download-alt',0,'2016-11-03 15:32:51','2016-11-03 15:32:52'),(35,'读取Excel工具类(包含流读取、文件读取).zip','http://pan.baidu.com/s/1skE92ET','icon-download-alt',0,'2016-11-03 15:33:09','2016-11-03 15:33:11'),(36,'断点 多线程下载实例.zip','http://pan.baidu.com/s/1miuHeIG','icon-download-alt',0,'2016-11-03 15:33:31','2016-11-03 15:33:32'),(37,'基于dwr消息推送Demo.zip','http://pan.baidu.com/s/1boRTogJ','icon-download-alt',0,'2016-11-03 15:33:47','2016-11-03 15:33:48'),(38,'手机_日期时间控件.zip','http://pan.baidu.com/s/1hs7G2HY','icon-download-alt',0,'2016-11-03 15:34:05','2016-11-03 15:34:07'),(39,'手机时间控件.zip','http://pan.baidu.com/s/1qXYou7M','icon-download-alt',0,'2016-11-03 15:34:25','2016-11-03 15:34:27'),(40,'数据采集—基于百度文库的抓取Demo.zip','http://pan.baidu.com/s/1cpBMeM','icon-download-alt',0,'2016-11-03 15:34:46','2016-11-03 15:34:47'),(41,'网页加载进度条-实例Demo.zip','http://pan.baidu.com/s/1pLViL9x','icon-download-alt',0,'2016-11-03 15:35:07','2016-11-03 15:35:08'),(42,'微信JSAPI支付完整Demo.zip','http://pan.baidu.com/s/1nvdehnj','icon-download-alt',0,'2016-11-03 15:35:29','2016-11-03 15:35:30'),(43,'微信JSAPI支付完整Demo第二版(新增关闭订单、查询订单、查询退款、下载对账单、申请退款).zip','http://pan.baidu.com/s/1i4VKKNN','icon-download-alt',0,'2016-11-03 15:35:47','2016-11-03 15:35:48'),(44,'异步发送email之demo.zip','http://pan.baidu.com/s/1o7IJv1S','icon-download-alt',0,'2016-11-03 15:36:05','2016-11-03 15:36:07'),(45,'银联PC网关支付demo(退款、对账文件、查询、撤销).zip','http://pan.baidu.com/s/1pKXAz0Z','icon-download-alt',0,'2016-11-03 15:36:25','2016-11-03 15:36:27'),(46,'支付宝PC及时到账支付Demo-JAVA.zip','http://pan.baidu.com/s/1pLyEKsz','icon-download-alt',0,'2016-11-03 15:36:44','2016-11-03 15:36:46'),(47,'支付宝PC支付完整Demo.zip','http://pan.baidu.com/s/1kUAbWjH','icon-download-alt',0,'2016-11-03 15:37:03','2016-11-03 15:37:05');
/*Table structure for table `leave_apply` */
DROP TABLE IF EXISTS `leave_apply`;
CREATE TABLE `leave_apply` (
`id` bigint(11) NOT NULL AUTO_INCREMENT,
`process_instance_id` varchar(50) DEFAULT NULL COMMENT '流程实例id',
`type` int(1) NOT NULL COMMENT '请假类型',
`reason` varchar(100) NOT NULL COMMENT '请假事由',
`user_id` bigint(11) NOT NULL COMMENT '申请人id',
`start_date` datetime NOT NULL COMMENT '申请日期',
`end_date` datetime NOT NULL COMMENT '结束日期',
`create_time` datetime NOT NULL COMMENT '创建时间',
`update_time` datetime NOT NULL COMMENT '更新时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='OA请假申请表';
/*Data for the table `leave_apply` */
/*Table structure for table `order_info` */
DROP TABLE IF EXISTS `order_info`;
CREATE TABLE `order_info` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`order_no` varchar(50) NOT NULL,
`total_fee` bigint(11) NOT NULL,
`good_name` varchar(50) NOT NULL,
`order_source` tinyint(4) NOT NULL DEFAULT '0',
`create_time` datetime NOT NULL,
`update_time` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
/*Data for the table `order_info` */
insert into `order_info`(`id`,`order_no`,`total_fee`,`good_name`,`order_source`,`create_time`,`update_time`) values (1,'8888888888',5000,'3哈哈哈',1,'2017-10-27 08:27:24','2017-10-27 08:27:24'),(2,'poipi66666666666',5000,'3哈哈哈',2,'2017-10-27 08:28:13','2017-10-27 08:28:13'),(3,'777777777',5000,'6666688888',2,'2017-10-27 09:05:30','2017-10-27 09:05:30'),(4,'99999999999',5000,'99999999999',0,'2017-10-27 09:06:58','2017-10-27 09:06:58'),(5,'123',5000,'123323',3,'2017-10-27 09:15:17','2017-10-27 09:15:17'),(6,'123',5000,'123323',1,'2017-10-27 09:17:38','2017-10-27 09:17:38'),(7,'uuu9999',5000,'iii',0,'2017-12-04 11:32:02','2017-12-04 11:32:02'),(8,'uuu9999',5000,'iii',0,'2017-12-04 11:32:03','2017-12-04 11:32:03');
/*Table structure for table `sys_app` */
DROP TABLE IF EXISTS `sys_app`;
CREATE TABLE `sys_app` (
`id` bigint(11) NOT NULL AUTO_INCREMENT,
`name` varchar(128) NOT NULL COMMENT '名称',
`sort` int(11) NOT NULL COMMENT '排序',
`update_time` datetime NOT NULL COMMENT '更新时间',
`create_time` datetime NOT NULL COMMENT '创建时间',
`status` tinyint(1) NOT NULL COMMENT '是否启用',
`code` varchar(50) NOT NULL COMMENT '编码',
`icon` varchar(30) NOT NULL COMMENT '图标',
`online` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否上线,0:未上线,1:已上线',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=108 DEFAULT CHARSET=utf8 COMMENT='应用表';
/*Data for the table `sys_app` */
insert into `sys_app`(`id`,`name`,`sort`,`update_time`,`create_time`,`status`,`code`,`icon`,`online`) values (4,'BOSS系统管理中心',1,'2017-12-07 00:07:42','2017-12-07 00:07:42',0,'zb-center-web-boss','',1),(105,'应用监控系统',2,'2017-12-07 00:40:52','2017-12-07 00:40:52',0,'zb-center-web-monitor','',0),(106,'定时任务管理系统',3,'2017-12-22 01:39:53','2017-12-07 00:41:24',0,'zb-center-web-task','',0),(107,'订单管理系统',4,'2017-12-22 01:21:21','2017-12-07 00:42:03',1,'zb-center-web-order','',0);
/*Table structure for table `sys_menu` */
DROP TABLE IF EXISTS `sys_menu`;
CREATE TABLE `sys_menu` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL,
`url` varchar(255) DEFAULT NULL,
`parent_id` bigint(20) DEFAULT NULL,
`sort` varchar(100) DEFAULT NULL,
`icon` varchar(30) DEFAULT NULL,
`type` varchar(10) DEFAULT NULL,
`permission_code` varchar(50) NOT NULL COMMENT '所需权限',
`status` tinyint(1) NOT NULL DEFAULT '0',
`app_id` bigint(20) NOT NULL COMMENT '菜单所属应用id',
`create_time` datetime NOT NULL,
`update_time` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=utf8;
/*Data for the table `sys_menu` */
insert into `sys_menu`(`id`,`name`,`url`,`parent_id`,`sort`,`icon`,`type`,`permission_code`,`status`,`app_id`,`create_time`,`update_time`) values (1,'系统管理','#',0,'1','fa fa-cogs','0','sys:mgt',0,4,'2017-12-02 03:00:00','2017-12-02 03:00:00'),(2,'用户管理','/user/toUserListView',1,'2','','1','user:mgt',0,4,'2017-12-02 03:00:00','2017-12-02 03:00:00'),(4,'角色管理','/role/toRoleListView',1,'4',NULL,'1','role:mgt',0,4,'2017-12-02 03:00:00','2017-12-02 03:00:00'),(5,'权限管理','/permission/toListView',1,'3',NULL,'1','permission:mgt',0,4,'2017-12-02 03:00:00','2017-12-02 03:00:00'),(6,'微信开发','#',0,'1','fa fa-wechat','0','wechat:mgt',1,4,'2017-12-02 03:00:00','2017-12-02 03:00:00'),(7,'模板消息','/wechat/template/toTemplateMsgView',6,'2','','1','template:msg:send',1,4,'2017-12-02 03:00:00','2017-12-02 03:00:00'),(9,'实时监控','#',0,'1','fa fa-bar-chart-o','0','monitor:mgt',1,4,'2017-12-02 03:00:00','2017-12-02 03:00:00'),(10,'tomcat日志实时监控','/socket/tomcatlog',9,'2',NULL,'1','monitor:tomcat:log',1,4,'2017-12-02 03:00:00','2017-12-02 03:00:00'),(11,'消息推送','#',0,'1','fa fa-send-o','0','socket:push:mgt',1,4,'2017-12-02 03:00:00','2017-12-02 03:00:00'),(12,'在线聊天','#',0,'1','fa fa-commenting-o','0','chat:mgt',1,4,'2017-12-02 03:00:00','2017-12-02 03:00:00'),(13,'netty实现在线聊天','/chat/toChatView',12,'2',NULL,'1','chat:netty:service',1,4,'2017-12-02 03:00:00','2017-12-02 03:00:00'),(14,'activiti工作流','#',0,'1','fa fa-sliders','0','activiti:mgt',1,4,'2017-12-02 03:00:00','2017-12-02 03:00:00'),(15,'OA请假申请','/oa/toOaApplyView',14,'3',NULL,'1','activiti:oa:apply',1,4,'2017-12-02 03:00:00','2017-12-02 03:00:00'),(16,'已部署工作流程','/activiti/toProcessListView',14,'2',NULL,'1','activiti:process:list',1,4,'2017-12-02 03:00:00','2017-12-02 03:00:00'),(17,'我发起的请假流程','/oa/toMyLeaveApplyView',14,'4',NULL,'1','activiti:myprocess:leaveapply',1,4,'2017-12-02 03:00:00','2017-12-02 03:00:00'),(18,'部门领导审批','/oa/toDeptleaderAuditView',14,'5',NULL,'1','activiti:deptleader:audit',1,4,'2017-12-02 03:00:00','2017-12-02 03:00:00'),(19,'请假调整申请','/oa/toMyLeaveApplyTurndownView',14,'6',NULL,'1','activiti:myleaveapply:modify',1,4,'2017-12-02 03:00:00','2017-12-02 03:00:00'),(20,'我的请假历史','/oa/toMyLeaveApplyHistoryView',14,'7',NULL,'1','activiti:myleaveapplyed:history',1,4,'2017-12-02 03:00:00','2017-12-02 03:00:00'),(21,'人事审批','/oa/toHrAuditView',14,'8',NULL,'1','activiti:hr:audit',1,4,'2017-12-02 03:00:00','2017-12-02 03:00:00'),(22,'推送消息给当前用户','/socket/userpush',11,'2',NULL,'1','socket:user:msgpush',1,4,'2017-12-02 03:00:00','2017-12-02 03:00:00'),(23,'推送消息给所有用户','/socket/userpush/all',11,'3',NULL,'1','socket:alluser:msgpush',1,4,'2017-12-02 03:00:00','2017-12-02 03:00:00'),(24,'应用管理','/app/toAppListView',1,'1',NULL,'1','app:mgt',0,4,'2017-12-02 03:00:00','2017-12-02 03:00:00'),(25,'菜单管理','/menu/toMenuListView',1,'5','','1','menu:mgt',0,4,'2017-12-02 03:00:00','2017-12-02 03:00:00'),(26,'菜单测试2369','#',0,'12369','fa fa-stop','0','menu:test2369',1,4,'2017-12-03 03:22:54','2017-12-03 03:22:56'),(27,'测试的555','#',0,'666','kkk','0','xxx',1,4,'2017-12-03 06:50:37','2017-12-03 06:50:37'),(28,'xx','#',0,'4','xcx','0','xx',1,4,'2017-12-03 06:53:38','2017-12-03 06:53:38'),(29,'5','#',0,'5','fa fa-key','0','5',1,4,'2017-12-03 06:59:06','2017-12-03 06:59:06'),(30,'56','#',0,'56','56','0','56',1,4,'2017-12-03 06:59:12','2017-12-03 06:59:12'),(31,'7','7',29,'7','','1','7',1,4,'2017-12-03 06:59:26','2017-12-03 06:59:26'),(32,'79','79',30,'9','','1','79',1,4,'2017-12-03 06:59:38','2017-12-03 06:59:38'),(33,'79','79',30,'9','','1','79',1,4,'2017-12-03 06:59:39','2017-12-03 06:59:39'),(34,'8','8',30,'8','','1','8',1,4,'2017-12-03 07:00:15','2017-12-03 07:00:15'),(35,'8','#',31,'8','','1','8',1,4,'2017-12-03 07:00:22','2017-12-03 07:00:22'),(36,'文件打印','#',0,'3','fa fa-print','0','file:print:mgt',0,4,'2017-12-20 18:07:23','2017-12-20 18:07:23'),(37,'PDF文件打印','/pdf/print/view',36,'1','','1','pdf:file:print',0,4,'2017-12-20 18:09:46','2017-12-20 18:09:46'),(38,'定时任务','#',0,'2','fa fa-clock-o','0','task:mgt',0,4,'2017-12-20 23:40:30','2017-12-20 23:40:30'),(39,'代码生成器','#',0,'4','fa fa-code','0','code:generator:mgt',0,4,'2017-12-22 19:52:32','2017-12-22 19:52:32'),(40,'数据库表反向生成','/generator/table/view',39,'1','','1','code:table:generator',0,4,'2017-12-22 19:57:49','2017-12-22 19:57:49'),(41,'定时任务列表','/task/view/list',38,'1','','1','task:list',0,4,'2017-12-22 20:02:04','2017-12-22 20:02:04'),(42,'分布式任务调度平台','/task/platform/view',38,'2','','1','task:platform:view',0,4,'2017-12-25 15:13:26','2017-12-25 15:13:26'),(43,'在线资源管理器','#',0,'5','fa fa-cubes','0','source:web:view',0,4,'2018-01-03 23:40:08','2018-01-03 23:40:08'),(44,'finder-web','finder',43,'1','','1','finder:web:view',0,4,'2018-01-03 23:41:09','2018-01-03 23:41:09'),(45,'在线聊天','#',0,'6','fa fa-comments','0','online:chat:mgt',0,4,'2018-01-08 19:10:07','2018-01-08 19:10:07'),(46,'netty实现在线聊天','/chat/netty/view',45,'1','','1','online:chat:netty:view',0,4,'2018-01-08 19:11:46','2018-01-08 19:11:46'),(47,'之前的','/chat/netty/view2',45,'2','','1','online:chat:netty:view',0,4,'2018-01-09 00:18:50','2018-01-09 00:18:50');
/*Table structure for table `sys_permission` */
DROP TABLE IF EXISTS `sys_permission`;
CREATE TABLE `sys_permission` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`name` varchar(20) NOT NULL COMMENT '权限名称',
`code` varchar(50) NOT NULL COMMENT '权限代码',
`description` varchar(50) DEFAULT NULL COMMENT '描述',
`parent_id` bigint(20) DEFAULT NULL COMMENT '父id',
`status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '状态,0:可用,1:不可用',
`app_id` bigint(20) NOT NULL COMMENT '所属应用id',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=97 DEFAULT CHARSET=utf8 COMMENT='权限表';
/*Data for the table `sys_permission` */
insert into `sys_permission`(`id`,`name`,`code`,`description`,`parent_id`,`status`,`app_id`) values (1,'系统管理','sys:mgt','对系统模块的管理',0,0,4),(2,'人员管理','user:mgt','对人员进行管理',1,0,4),(3,'角色管理','role:mgt','对角色进行管理',1,0,4),(4,'权限管理','permission:mgt','对权限进行管理',1,0,4),(9,'查看用户列表','user:list','可以查看用户列表',2,0,4),(10,'编辑用户信息','user:edit','是否能进入编辑用户信息页面',9,0,4),(11,'删除用户','user:delete','可以删除用户',9,0,4),(12,'查看角色列表','role:list','可以查看角色列表',3,0,4),(13,'查看权限列表','permission:list',NULL,4,0,4),(14,'新增角色','role:add','新增角色信息',12,0,4),(15,'更新角色','role:update','是否可以提交更新',12,0,4),(16,'删除角色','role:delete','可以删除角色',12,0,4),(17,'新增权限','permission:add','可以添加新权限',13,0,4),(18,'编辑权限','permission:edit','是否能进入权限编辑页面',13,0,4),(19,'删除权限','permission:delete','可以删除权限数据',13,0,4),(20,'添加用户','user:add','可以添加新的用户',9,0,4),(21,'微信开发','wechat:mgt','微信相关功能开发演示',0,0,4),(22,'微信模板消息','template:msg:send','测试发送微信模板消息',21,0,4),(23,'监控管理','monitor:mgt','监控管理',0,0,4),(24,'tomcat日志监控','monitor:tomcat:log','可以查看服务器上tomcat的实时打印日志',23,0,4),(25,'服务器消息推送','socket:push:mgt','服务器消息推送',0,0,4),(26,'在线聊天','chat:mgt','在线聊天',0,0,4),(27,'netty实现在线聊天','chat:netty:service','netty实现在线聊天',26,0,4),(28,'activiti工作流','activiti:mgt','activiti工作流相关技术',0,0,4),(29,'OA请假流程','activiti:oa:apply','基于工作流实现OA请假',28,0,4),(30,'已部署的工作流','activiti:process:list','已部署的工作流',28,0,4),(31,'我发起的请假流程','activiti:myprocess:leaveapply','我发起的请假流程',28,0,4),(32,'部门领导审批','activiti:deptleader:audit','部门领导审批',28,0,4),(33,'请假调整申请','activiti:myleaveapply:modify','重新修改被驳回的请假申请',28,0,4),(34,'我的请假历史','activiti:myleaveapplyed:history','我的请假历史',28,0,4),(35,'人事审批请假申请','activiti:hr:audit','人事审批请假申请',28,0,4),(39,'推送消息给自己','socket:user:msgpush','推送消息给自己',25,0,4),(40,'推送消息给所有人','socket:alluser:msgpush','推送消息给所有人',25,0,4),(43,'应用管理','app:mgt','应用管理',1,0,4),(44,'查看应用列表','app:list','查看应用列表',43,0,4),(45,'应用编辑','app:edit','是否能进入应用编辑页面',44,0,4),(46,'删除应用','app:delete','删除应用',44,0,4),(47,'添加应用','app:add','添加应用',44,0,4),(48,'为用户分配应用','user:assign:app','为用户分配应用',9,0,4),(49,'为用户分配角色','user:assign:role','为用户分配角色',9,0,4),(50,'菜单管理','menu:mgt','菜单管理',1,0,4),(53,'测试034','测试034','测试03',57,0,85),(55,'888','888','888',53,0,85),(56,'5','5','5',55,0,85),(57,'678','678','678',0,1,85),(58,'890','890','890',0,0,85),(59,'777','777','777',58,1,85),(61,'6','6','6',0,0,87),(62,'65','65','65',61,1,87),(63,'656','656','656',0,1,85),(64,'什么鬼','什么鬼','什么鬼',62,1,87),(70,'查看菜单列表','menu:list','查看菜单列表',50,0,4),(73,'OA请假审批员','oa:qingjia:shenpi','OA请假审批员',0,0,89),(74,'公众号运营员','wechat:yunying:person','公众号运营员',0,0,86),(75,'新增菜单','menu:add','可以添加新菜单',50,0,4),(76,'删除菜单','menu:delete','可以删除菜单',50,0,4),(77,'编辑菜单','menu:edit','是否能进入菜单编辑页面',50,0,4),(78,'删除已经部署的工作流','activiti:process:delete','删除已经部署的工作流',30,0,4),(79,'上传流程文件','activiti:process:upload','上传流程文件',30,0,4),(80,'查看流程文件内容','activiti:process:detail','查看流程文件内容',30,0,4),(81,'编辑角色','role:edit','是否能进入编辑页面',12,0,4),(82,'更新菜单','menu:update','提交更新菜单信息',50,0,4),(83,'更新用户信息','user:update','更新用户信息',9,0,4),(84,'更新权限','permission:update','是否可以提交更新',13,0,4),(85,'更新应用信息','app:update','是否可以提交更新',44,0,4),(86,'文件打印管理','file:print:mgt','文件打印管理',0,0,4),(87,'pdf文件打印','pdf:file:print','pdf文件打印',86,0,4),(88,'定时任务','task:mgt','定时任务',0,0,4),(89,'代码生成器','code:generator:mgt','代码生成器管理',0,0,4),(90,'代码生成页面','code:table:generator','进入基于Table表反向生成的页面',89,0,4),(91,'定时任务列表','task:list','查看定时任务列表',88,0,4),(92,'分布式任务调度平台','task:platform:view','进入分布式任务调度平台系统',88,0,4),(93,'资源管理器','source:web:view','在线版的资源管理器',0,0,4),(94,'finder-web','finder:web:view','web版在线资源管理器-finder-web',93,0,4),(95,'在线聊天','online:chat:mgt','在线聊天',0,0,4),(96,'netty实现在线聊天','online:chat:netty:view','进入在线聊天的页面',95,0,4);
/*Table structure for table `sys_re_user_app` */
DROP TABLE IF EXISTS `sys_re_user_app`;
CREATE TABLE `sys_re_user_app` (
`id` bigint(11) NOT NULL AUTO_INCREMENT,
`user_id` bigint(11) NOT NULL COMMENT '用户id',
`app_id` bigint(11) NOT NULL COMMENT '应用id',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=165 DEFAULT CHARSET=utf8;
/*Data for the table `sys_re_user_app` */
insert into `sys_re_user_app`(`id`,`user_id`,`app_id`) values (3,41,1),(100,47,4),(119,1,4),(127,39,86),(133,34,89),(136,36,4),(137,38,4),(138,40,4),(139,43,4),(140,48,4),(144,49,4),(145,50,4),(146,51,4),(147,52,4),(148,53,4),(149,54,4),(150,55,4),(151,56,4),(152,57,4),(153,58,4),(154,59,4),(155,60,4),(156,61,4),(157,62,4),(158,63,4),(159,64,4),(160,65,4),(161,66,4),(162,67,4),(163,68,4),(164,69,4);
/*Table structure for table `sys_role` */
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role` (
`id` bigint(11) NOT NULL AUTO_INCREMENT,
`app_id` bigint(11) NOT NULL,
`name` varchar(20) NOT NULL,
`description` varchar(50) DEFAULT NULL COMMENT '描述',
`status` tinyint(4) NOT NULL DEFAULT '0',
`update_time` datetime NOT NULL,
`create_time` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 COMMENT='角色表';
/*Data for the table `sys_role` */
insert into `sys_role`(`id`,`app_id`,`name`,`description`,`status`,`update_time`,`create_time`) values (1,4,'超级管理员','最高级别权限管理员',0,'2016-08-01 15:17:52','2016-08-01 15:17:53'),(2,4,'员工','基层员工',0,'2016-08-01 15:18:21','2016-08-01 15:18:23'),(3,4,'财务','财务部角色',0,'2016-08-03 13:21:56','2016-08-03 13:21:58'),(4,4,'人事','人事',0,'2017-03-21 13:19:34','2017-03-21 13:19:34'),(6,4,'出纳员','出纳员',0,'2017-03-21 13:22:06','2017-03-21 13:22:06'),(7,4,'采购经理','采购经理',0,'2017-03-21 13:22:23','2017-03-21 13:22:23'),(8,4,'总经理','总经理',0,'2017-03-21 13:23:03','2017-03-21 13:23:03'),(15,4,'OA审批员','OA审批员',0,'2017-12-03 16:23:11','2017-12-03 16:23:11'),(16,4,'公众号运营员','公众号运营员',0,'2017-12-03 16:25:33','2017-12-03 16:25:33');
/*Table structure for table `sys_role_permission` */
DROP TABLE IF EXISTS `sys_role_permission`;
CREATE TABLE `sys_role_permission` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`role_id` bigint(20) NOT NULL,
`permission_id` bigint(20) NOT NULL,
`app_id` bigint(20) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3712 DEFAULT CHARSET=utf8 COMMENT='角色权限表';
/*Data for the table `sys_role_permission` */
insert into `sys_role_permission`(`id`,`role_id`,`permission_id`,`app_id`) values (2667,6,1,4),(2668,6,2,4),(2669,6,9,4),(2670,6,21,4),(2671,6,22,4),(2672,6,23,4),(2673,6,24,4),(2674,6,25,4),(2675,6,39,4),(2676,6,40,4),(2677,6,26,4),(2678,6,27,4),(3238,7,1,4),(3239,7,2,4),(3240,7,9,4),(3241,7,10,4),(3242,7,43,4),(3243,7,44,4),(3244,7,45,4),(3274,15,1,4),(3275,15,2,4),(3276,15,9,4),(3277,3,1,4),(3278,3,2,4),(3279,3,9,4),(3280,3,10,4),(3281,2,1,4),(3282,2,2,4),(3283,2,9,4),(3284,2,10,4),(3285,2,21,4),(3286,2,22,4),(3287,2,23,4),(3288,2,24,4),(3289,2,25,4),(3290,2,39,4),(3291,2,40,4),(3292,2,26,4),(3293,2,27,4),(3294,2,28,4),(3295,2,29,4),(3296,2,30,4),(3297,2,78,4),(3298,2,79,4),(3299,2,80,4),(3300,2,31,4),(3301,2,32,4),(3302,2,33,4),(3303,2,34,4),(3304,2,35,4),(3329,16,1,4),(3330,16,2,4),(3331,16,9,4),(3478,8,1,4),(3479,8,2,4),(3480,8,9,4),(3481,8,10,4),(3482,8,21,4),(3483,8,22,4),(3484,8,23,4),(3485,8,24,4),(3486,8,25,4),(3487,8,39,4),(3488,8,40,4),(3489,8,26,4),(3490,8,27,4),(3491,8,28,4),(3492,8,29,4),(3493,8,30,4),(3494,8,31,4),(3495,8,32,4),(3496,8,33,4),(3497,8,34,4),(3498,8,35,4),(3499,4,1,4),(3500,4,2,4),(3501,4,9,4),(3502,4,10,4),(3503,4,83,4),(3504,4,28,4),(3505,4,30,4),(3506,4,35,4),(3674,1,1,4),(3675,1,2,4),(3676,1,9,4),(3677,1,10,4),(3678,1,20,4),(3679,1,48,4),(3680,1,49,4),(3681,1,3,4),(3682,1,12,4),(3683,1,14,4),(3684,1,15,4),(3685,1,81,4),(3686,1,4,4),(3687,1,13,4),(3688,1,17,4),(3689,1,18,4),(3690,1,84,4),(3691,1,43,4),(3692,1,44,4),(3693,1,45,4),(3694,1,47,4),(3695,1,85,4),(3696,1,50,4),(3697,1,70,4),(3698,1,75,4),(3699,1,77,4),(3700,1,82,4),(3701,1,86,4),(3702,1,87,4),(3703,1,88,4),(3704,1,91,4),(3705,1,92,4),(3706,1,89,4),(3707,1,90,4),(3708,1,93,4),(3709,1,94,4),(3710,1,95,4),(3711,1,96,4);
/*Table structure for table `sys_user` */
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
`id` bigint(11) NOT NULL AUTO_INCREMENT,
`user_name` varchar(20) DEFAULT NULL COMMENT '登录用户名',
`password` varchar(50) DEFAULT NULL COMMENT '密码',
`real_name` varchar(20) DEFAULT NULL COMMENT '真实姓名',
`status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '账号状态',
`open_id` varchar(50) DEFAULT NULL COMMENT '微信openid',
`from_system` tinyint(4) NOT NULL DEFAULT '0' COMMENT '来源哪个系统。(后期会进行与第三方系统做用户数据对接,默认为当前系统用户中心)',
`create_time` datetime NOT NULL,
`update_time` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=70 DEFAULT CHARSET=utf8;
/*Data for the table `sys_user` */
insert into `sys_user`(`id`,`user_name`,`password`,`real_name`,`status`,`open_id`,`from_system`,`create_time`,`update_time`) values (1,'admin','e10adc3949ba59abbe56e057f20f883e','超级管理员',0,NULL,0,'2016-08-03 13:22:46','2017-11-30 01:58:35'),(34,'chunayuan','e10adc3949ba59abbe56e057f20f883e','李斯',0,NULL,0,'2017-07-11 16:41:36','2017-11-30 02:15:43'),(38,'libai','e10adc3949ba59abbe56e057f20f883e','李白',0,NULL,0,'2017-07-11 16:42:56','2017-12-07 00:51:04'),(39,'zongjingli','e10adc3949ba59abbe56e057f20f883e','王化',1,NULL,0,'2017-07-11 16:43:18','2017-10-25 16:11:34'),(40,'sunbin','e10adc3949ba59abbe56e057f20f883e','孙膑',0,NULL,0,'2017-08-17 10:49:04','2017-12-07 00:50:55'),(43,'sunshangxiang','e10adc3949ba59abbe56e057f20f883e','孙尚香',0,NULL,0,'2017-08-22 00:10:42','2017-09-12 00:40:34'),(47,'wuzetian','e10adc3949ba59abbe56e057f20f883e','武则天',0,NULL,0,'2017-09-12 00:25:05','2017-12-07 00:50:44'),(57,'zhangliang','e10adc3949ba59abbe56e057f20f883e','张良',0,NULL,0,'2017-12-07 00:51:19','2017-12-07 00:51:19'),(58,'sunwukong','e10adc3949ba59abbe56e057f20f883e','孙悟空',0,NULL,0,'2017-12-07 00:51:40','2017-12-07 00:51:40'),(59,'zhouyu','e10adc3949ba59abbe56e057f20f883e','周瑜',2,NULL,0,'2017-12-07 00:52:17','2017-12-07 00:52:17'),(60,'diaochan','e10adc3949ba59abbe56e057f20f883e','貂蝉',1,NULL,0,'2017-12-07 00:52:32','2017-12-07 00:52:32'),(61,'bailishouyue','e10adc3949ba59abbe56e057f20f883e','百里守约',0,NULL,0,'2017-12-07 00:52:52','2017-12-07 00:52:52'),(62,'laofuzi','e10adc3949ba59abbe56e057f20f883e','老夫子',2,NULL,0,'2017-12-07 00:53:40','2017-12-07 00:53:40'),(63,'zhugeliang','e10adc3949ba59abbe56e057f20f883e','诸葛亮',0,NULL,0,'2017-12-21 16:51:51','2017-12-21 16:51:51'),(64,'daji2017','e10adc3949ba59abbe56e057f20f883e','妲己',0,NULL,0,'2017-12-21 16:52:32','2017-12-21 16:52:32'),(65,'zhongkui','e10adc3949ba59abbe56e057f20f883e','钟馗',0,NULL,0,'2017-12-21 16:53:38','2017-12-21 16:53:38'),(66,'zhenji','e10adc3949ba59abbe56e057f20f883e','甄姬',0,NULL,0,'2017-12-21 16:53:51','2017-12-21 16:53:51'),(67,'taiyizhenren','e10adc3949ba59abbe56e057f20f883e','太乙真人',0,NULL,0,'2017-12-21 16:54:13','2017-12-21 16:54:13'),(68,'mingshiyin','e10adc3949ba59abbe56e057f20f883e','明世隐',0,NULL,0,'2017-12-21 16:54:24','2017-12-21 16:54:24'),(69,'nvwa2017','e10adc3949ba59abbe56e057f20f883e','女娲',1,NULL,0,'2017-12-21 16:54:48','2017-12-21 16:54:48');
/*Table structure for table `sys_user_role` */
DROP TABLE IF EXISTS `sys_user_role`;
CREATE TABLE `sys_user_role` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`user_id` bigint(20) NOT NULL,
`role_id` bigint(20) NOT NULL,
`app_id` bigint(20) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=244 DEFAULT CHARSET=utf8 COMMENT='用户角色表';
/*Data for the table `sys_user_role` */
insert into `sys_user_role`(`id`,`user_id`,`role_id`,`app_id`) values (121,38,7,4),(220,1,1,4),(221,34,15,89),(223,39,16,86),(237,43,2,4),(240,40,2,4),(241,47,4,4),(242,59,2,4),(243,60,2,4);
DROP TABLE IF EXISTS `visit_record`;
CREATE TABLE `visit_record` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`cli_ip` varchar(20) DEFAULT NULL COMMENT '客户端ip',
`cli_sys_version` longtext COMMENT '客户端系统版本',
`cli_sys_arch` varchar(20) DEFAULT NULL COMMENT '客户端操作系统位数',
`cli_sys_name` varchar(20) DEFAULT NULL COMMENT '客户端系统名称',
`cli_sys_agent` longtext COMMENT '浏览器基本信息',
`cli_req_url` varchar(200) DEFAULT NULL COMMENT '客户端发出请求时的完整URL',
`cli_req_uri` varchar(50) DEFAULT NULL COMMENT '请求行中的资源名部分',
`cli_req_method` varchar(10) DEFAULT NULL COMMENT '客户机请求方式',
`local_addr` varchar(50) DEFAULT NULL COMMENT 'WEB服务器的IP地址',
`local_name` varchar(50) DEFAULT NULL COMMENT 'WEB服务器的主机名',
`req_session_id` varchar(50) NOT NULL COMMENT '会话的sessionId',
`login_user_name` varchar(20) NOT NULL COMMENT '登录用户名',
`create_time` datetime NOT NULL COMMENT '来访时间',
`update_time` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3343 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `basic_message_wall`;
CREATE TABLE `basic_message_wall` (
`id` bigint(11) NOT NULL AUTO_INCREMENT,
`content` varchar(100) NOT NULL COMMENT '留言内容',
`user_id` bigint(11) DEFAULT NULL COMMENT '留言人id',
`user_name` varchar(20) NOT NULL COMMENT '留言人名称',
`status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '状态(0:可用,1:禁用)',
`ip_address` varchar(20) NOT NULL COMMENT 'IP地址',
`create_time` datetime NOT NULL,
`update_time` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
此处可能存在不合适展示的内容,页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容,可点击提交进行申诉,我们将尽快为您处理。