/*
Navicat MySQL Data Transfer
Source Server : MySql8
Source Server Version : 80021
Source Host : localhost:3338
Source Database : mysys
Target Server Type : MYSQL
Target Server Version : 80021
File Encoding : 65001
Date: 2020-08-12 09:48:45
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for account
-- ----------------------------
DROP TABLE IF EXISTS `account`;
CREATE TABLE `account` (
`ID` bigint NOT NULL AUTO_INCREMENT,
`ACCOUNT_GU_ID` varchar(50) DEFAULT NULL COMMENT 'IM中的用户标识',
`ACCOUNT_ID` varchar(50) DEFAULT NULL COMMENT '系统账号',
`D_ACCOUNT_ID` varchar(50) DEFAULT NULL COMMENT '钉钉账号',
`W_ACCOUNT_ID` varchar(50) DEFAULT NULL COMMENT '微信账号',
`PASS_WORD` varchar(50) DEFAULT NULL COMMENT '密码',
`PASSWORD_TYPE` varchar(6) DEFAULT NULL COMMENT '密码类型',
`THMEM` varchar(6) DEFAULT NULL COMMENT '系统主题',
`USER_PRIV` text COMMENT '用户权限',
`MANAGE_DEPT` text,
`PAGE_PRIV` varchar(30) DEFAULT NULL,
`NOT_LOGIN` varchar(3) DEFAULT NULL COMMENT '账号状态 默认0,离职为1',
`ON_LINE` int DEFAULT NULL COMMENT '在线状态',
`LAST_VISIT_TIME` varchar(20) DEFAULT NULL COMMENT '最后在线时间',
`LANGUAGE` varchar(6) DEFAULT NULL COMMENT '语言',
`BY_NAME` varchar(60) DEFAULT NULL COMMENT '用户别名',
`LOGIN_NUM` int DEFAULT '0' COMMENT '登陆次数',
`LAST_LOGIN_TIME` varchar(20) DEFAULT NULL COMMENT '最后登录时间',
`UPDATE_PASSWORD_TIME` varchar(20) DEFAULT NULL COMMENT '最后修改密码时间',
`IM_FLAG` varchar(2) DEFAULT '0',
`APP_PRIV` text COMMENT 'app 模块权限',
`HEAD_IMG` varchar(255) DEFAULT NULL,
`NO_IP` varchar(200) DEFAULT NULL,
`OP_FLAG` varchar(2) DEFAULT '0' COMMENT '1为系统管理员,0为普通用户',
`HOME_PAGE` text,
`D_STATUS` varchar(2) DEFAULT NULL,
`W_STATUS` varchar(2) DEFAULT NULL,
`ORG_ID` varchar(50) DEFAULT NULL,
PRIMARY KEY (`ID`) USING BTREE,
KEY `ACCOUNT_ID` (`ACCOUNT_ID`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of account
-- ----------------------------
INSERT INTO `account` VALUES ('1', null, 'admin', 'admin', 'A-LXYZ', 'a66abb5684c45962d887564f08346e8d', '1', '7', '96C0173D-8279-AABA-0749-A60CB47FEADE', null, '', '0', null, null, '1', 'administrator', '546', '2020-08-12 09:15:32', '2020-07-27 11:59:49', '0', '[{\"id\":\"1\",\"name\":\"日程安排\",\"selected\":\"1\",\"sort\":1},{\"id\":\"2\",\"name\":\"工作日志\",\"selected\":\"1\",\"sort\":2},{\"id\":\"4\",\"name\":\"定位考勤\",\"selected\":\"1\",\"sort\":3},{\"id\":\"5\",\"name\":\"工作审批\",\"selected\":\"1\",\"sort\":4},{\"id\":\"6\",\"name\":\"客户管理\",\"selected\":\"1\",\"sort\":5}]', '20190920203310_901_1.png', '', '1', '{\"left\":[{\"module\":\"news\",\"id\":\"undefined\",\"moduleName\":\"新闻\"},{\"module\":\"notice\",\"id\":\"undefined\",\"moduleName\":\"通知公告\"},{\"module\":\"myFile\",\"id\":\"undefined\",\"moduleName\":\"我的文件\"},{\"module\":\"document\",\"id\":\"DCA193FD-F96C-4324-AFD3-3C6F73D61829\",\"moduleName\":\"我的收发文\"}],\"right\":[{\"module\":\"bpm\",\"id\":\"undefined\",\"moduleName\":\"待办BPM\"},{\"module\":\"myTask\",\"id\":\"undefined\",\"moduleName\":\"我的任务\"},{\"module\":\"myMeeting\",\"id\":\"undefined\",\"moduleName\":\"我的会议\"}]}', '1', '1', '8EADB678-A646-1E51-3E87-75A547B8AF19');
INSERT INTO `account` VALUES ('2', null, 'luyunyun', 'luyunyun', 'luyunyun', '93fe5dde6896cb120a41ab087e239d2f', '1', null, '96C0173D-8279-AABA-0749-A60CB47FEADE', null, null, '0', null, null, null, null, '9', '2020-07-26 07:54:59', null, null, null, '20200402130414_332_admin.png', null, '0', '{\"left\":[{\"module\":\"calendar\",\"id\":\"AA8DAC92-32DC-E29F-4F9E-47ADF9246A33\",\"moduleName\":\"个人日程\"},{\"module\":\"email\",\"id\":\"DEEEF17E-1B08-8DEB-62A4-C8360C71BFDA\",\"moduleName\":\"内部邮件\"},{\"module\":\"superversion\",\"id\":\"637C1CE4-5360-A8D9-185E-D4DF75B954E1\",\"moduleName\":\"督查督办\"},{\"module\":\"sms\",\"id\":\"68E2B9EE-8D3A-A0E9-2ACF-E88B3BF348F1\",\"moduleName\":\"未读消息\"},{\"module\":\"myfile\",\"id\":\"F51AFD72-B890-6B27-1E74-61B326E62C25\",\"moduleName\":\"我的文件\"},{\"module\":\"bpm\",\"id\":\"F51AFD72-B890-6B27-1E74-61B326E62C26\",\"moduleName\":\"待办BPM\"},{\"module\":\"myTask\",\"id\":\"A0D47E6D-29F4-4A38-A497-165A3F763054\",\"moduleName\":\"我的任务\"}],\"right\":[{\"module\":\"news\",\"id\":\"FE9E931B-2ABF-4BA3-2E9A-07B852D7FBE8\",\"moduleName\":\"新闻\"},{\"module\":\"notice\",\"id\":\"716FA644-D234-A158-A939-975A011BDD13\",\"moduleName\":\"通知公告\"}]}', '1', '1', '8EADB678-A646-1E51-3E87-75A547B8AF19');
INSERT INTO `account` VALUES ('3', null, 'liushaoquan', 'manager9480', 'liushaoquan', '0500446d47e57067bf0c80b55d236914', '1', null, '96C0173D-8279-AABA-0749-A60CB47FEADE', null, null, '0', null, null, null, null, '0', '2020-07-02 08:09:04', null, null, null, '20200314192428_557_logo.jpg', null, '0', '{\"left\":[{\"module\":\"calendar\",\"id\":\"undefined\",\"moduleName\":\"个人日程\"},{\"module\":\"myfile\",\"id\":\"undefined\",\"moduleName\":\"我的文件\"},{\"module\":\"bpm\",\"id\":\"undefined\",\"moduleName\":\"待办BPM\"},{\"module\":\"superversion\",\"id\":\"undefined\",\"moduleName\":\"督查督办\"},{\"module\":\"myTask\",\"id\":\"undefined\",\"moduleName\":\"我的任务\"}],\"right\":[{\"module\":\"news\",\"id\":\"undefined\",\"moduleName\":\"新闻\"},{\"module\":\"notice\",\"id\":\"undefined\",\"moduleName\":\"通知公告\"},{\"module\":\"email\",\"id\":\"undefined\",\"moduleName\":\"内部邮件\"},{\"module\":\"sms\",\"id\":\"undefined\",\"moduleName\":\"未读消息\"}]}', '1', '1', '8EADB678-A646-1E51-3E87-75A547B8AF19');
INSERT INTO `account` VALUES ('4', null, 'zhanghaiyang', '', '', '0df8a08382a1fe0397959cd751447b09', '1', null, '7C7F45A1-CF32-4C6E-EFA8-3CA181CCDF38', null, null, '0', null, null, null, null, '0', '2020-06-10 01:38:56', null, null, null, null, null, '0', null, '', '', '8EADB678-A646-1E51-3E87-75A547B8AF19');
INSERT INTO `account` VALUES ('5', null, 'wutianyi', '', '', '275d5d13c52cd08b47393a3fb779e179', '1', null, '7C7F45A1-CF32-4C6E-EFA8-3CA181CCDF38', null, null, '0', null, null, null, null, '0', '2020-04-04 06:33:12', null, null, null, null, null, '0', null, '', '', '8EADB678-A646-1E51-3E87-75A547B8AF19');
INSERT INTO `account` VALUES ('6', null, 'zhangxiaofei', '', '', '8a09b8f540c6dc0103da49b72fcf5318', '1', null, '7C7F45A1-CF32-4C6E-EFA8-3CA181CCDF38', null, null, '0', null, null, null, null, '2', '2020-07-21 09:32:08', null, null, null, null, null, '0', '{\"left\":[{\"module\":\"calendar\",\"id\":\"AA8DAC92-32DC-E29F-4F9E-47ADF9246A33\",\"moduleName\":\"个人日程\"},{\"module\":\"email\",\"id\":\"DEEEF17E-1B08-8DEB-62A4-C8360C71BFDA\",\"moduleName\":\"内部邮件\"},{\"module\":\"superversion\",\"id\":\"637C1CE4-5360-A8D9-185E-D4DF75B954E1\",\"moduleName\":\"督查督办\"},{\"module\":\"sms\",\"id\":\"68E2B9EE-8D3A-A0E9-2ACF-E88B3BF348F1\",\"moduleName\":\"未读消息\"},{\"module\":\"myfile\",\"id\":\"F51AFD72-B890-6B27-1E74-61B326E62C25\",\"moduleName\":\"我的文件\"},{\"module\":\"bpm\",\"id\":\"F51AFD72-B890-6B27-1E74-61B326E62C26\",\"moduleName\":\"待办BPM\"},{\"module\":\"myTask\",\"id\":\"A0D47E6D-29F4-4A38-A497-165A3F763054\",\"moduleName\":\"我的任务\"}],\"right\":[{\"module\":\"notice\",\"id\":\"716FA644-D234-A158-A939-975A011BDD13\",\"moduleName\":\"通知公告\"},{\"module\":\"news\",\"id\":\"FE9E931B-2ABF-4BA3-2E9A-07B852D7FBE8\",\"moduleName\":\"新闻\"}]}', '', '', '8EADB678-A646-1E51-3E87-75A547B8AF19');
INSERT INTO `account` VALUES ('7', null, 'wangfang', '', '', '02f90259b8e4f394328895009d7d0d42', '1', null, '7C7F45A1-CF32-4C6E-EFA8-3CA181CCDF38', null, null, '1', null, null, null, null, '0', '2020-04-04 06:33:12', null, null, null, null, null, '0', null, '', ''
没有合适的资源?快使用搜索试试~ 我知道了~
资源推荐
资源详情
资源评论
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
收起资源包目录
![package](https://csdnimg.cn/release/downloadcmsfe/public/img/package.f3fc750b.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/HTML.png)
共 2000 条
- 1
- 2
- 3
- 4
- 5
- 6
- 20
资源评论
![avatar-default](https://csdnimg.cn/release/downloadcmsfe/public/img/lazyLogo2.1882d7f4.png)
![avatar](https://profile-avatar.csdnimg.cn/default.jpg!1)
入伍击寇
- 粉丝: 131
- 资源: 4704
上传资源 快速赚钱
我的内容管理 展开
我的资源 快来上传第一个资源
我的收益
登录查看自己的收益我的积分 登录查看自己的积分
我的C币 登录后查看C币余额
我的收藏
我的下载
下载帮助
![voice](https://csdnimg.cn/release/downloadcmsfe/public/img/voice.245cc511.png)
![center-task](https://csdnimg.cn/release/downloadcmsfe/public/img/center-task.c2eda91a.png)
安全验证
文档复制为VIP权益,开通VIP直接复制
![dialog-icon](https://csdnimg.cn/release/downloadcmsfe/public/img/green-success.6a4acb44.png)