master

分支 (1)

管理

管理

master

easyiot
/
easyiot.sql

/*
Navicat MySQL Data Transfer

Source Server         : localhost5.7
Source Server Version : 50717
Source Host           : 127.0.0.1:3306
Source Database       : easyiot

Target Server Type    : MYSQL
Target Server Version : 50717
File Encoding         : 65001

Date: 2021-11-07 19:30:42
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for button
-- ----------------------------
DROP TABLE IF EXISTS `button`;
CREATE TABLE `button` (
  `Id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `EnCode` varchar(50) DEFAULT NULL COMMENT '编码',
  `FullName` varchar(50) DEFAULT NULL COMMENT '名称',
  `Location` int(11) DEFAULT NULL COMMENT '位置',
  `ClassName` varchar(50) DEFAULT NULL COMMENT '按钮样式',
  `Icon` varchar(50) DEFAULT NULL COMMENT '图标',
  `SortCode` int(11) DEFAULT NULL COMMENT '排序码',
  `CreateTime` datetime DEFAULT NULL COMMENT '创建时间',
  `CreateUserId` int(11) DEFAULT NULL COMMENT '创建用户主键',
  `UpdateTime` datetime DEFAULT NULL COMMENT '修改时间',
  `UpdateUserId` int(11) DEFAULT NULL COMMENT '修改用户主键',
  `SystemSign` tinyint(1) DEFAULT '0' COMMENT '系统标记',
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='按钮表';

-- ----------------------------
-- Records of button
-- ----------------------------
INSERT INTO `button` VALUES ('1', 'add', '添加', '1', '', '&#xe6d9;', '1', '2019-10-29 16:25:25', '1', '2019-10-29 16:25:29', '1', '0');
INSERT INTO `button` VALUES ('2', 'del', '删除', '0', 'layui-btn-danger', '&#xe659;', '3', '2019-10-29 16:29:17', '1', '2019-10-29 16:29:20', '1', '0');
INSERT INTO `button` VALUES ('3', 'edit', '修改', '0', null, '&#xe761;', '2', '2019-10-29 16:30:32', '1', '2021-09-10 11:16:49', '1', '0');
INSERT INTO `button` VALUES ('4', 'batchDel', '批量删除', '1', 'layui-btn-danger', '&#xe6b4;', '4', '2019-10-29 16:35:16', '1', '2019-10-29 16:35:19', '1', '0');
INSERT INTO `button` VALUES ('5', 'pwdReset', '重置密码', '0', 'layui-btn-warm', '&#xe6a4;', '5', '2019-11-14 09:26:11', '1', '2019-11-14 09:26:20', '1', '0');
INSERT INTO `button` VALUES ('6', 'assign', '分配权限', '0', 'layui-btn-normal', '&#xe73a;', '6', '2019-11-16 11:50:37', '1', '2021-09-11 13:58:44', '1', '0');
INSERT INTO `button` VALUES ('7', 'sync', '信息同步', '0', 'layui-btn-normal', '&#xe69f;', '7', '2021-11-06 18:14:33', '1', '2021-11-06 18:15:09', '1', '0');

-- ----------------------------
-- Table structure for device
-- ----------------------------
DROP TABLE IF EXISTS `device`;
CREATE TABLE `device` (
  `Id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `SortCode` int(11) DEFAULT NULL COMMENT '排序码',
  `CreateTime` datetime DEFAULT NULL COMMENT '创建时间',
  `CreateUserId` bigint(20) DEFAULT NULL COMMENT '创建者',
  `UpdateTime` datetime DEFAULT NULL COMMENT '修改时间',
  `UpdateUserId` bigint(20) DEFAULT NULL COMMENT '修改人',
  `DeviceCode` varchar(50) DEFAULT NULL COMMENT '设备编号',
  `DeviceName` varchar(50) DEFAULT NULL COMMENT '设备名称',
  `LastActive` datetime DEFAULT NULL COMMENT '上线时间',
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='设备表';

-- ----------------------------
-- Records of device
-- ----------------------------
INSERT INTO `device` VALUES ('5', '1', '2021-11-06 18:17:17', '1', '2021-11-06 18:17:17', '1', '1001', '虾咚1号快递柜', '2021-11-07 18:29:50');

-- ----------------------------
-- Table structure for items
-- ----------------------------
DROP TABLE IF EXISTS `items`;
CREATE TABLE `items` (
  `Id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `ParentId` int(11) DEFAULT NULL COMMENT '父级',
  `EnCode` varchar(50) DEFAULT NULL COMMENT '编码',
  `FullName` varchar(50) DEFAULT NULL COMMENT '名称',
  `SortCode` int(11) DEFAULT NULL COMMENT '排序码',
  `CreateTime` datetime DEFAULT NULL COMMENT '创建时间',
  `CreateUserId` int(11) DEFAULT NULL COMMENT '创建用户主键',
  `UpdateTime` datetime DEFAULT NULL COMMENT '修改时间',
  `UpdateUserId` int(11) DEFAULT NULL COMMENT '修改用户主键',
  `SystemSign` tinyint(1) DEFAULT '0' COMMENT '系统标记',
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='字典表';

-- ----------------------------
-- Records of items
-- ----------------------------
INSERT INTO `items` VALUES ('1', '0', 'Sys_Items', '通用字典', '0', '2019-10-12 11:47:23', '1', '2021-09-11 13:33:58', '1', '0');
INSERT INTO `items` VALUES ('2', '1', 'OrganizeCategory', '机构分类', '1', '2019-10-12 15:44:12', '1', '2021-09-10 23:04:07', '1', '0');
INSERT INTO `items` VALUES ('3', '1', 'RoleType', '角色类型', '2', '2019-10-12 15:45:26', '1', '2019-10-12 15:45:30', '1', '0');
INSERT INTO `items` VALUES ('4', '1', 'Certificate', '证件名称', '3', '2019-10-12 15:49:04', '1', '2019-10-12 15:49:08', '1', '0');
INSERT INTO `items` VALUES ('5', '1', 'Education', '学历', '4', '2019-10-12 15:49:57', '1', '2019-10-12 15:50:00', '1', '0');
INSERT INTO `items` VALUES ('8', '1', 'Nation', '民族', '7', '2019-10-12 15:58:43', '1', '2019-10-12 15:58:40', '1', '0');
INSERT INTO `items` VALUES ('9', '1', 'Gender', '性别', '8', '2019-10-12 15:59:06', '1', '2020-01-16 10:09:47', '1', '0');

-- ----------------------------
-- Table structure for itemsdetail
-- ----------------------------
DROP TABLE IF EXISTS `itemsdetail`;
CREATE TABLE `itemsdetail` (
  `Id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `ItemId` int(11) DEFAULT NULL COMMENT '主表主键',
  `ItemCode` varchar(50) DEFAULT NULL COMMENT '编码',
  `ItemName` varchar(50) DEFAULT NULL COMMENT '名称',
  `SortCode` int(11) DEFAULT NULL COMMENT '排序码',
  `CreateTime` datetime DEFAULT NULL COMMENT '创建时间',
  `CreateUserId` int(11) DEFAULT NULL COMMENT '创建用户主键',
  `UpdateTime` datetime DEFAULT NULL COMMENT '修改时间',
  `UpdateUserId` int(11) DEFAULT NULL COMMENT '修改用户主键',
  `SystemSign` tinyint(1) DEFAULT '0' COMMENT '系统标记',
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='字典明细表';

-- ----------------------------
-- Records of itemsdetail
-- ----------------------------
INSERT INTO `itemsdetail` VALUES ('1', '2', 'Company', '公司', '1', '2019-10-12 16:08:09', '1', '2019-10-12 16:08:15', '1', '0');
INSERT INTO `itemsdetail` VALUES ('2', '2', 'Department', '部门', '2', '2019-10-12 16:09:34', '1', '2019-10-12 16:09:37', '1', '0');
INSERT INTO `itemsdetail` VALUES ('3', '2', 'WorkGroup', '小组', '3', '2019-10-12 16:10:05', '1', '2019-10-12 16:10:07', '1', '0');
INSERT INTO `itemsdetail` VALUES ('4', '3', 'Sys_Role', '系统角色', '1', '2019-10-12 16:13:10', '1', '2019-10-12 16:13:14', '1', '0');
INSERT INTO `itemsdetail` VALUES ('5', '3', 'Bus_Role', '业务角色', '2', '2019-10-12 16:15:16', '1', '2019-10-12 16:15:30', '1', '0');
INSERT INTO `itemsdetail` VALUES ('6', '3', 'Other', '其他角色', '3', '2019-10-12 16:16:07', '1', '2019-10-12 16:16:09', '1', '0');
INSERT INTO `itemsdetail` VALUES ('7', '4', 'Id_Card', '身份证', '1', '2019-10-12 16:17:45', '1', '2019-10-12 16:17:49', '1', '0');
INSERT INTO `itemsdetail` VALUES ('8', '4', 'Other', '其他', '2', '2019-10-12 16:19:06', '1', '2021-09-11 13:47:40', '1', '0');
INSERT INTO `itemsdetail` VALUES ('9', '5', 'Junior College', '大专', '1', '2019-10-12 16:26:16', '1', '2019-10-12 16:26:19', '1', '0');
INSERT INTO `itemsdetail` VALUES ('10', '5', 'Undergraduate', '本科', '2', '2019-10-12 16:26:45', '1', '2019-10-12 16:26:49', '1', '0');
INSERT INTO `itemsdetail` VALUES ('11', '5', 'Master', '硕士', '3', '2019-10-12 16:30:22', '1', '2019-10-12 16:30:26', '1', '0');
INSERT INTO `itemsdetail` VALUES ('12', '5', 'Doctor', '博士', '4', '2019-10-12 16:31:18', '1', '2019-10-12 16:31:21', '1', '0');
INSERT INTO `itemsdetail` VALUES ('13', '5', 'Other', '其他', '5', '2019-10-12 16:31:44', '1', '2019-10-12 16:31:47', '1', '0');
INSERT INTO `itemsdetail` VALUES ('17', '6', 'Widowed', '丧偶', '4', '2019-10-29 14:27:50', '1', '2019-10-29 14:27:53', '1', '0');
INSERT INTO `itemsdetail` VALUES ('18', '6', 'Other', '其他', '5', '2019-10-29 14:28:08', '1', '2019-10-29 14:28:11', '1', '0');
INSERT INTO `itemsdetail` VALUES ('19', '7', 'Bred', '未育', '1', '2019-10-29 14:33:08', '1', '2019-10-29 14:33:11', '1', '0');
INSERT INTO `itemsdetail` VALUES ('20', '7', 'UnBred', '已育', '2', '2019-10-29 14:33:46', '1', '2019-10-29 14:33:49', '1', '0');
INSERT INTO `itemsdetail` VALUES ('21', '7', 'Other', '其他', '3', '2019-10-29 14:34:21', '1', '2019-10-29 14:34:25', '1', '0');
INSERT INTO `itemsdetail` VALUES ('22', '8', 'Han', '汉族', '1', '2019-10-29 14:36:30', '1', '2019-10-29 14:36:36', '1', '0');
INSERT INTO `itemsdetail` VALUES ('23', '8', 'Other', '其他', '2', '2019-10-29 14:36:54', '1', '2019-10-29 14:36:59', '1', '0');
INSERT INTO `itemsdetail` VALUES ('24', '9', 'Male', '男', '1', '2019-10-29 14:38:58', '1', '2019-10-29 14:39:00', '1', '0');
INSERT INTO `itemsdetail` VALUES ('25', '9', 'Female', '女', '3', '2019-10-29 14:39:23', '1', '2021-09-11 08:37:58', '1', '0');

-- ----------------------------
-- Table structure for logonlog
-- ----------------------------
DROP TABLE IF EXISTS `logonlog`;
CREATE TABLE `logonlog` (
  `Id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `LogType` varchar(50) DEFAULT NULL COMMENT '登录类型',
  `Account` varchar(50) DEFAULT NULL COMMENT '账户',
  `RealName` varchar(50) DEFAULT NULL COMMENT '姓名',
  `Description` varchar(200) DEFAULT NULL COMMENT '描述',
  `IPAddress` varchar(50) DEFAULT NULL COMMENT 'IP地址',
  `IPAddressName` varchar(50) DEFAULT NULL COMMENT 'IP所在城市',
  `CreateTime` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=251 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='登录日志表';

-- ----------------------------
-- Records of logonlog
-- ----------------------------

-- ----------------------------
-- Table structure for module
-- ----------------------------
DROP TABLE IF EXISTS `module`;
CREATE TABLE `module` (
  `Id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `ParentId` int(11) DEFAULT NULL COMMENT '父级',
  `FullName` varchar(50) DEFAULT NULL COMMENT '名称',
  `FontFamily` varchar(50) DEFAULT NULL COMMENT '字体类型',
  `Icon` varchar(50) DEFAULT NULL COMMENT '图标',
  `UrlAddress` varchar(100) DEFAULT NULL COMMENT '链接',
  `SortCode` int(11) DEFAULT NULL COMMENT '排序码',
  `CreateTime` datetime DEFAULT NULL COMMENT '创建时间',
  `CreateUserId` int(11) DEFAULT NULL COMMENT '创建用户主键',
  `UpdateTime` datetime DEFAULT NULL COMMENT '修改时间',
  `UpdateUserId` int(11) DEFAULT NULL COMMENT '修改用户主键',
  `SystemSign` tinyint(1) DEFAULT '0' COMMENT '系统标记',
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='模块表';

-- ----------------------------
-- Records of module
-- ----------------------------
INSERT INTO `module` VALUES ('1', '0', '系统管理', 'ok-icon', '&#xe6b0;', '/', '50', '2019-09-19 15:28:17', '1', '2021-09-11 14:31:51', '1', '0');
INSERT INTO `module` VALUES ('2', '0', '系统安全', 'ok-icon', '&#xe769;', '/', '60', '2019-09-19 15:48:28', '1', '2019-09-19 15:48:33', '1', '0');
INSERT INTO `module` VALUES ('4', '1', '机构管理', 'ok-icon', '&#xe726;', '/Permissions/Organize', '51', '2019-09-19 16:51:51', '1', '2019-11-25 10:48:26', '1', '0');
INSERT INTO `module` VALUES ('5', '1', '字典分类', 'ok-icon', '&#xe640;', '/Permissions/Items', '52', '2019-11-26 15:44:12', '1', '2019-11-26 15:44:12', '1', '0');
INSERT INTO `module` VALUES ('6', '1', '数据字典', 'ok-icon', '&#xe660;', '/Permissions/ItemsDetail', '53', '2019-09-19 16:58:27', '1', '2019-11-26 15:47:33', '1', '0');
INSERT INTO `module` VALUES ('7', '1', '用户管理', 'ok-icon', '&#xe736;', '/Permissions/User', '54', '2019-09-19 16:57:34', '1', '2019-09-19 16:57:38', '1', '0');
INSERT INTO `module` VALUES ('8', '1', '角色管理', 'ok-icon', '&#xe7be;', '/Permissions/Role', '55', '2019-09-19 16:54:54', '1', '2019-09-19 16:54:58', '1', '0');
INSERT INTO `module` VALUES ('9', '1', '系统菜单', 'ok-icon', '&#xe7ad;', '/Permissions/Module', '56', '2019-09-19 16:58:49', '1', '2019-09-19 16:58:45', '1', '0');
INSERT INTO `module` VALUES ('10', '1', '按钮管理', 'ok-icon', '&#xe729;', '/Permissions/Button', '57', '2019-11-26 10:30:36', '1', '2019-11-26 10:30:36', '1', '0');
INSERT INTO `module` VALUES ('11', '2', '登录日志', 'ok-icon', '&#xe706;', '/Security/LogonLog', '61', '2019-09-23 18:17:12', '1', '2019-09-23 18:17:18', '1', '0');
INSERT INTO `module` VALUES ('18', '29', '设备管理', 'ok-icon', '&#xe64f;', '/SysSet/Device', '11', '2021-09-09 11:07:46', '4', '2021-11-06 17:32:33', '1', '0');
INSERT INTO `module` VALUES ('29', '0', '要素管理', 'ok-icon', '&#xe889;', '/', '10', '2021-09-26 16:27:26', '1', '2021-11-06 17:32:26', '1', '0');

-- ----------------------------
-- Table structure for organize
-- ----------------------------
DROP TABLE IF EXISTS `organize`;
CREATE TABLE `organize` (
  `Id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `ParentId` int(11) DEFAULT NULL COMMENT '父级',
  `EnCode` varchar(50) DEFAULT NULL COMMENT '编码',
  `FullName` varchar(50) DEFAULT NULL COMMENT '名称',
  `CategoryId` int(11) DEFAULT NULL COMMENT '分类',
  `SortCode` int(4) DEFAULT NULL COMMENT '排序码',
  `CreateTime` datetime DEFAULT NULL COMMENT '创建时间',
  `CreateUserId` int(11) DEFAULT NULL COMMENT '创建用户主键',
  `UpdateTime` datetime DEFAULT NULL COMMENT '修改时间',
  `UpdateUserId` int(11) DEFAULT NULL COMMENT '修改用户主键',
  `SystemSign` tinyint(1) DEFAULT '0' COMMENT '系统标记',
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='组织表';

-- ----------------------------
-- Records of organize
-- ----------------------------
INSERT INTO `organize` VALUES ('1', '0', 'Company', '通用公司', '1', '1', '2019-09-26 17:52:17', '1', '2021-09-11 13:34:11', '1', '0');
INSERT INTO `organize` VALUES ('2', '1', 'Market', '业务部', '2', '5', '2019-10-29 15:32:27', '1', '2019-11-25 17:05:15', '1', '0');
INSERT INTO `organize` VALUES ('3', '1', 'Ministry', '技术部', '2', '2', '2019-10-29 15:32:39', '1', '2021-09-11 13:54:45', '1', '0');
INSERT INTO `organize` VALUES ('4', '1', 'HumanResourse', '人事部', '2', '3', '2019-10-29 15:33:27', '1', '2019-10-29 15:33:31', '1', '0');
INSERT INTO `organize` VALUES ('5', '3', 'IT Group', '研发小组', '3', '4', '2019-10-29 15:35:10', '1', '2019-11-26 10:15:31', '1', '0');
INSERT INTO `organize` VALUES ('6', '1', 'market', '市场部', '2', '3', '2021-09-09 15:34:38', '1', '2021-09-09 15:34:38', '1', '0');

-- ----------------------------
-- Table structure for role
-- ----------------------------
DROP TABLE IF EXISTS `role`;
CREATE TABLE `role` (
  `Id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `EnCode` varchar(50) DEFAULT NULL COMMENT '编码',
  `FullName` varchar(50) DEFAULT NULL COMMENT '名称',
  `TypeClass` int(11) DEFAULT NULL COMMENT '类型',
  `SortCode` int(11) DEFAULT NULL COMMENT '排序码',
  `CreateTime` datetime DEFAULT NULL COMMENT '创建时间',
  `CreateUserId` int(11) DEFAULT NULL COMMENT '创建用户主键',
  `UpdateTime` datetime DEFAULT NULL COMMENT '修改时间',
  `UpdateUserId` int(11) DEFAULT NULL COMMENT '修改用户主键',
  `SystemSign` tinyint(1) DEFAULT '0' COMMENT '系统标记',
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='角色表';

-- ----------------------------
-- Records of role
-- ----------------------------
INSERT INTO `role` VALUES ('1', 'administrator', '超级管理员', '4', '1', '2019-10-29 17:20:49', '1', '2021-09-11 13:49:04', '1', '0');

-- ----------------------------
-- Table structure for roleauthorize
-- ----------------------------
DROP TABLE IF EXISTS `roleauthorize`;
CREATE TABLE `roleauthorize` (
  `RoleId` char(10) NOT NULL COMMENT '角色主键',
  `ModuleId` char(10) NOT NULL COMMENT '模块主键',
  `ButtonId` char(10) NOT NULL COMMENT '按钮主键',
  PRIMARY KEY (`RoleId`,`ModuleId`,`ButtonId`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='角色授权表';

-- ----------------------------
-- Records of roleauthorize
-- ----------------------------
INSERT INTO `roleauthorize` VALUES ('1', '1', '0');
INSERT INTO `roleauthorize` VALUES ('1', '10', '0');
INSERT INTO `roleauthorize` VALUES ('1', '10', '1');
INSERT INTO `roleauthorize` VALUES ('1', '10', '2');
INSERT INTO `roleauthorize` VALUES ('1', '10', '3');
INSERT INTO `roleauthorize` VALUES ('1', '10', '4');
INSERT INTO `roleauthorize` VALUES ('1', '11', '0');
INSERT INTO `roleauthorize` VALUES ('1', '11', '2');
INSERT INTO `roleauthorize` VALUES ('1', '11', '4');
INSERT INTO `roleauthorize` VALUES ('1', '18', '0');
INSERT INTO `roleauthorize` VALUES ('1', '18', '1');
INSERT INTO `roleauthorize` VALUES ('1', '18', '2');
INSERT INTO `roleauthorize` VALUES ('1', '18', '3');
INSERT INTO `roleauthorize` VALUES ('1', '18', '4');
INSERT INTO `roleauthorize` VALUES ('1', '18', '7');
INSERT INTO `roleauthorize` VALUES ('1', '2', '0');
INSERT INTO `roleauthorize` VALUES ('1', '29', '0');
INSERT INTO `roleauthorize` VALUES ('1', '4', '0');
INSERT INTO `roleauthorize` VALUES ('1', '4', '1');
INSERT INTO `roleauthorize` VALUES ('1', '4', '2');
INSERT INTO `roleauthorize` VALUES ('1', '4', '3');
INSERT INTO `roleauthorize` VALUES ('1', '5', '0');
INSERT INTO `roleauthorize` VALUES ('1', '5', '1');
INSERT INTO `roleauthorize` VALUES ('1', '5', '2');
INSERT INTO `roleauthorize` VALUES ('1', '5', '3');
INSERT INTO `roleauthorize` VALUES ('1', '6', '0');
INSERT INTO `roleauthorize` VALUES ('1', '6', '1');
INSERT INTO `roleauthorize` VALUES ('1', '6', '2');
INSERT INTO `roleauthorize` VALUES ('1', '6', '3');
INSERT INTO `roleauthorize` VALUES ('1', '6', '4');
INSERT INTO `roleauthorize` VALUES ('1', '7', '0');
INSERT INTO `roleauthorize` VALUES ('1', '7', '1');
INSERT INTO `roleauthorize` VALUES ('1', '7', '2');
INSERT INTO `roleauthorize` VALUES ('1', '7', '3');
INSERT INTO `roleauthorize` VALUES ('1', '7', '4');
INSERT INTO `roleauthorize` VALUES ('1', '7', '5');
INSERT INTO `roleauthorize` VALUES ('1', '8', '0');
INSERT INTO `roleauthorize` VALUES ('1', '8', '1');
INSERT INTO `roleauthorize` VALUES ('1', '8', '2');
INSERT INTO `roleauthorize` VALUES ('1', '8', '3');
INSERT INTO `roleauthorize` VALUES ('1', '8', '4');
INSERT INTO `roleauthorize` VALUES ('1', '8', '6');
INSERT INTO `roleauthorize` VALUES ('1', '9', '0');
INSERT INTO `roleauthorize` VALUES ('1', '9', '1');
INSERT INTO `roleauthorize` VALUES ('1', '9', '2');
INSERT INTO `roleauthorize` VALUES ('1', '9', '3');

-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `Id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `Account` varchar(50) DEFAULT NULL COMMENT '账户',
  `UserPassword` varchar(50) DEFAULT NULL COMMENT '密码',
  `RealName` varchar(50) DEFAULT NULL COMMENT '姓名',
  `HeadIcon` varchar(50) DEFAULT NULL COMMENT '头像',
  `Gender` smallint(1) DEFAULT NULL COMMENT '性别',
  `MobilePhone` varchar(50) DEFAULT NULL COMMENT '手机',
  `DepartmentId` int(11) DEFAULT NULL COMMENT '部门主键',
  `RoleId` int(11) DEFAULT NULL COMMENT '角色主键',
  `EnabledMark` smallint(1) DEFAULT NULL COMMENT '有效标志',
  `CreateTime` datetime DEFAULT NULL COMMENT '创建时间',
  `CreateUserId` int(11) DEFAULT NULL COMMENT '创建用户主键',
  `UpdateTime` datetime DEFAULT NULL COMMENT '修改时间',
  `UpdateUserId` int(11) DEFAULT NULL COMMENT '修改用户主键',
  `SystemSign` tinyint(1) DEFAULT '0' COMMENT '系统标记',
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='用户表';

-- ----------------------------
-- Records of users
-- ----------------------------
INSERT INTO `users` VALUES ('1', 'admin', 'e10adc3949ba59abbe56e057f20f883e', 'admin', '/Upload/202109101006356002.jpg', '1', '13100110011', '3', '1', '0', '2019-10-29 15:40:26', '1', '2021-09-11 13:54:11', '1', '0');