| 123456789101112131415161718192021222324252627282930313233343536373839404142434445 |
- drop table if exists it_user;
- CREATE TABLE `it_user`
- (
- `user_id` BIGINT(20) NOT NULL AUTO_INCREMENT COMMENT '用户ID',
- `user` VARCHAR(255) NOT NULL COMMENT '用户名',
- `display_name` VARCHAR(255) NOT NULL COMMENT '显示名称',
- `password` VARCHAR(255) NOT NULL COMMENT '密码',
- `phone_number` VARCHAR(255) NOT NULL COMMENT '手机号码',
- `role_id` BIGINT NOT NULL DEFAULT 0 COMMENT '角色ID',
- PRIMARY KEY (`user_id`)
- ) COMMENT ='用户表';
- drop table if exists it_permission;
- # CREATE TABLE `it_permission`
- # (
- # `permission_id` BIGINT NOT NULL AUTO_INCREMENT COMMENT '权限ID',
- # `name` VARCHAR(255) NOT NULL COMMENT '权限名称',
- # `permissions` VARCHAR(255) NOT NULL COMMENT '权限',
- # PRIMARY KEY (`permission_id`)
- # ) COMMENT ='权限表';
- drop table if exists it_role;
- CREATE TABLE `it_role`
- (
- `role_id` BIGINT NOT NULL COMMENT '角色ID',
- `name` VARCHAR(255) NOT NULL COMMENT '角色名称',
- PRIMARY KEY (`role_id`)
- ) COMMENT ='角色表';
- drop table if exists it_sys;
- CREATE TABLE `it_sys`
- (
- `sys_id` BIGINT(20) NOT NULL COMMENT '系统ID',
- `name` VARCHAR(255) NULL DEFAULT NULL COMMENT '系统名称',
- PRIMARY KEY (`sys_id`) USING BTREE
- ) COMMENT ='系统表';
- drop table if exists it_role_permission;
- CREATE TABLE `it_role_permission`
- (
- `role_id` BIGINT(20) NOT NULL COMMENT '角色ID',
- `sys_id` BIGINT(20) NOT NULL COMMENT '系统ID',
- PRIMARY KEY (`role_id`, `sys_id`)
- ) COMMENT ='角色权限表';
|