Advertisement
Guest User

Untitled

a guest
Nov 7th, 2013
48
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.53 KB | None | 0 0
  1. CREATE TABLE `rbac_default_permissions` (
  2. `secId` INT(10) UNSIGNED NOT NULL COMMENT 'Security Level id',
  3. `permissionId` INT(10) UNSIGNED NOT NULL COMMENT 'permission id',
  4. PRIMARY KEY (`secId`, `permissionId`),
  5. INDEX `fk__rbac_default_permissions__rbac_permissions` (`permissionId`),
  6. CONSTRAINT `fk__rbac_default_permissions__rbac_permissions` FOREIGN KEY (`permissionId`) REFERENCES `rbac_permissions` (`id`)
  7. )
  8. COMMENT='Default permission to assign to different account security levels'
  9. COLLATE='utf8_general_ci'
  10. ENGINE=InnoDB;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement