plugin.sql.rbac.R_USER_ROLE.sql Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of zero-rbac Show documentation

There is a newer version: 0.9.0

-- liquibase formatted sql

-- changeset Lang:ox-user-role-1
-- 关联表：R_USER_ROLE
DROP TABLE IF EXISTS R_USER_ROLE;
CREATE TABLE IF NOT EXISTS R_USER_ROLE
(
    `USER_ID`  VARCHAR(36) COMMENT '「userId」- 关联用户ID',
    `ROLE_ID`  VARCHAR(36) COMMENT '「roleId」- 关联角色ID',
    `PRIORITY` INTEGER COMMENT '「priority」- 角色优先级',
    PRIMARY KEY (`USER_ID`, `ROLE_ID`)
);