Advertisement
Guest User

Untitled

a guest
Nov 7th, 2013
9
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.70 KB | None | 0 0
  1. CREATE TABLE `rbac_linked_permissions` (
  2. `id` INT(10) UNSIGNED NOT NULL COMMENT 'Permission id',
  3. `linkedId` INT(10) UNSIGNED NOT NULL COMMENT 'Linked Permission id',
  4. PRIMARY KEY (`id`, `linkedId`),
  5. INDEX `fk__rbac_linked_permissions__rbac_permissions1` (`id`),
  6. INDEX `fk__rbac_linked_permissions__rbac_permissions2` (`linkedId`),
  7. CONSTRAINT `fk__rbac_linked_permissions__rbac_permissions1` FOREIGN KEY (`id`) REFERENCES `rbac_permissions` (`id`) ON DELETE CASCADE,
  8. CONSTRAINT `fk__rbac_linked_permissions__rbac_permissions2` FOREIGN KEY (`linkedId`) REFERENCES `rbac_permissions` (`id`) ON DELETE CASCADE
  9. )
  10. COMMENT='Permission - Linked Permission relation'
  11. COLLATE='utf8_general_ci'
  12. ENGINE=InnoDB;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement