back_sql.sql 922 B

12345678910111213141516171819202122
  1. create table permissions_list_tab (
  2. id int not null auto_increment COMMENT '唯一id',
  3. permissions_name varchar(1024) not null COMMENT '权限名字',
  4. permissions_describe varchar(1024) not null COMMENT '权限描述',
  5. create_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  6. info JSON COMMENT '详情',
  7. primary key (id));
  8. create table group_list_tab (
  9. id int not null auto_increment COMMENT '唯一id',
  10. group_name varchar(1024) not null COMMENT '部门名字',
  11. group_describe varchar(1024) not null COMMENT '部门描述',
  12. create_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  13. info JSON COMMENT '详情',
  14. primary key (id));
  15. create table classification_list_tab (
  16. id int not null auto_increment COMMENT '唯一id',
  17. create_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  18. info JSON COMMENT '详情',
  19. self_id int not NULL,
  20. primary key (id));