mirror of
https://github.com/Oreolek/aacl.git
synced 2024-04-24 21:19:35 +03:00
10 lines
314 B
SQL
10 lines
314 B
SQL
CREATE TABLE IF NOT EXISTS `aacl` (
|
|
`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
|
|
`role_id` INT(10) UNSIGNED DEFAULT NULL,
|
|
`resource` VARCHAR(255) DEFAULT NULL,
|
|
`action` VARCHAR(255) DEFAULT NULL,
|
|
`condition` VARCHAR(255) DEFAULT NULL,
|
|
PRIMARY KEY (`id`),
|
|
KEY `role_id` (`role_id`)
|
|
) ENGINE=INNODB;
|