9 lines
279 B
SQL
9 lines
279 B
SQL
CREATE TABLE sys_role_permission
|
|
(
|
|
role_id INTEGER NOT NULL,
|
|
permission_id INTEGER NOT NULL,
|
|
PRIMARY KEY (role_id, permission_id)
|
|
);
|
|
|
|
COMMENT ON COLUMN sys_role_permission.role_id IS '角色id';
|
|
COMMENT ON COLUMN sys_role_permission.permission_id IS '权限id'; |