9 lines
575 B
SQL
9 lines
575 B
SQL
CREATE TABLE `simulation_role_permission` (
|
||
`id` int NOT NULL AUTO_INCREMENT,
|
||
`roleId` bigint NOT NULL COMMENT '角色id（对应CID）',
|
||
`permissionCode` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '菜单权限编码',
|
||
`tenantId` bigint NOT NULL DEFAULT '0' COMMENT '租户ID',
|
||
`creator` bigint NOT NULL DEFAULT '0' COMMENT '创建者ID',
|
||
`createTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
PRIMARY KEY (`id`)
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='角色菜单权限表'; |