wzjgn/shiro-freemaker-springboot-redis-mysql

建表语句能提上来吗？

kittaaron opened this issue · 1 comments

kittaaron commented

您好，sql里面只有初始化数据的脚本，没有建表语句，能把建表语句提上来吗？

sunnycomes commented
  1. create table shiro_function(id int auto_increment primary key, create_time timestamp, function_name varchar(20), permission_name varchar(20), pid int);
  2. create table shiro_role(id int auto_increment primary key, create_time timestamp, role_name varchar(20));
  3. create table shiro_role_function(role_id int auto_increment primary key, function_id int);
  4. create table shiro_user(id int auto_increment primary key, create_time timestamp, password varchar(50), status varchar(10), username varchar(20));
  5. create table shiro_user_role(user_id int auto_increment primary key, role_id int);