sys_role_dept.sql 305 B

123456789
  1. create table sys_role_dept
  2. (
  3. role_id bigint not null comment '角色ID',
  4. dept_id bigint not null comment '部门ID',
  5. primary key (role_id, dept_id)
  6. )
  7. comment '角色和部门关联表';
  8. INSERT INTO ruoyi.sys_role_dept (role_id, dept_id) VALUES (1960316477504557058, 1960316477680717825);