Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE `rbac_linked_permissions` (
- `id` INT(10) UNSIGNED NOT NULL COMMENT 'Permission id',
- `linkedId` INT(10) UNSIGNED NOT NULL COMMENT 'Linked Permission id',
- PRIMARY KEY (`id`, `linkedId`),
- INDEX `fk__rbac_linked_permissions__rbac_permissions1` (`id`),
- INDEX `fk__rbac_linked_permissions__rbac_permissions2` (`linkedId`),
- CONSTRAINT `fk__rbac_linked_permissions__rbac_permissions1` FOREIGN KEY (`id`) REFERENCES `rbac_permissions` (`id`) ON DELETE CASCADE,
- CONSTRAINT `fk__rbac_linked_permissions__rbac_permissions2` FOREIGN KEY (`linkedId`) REFERENCES `rbac_permissions` (`id`) ON DELETE CASCADE
- )
- COMMENT='Permission - Linked Permission relation'
- COLLATE='utf8_general_ci'
- ENGINE=InnoDB;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement