/*
Navicat MySQL Data Transfer
Source Server : 192.168.244.128
Source Server Version : 50732
Source Host : 192.168.244.128:3306
Source Database : rebuild_3d_user_db
Target Server Type : MYSQL
Target Server Version : 50732
File Encoding : 65001
Date: 2021-01-12 16:23:09
*/
create database rebuild_3d_user_db;
use rebuild_3d_user_db;
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for module
-- ----------------------------
DROP TABLE IF EXISTS `module`;
CREATE TABLE `module` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'primary key',
`name` varchar(64) NOT NULL DEFAULT '' COMMENT '模块名称',
`module_parent_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '父模块ID,自引用',
`level` tinyint(4) NOT NULL DEFAULT '0' COMMENT '模块等级,比如是一级模块是1,二级模块是2,标识用的',
`remark` varchar(128) NOT NULL DEFAULT '' COMMENT '备注',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='模块表';
-- ----------------------------
-- Records of module
-- ----------------------------
INSERT INTO `module` VALUES ('1', 'Demo演示', '0', '1', '', '2020-04-27 17:22:20', '2020-12-02 14:03:42');
INSERT INTO `module` VALUES ('2', '工具管理', '0', '1', '', '2020-04-27 17:22:29', '2020-04-27 17:22:29');
INSERT INTO `module` VALUES ('3', '系统管理', '0', '1', '', '2020-04-27 17:22:36', '2020-04-27 17:22:36');
-- ----------------------------
-- Table structure for permission
-- ----------------------------
DROP TABLE IF EXISTS `permission`;
CREATE TABLE `permission` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'primary key',
`role_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '角色表ID',
`module_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '模块表ID',
`crud_operation` int(11) NOT NULL DEFAULT '0' COMMENT '权限定义:1增加,2读取,4更新,8删除, 16控制权限,11111四个对应位上是否为1对应相关权限',
`remark` varchar(128) NOT NULL DEFAULT '' COMMENT '备注',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
PRIMARY KEY (`id`),
UNIQUE KEY `role_module_id` (`role_id`,`module_id`),
KEY `module_id` (`module_id`),
CONSTRAINT `permission_ibfk_1` FOREIGN KEY (`role_id`) REFERENCES `role` (`id`),
CONSTRAINT `permission_ibfk_2` FOREIGN KEY (`module_id`) REFERENCES `module` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COMMENT='授权表';
-- ----------------------------
-- Records of permission
-- ----------------------------
INSERT INTO `permission` VALUES ('1', '1', '1', '15', '', '2020-05-09 09:50:25', '2020-05-09 09:52:56');
INSERT INTO `permission` VALUES ('2', '1', '2', '15', '', '2020-05-09 09:50:25', '2020-05-09 09:52:57');
INSERT INTO `permission` VALUES ('3', '1', '3', '15', '', '2020-05-09 09:50:25', '2020-05-09 09:52:57');
INSERT INTO `permission` VALUES ('5', '2', '1', '14', '', '2020-05-09 09:52:43', '2020-05-09 10:15:46');
INSERT INTO `permission` VALUES ('6', '2', '2', '14', '', '2020-05-09 09:52:43', '2020-05-09 10:15:47');
INSERT INTO `permission` VALUES ('7', '2', '3', '14', '', '2020-05-09 09:52:43', '2020-05-09 10:15:48');
INSERT INTO `permission` VALUES ('9', '3', '1', '0', '', '2020-05-08 20:18:45', '2020-05-26 18:24:59');
INSERT INTO `permission` VALUES ('10', '3', '2', '4', '', '2020-05-08 20:18:45', '2020-05-09 10:24:10');
INSERT INTO `permission` VALUES ('11', '3', '3', '0', '', '2020-05-08 20:18:45', '2020-05-09 10:16:36');
-- ----------------------------
-- Table structure for role
-- ----------------------------
DROP TABLE IF EXISTS `role`;
CREATE TABLE `role` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'primary key',
`name` varchar(64) NOT NULL DEFAULT '' COMMENT '角色名称',
`level` tinyint(4) NOT NULL DEFAULT '0' COMMENT '角色等级,比如超级管理员是1, 普通管理员是2, 普通用户是3等定义, 系统默认用户角色这个为4',
`remark` varchar(128) NOT NULL DEFAULT '' COMMENT '备注',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='角色表';
-- ----------------------------
-- Records of role
-- ----------------------------
INSERT INTO `role` VALUES ('1', '超级管理员', '1', '这个不允许修改,系统上线时设置,具有所有接口的所有权限', '2020-03-19 16:44:41', '2020-05-09 10:08:20');
INSERT INTO `role` VALUES ('2', '普通管理员', '2', '这个不允许修改,系统上线时设置,比超级用户少了删除权限某些特殊业务场景的编辑权限', '2020-03-19 16:44:57', '2020-05-26 15:29:53');
INSERT INTO `role` VALUES ('3', '普通用户', '3', '这个不允许修改,系统上线时设置,ldap用户第一次登录生成的系统新用户的默认角色,权限较低,只有各个工具的查看权限及提交申请使用权限,使用权限要提出申请,待管理员许可后才可使用', '2020-03-19 16:45:07', '2020-05-09 10:08:30');
-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'primary key',
`role_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '角色表ID',
`name` varchar(64) NOT NULL DEFAULT '' COMMENT '用户名称',
`alias_name` varchar(64) NOT NULL DEFAULT '' COMMENT '用户别名, 为中文',
`gender` tinyint(1) NOT NULL DEFAULT '0' COMMENT '员工性别,0表示男,1表示女',
`phone` varchar(64) NOT NULL DEFAULT '' COMMENT '用户电话号',
`email` varchar(64) NOT NULL DEFAULT '' COMMENT '用户邮箱',
`passwd` varchar(128) NOT NULL DEFAULT '' COMMENT '用户登录密码',
`init_passwd` varchar(128) NOT NULL DEFAULT '' COMMENT '系统设置的初始登录密码',
`history_passwd` varchar(2048) NOT NULL DEFAULT '' COMMENT '历史密码,多个用;号隔开',
`state` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否禁止账号登录,0表示正常, 1表示禁止',
`remark` varchar(128) NOT NULL DEFAULT '' COMMENT '备注',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
PRIMARY KEY (`id`),
KEY `role_id` (`role_id`),
CONSTRAINT `user_ibfk_1` FOREIGN KEY (`role_id`) REFERENCES `role` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='用户表';
-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('1', '1', 'wangda', 'wangda', '0', '18209517557', 'wangda@qq.com', '123456', '123456', '123456', '0', '', '2020-12-02 16:35:18', '2020-12-03 11:19:03');
INSERT INTO `user` VALUES ('2', '1', '小倩', '', '1', '18209517552', 'ZHANXIAOQIAN@qq.COM', '3398d2c533c3a774ee0cf5d65ea76d3b23e0b800', '3398d2c533c3a774ee0cf5d65ea76d3b23e0b800', '', '0', '', '2020-12-11 12:26:17', '2020-12-11 12:26:17');