sys_user_role.sql 983 B

12345678910111213141516
  1. create table sys_user_role
  2. (
  3. user_id bigint not null comment '用户ID',
  4. role_id bigint not null comment '角色ID',
  5. primary key (user_id, role_id)
  6. )
  7. comment '用户和角色关联表';
  8. INSERT INTO ruoyi.sys_user_role (user_id, role_id) VALUES (1, 1);
  9. INSERT INTO ruoyi.sys_user_role (user_id, role_id) VALUES (1959974023941099522, 1959973642972467201);
  10. INSERT INTO ruoyi.sys_user_role (user_id, role_id) VALUES (1959974153628979201, 1959973751676243970);
  11. INSERT INTO ruoyi.sys_user_role (user_id, role_id) VALUES (1959974270645866497, 1959973862762385409);
  12. INSERT INTO ruoyi.sys_user_role (user_id, role_id) VALUES (1959976407979298818, 1959976407475982337);
  13. INSERT INTO ruoyi.sys_user_role (user_id, role_id) VALUES (1960316478058205186, 1960316477504557058);
  14. INSERT INTO ruoyi.sys_user_role (user_id, role_id) VALUES (1960318326831910913, 1960317682385489921);
  15. INSERT INTO ruoyi.sys_user_role (user_id, role_id) VALUES (1970144018062905346, 1970143865193107458);