CREATE TABLE `rbac_account_permissions` (
	`accountId` INT(10) UNSIGNED NOT NULL COMMENT 'Account id',
	`permissionId` INT(10) UNSIGNED NOT NULL COMMENT 'Permission id',
	`granted` TINYINT(1) NOT NULL DEFAULT '1' COMMENT 'Granted = 1, Denied = 0',
	`realmId` INT(11) NOT NULL DEFAULT '-1' COMMENT 'Realm Id, -1 means all',
	PRIMARY KEY (`accountId`, `permissionId`, `realmId`),
	INDEX `fk__rbac_account_roles__rbac_permissions` (`permissionId`),
	CONSTRAINT `fk__rbac_account_permissions__account` FOREIGN KEY (`accountId`) REFERENCES `account` (`id`) ON DELETE CASCADE,
	CONSTRAINT `fk__rbac_account_roles__rbac_permissions` FOREIGN KEY (`permissionId`) REFERENCES `rbac_permissions` (`id`) ON DELETE CASCADE
)
COMMENT='Account-Permission relation'
COLLATE='utf8_general_ci'
ENGINE=InnoDB;