mirror of
https://github.com/chylex/Lightning-Tracker.git
synced 2024-12-22 14:42:46 +01:00
21 lines
493 B
SQL
21 lines
493 B
SQL
CREATE TABLE IF NOT EXISTS `system_role_perms` (
|
|
`role_id` SMALLINT NOT NULL,
|
|
`permission` ENUM (
|
|
'settings',
|
|
'trackers.list',
|
|
'trackers.list.hidden',
|
|
'trackers.add',
|
|
'trackers.edit',
|
|
'users.list',
|
|
'users.list.email',
|
|
'users.add',
|
|
'users.edit') NOT NULL,
|
|
PRIMARY KEY (`role_id`, `permission`),
|
|
FOREIGN KEY (`role_id`)
|
|
REFERENCES `system_roles` (`id`)
|
|
ON UPDATE CASCADE
|
|
ON DELETE CASCADE
|
|
) ENGINE = InnoDB
|
|
DEFAULT CHARSET = utf8mb4
|
|
COLLATE utf8mb4_general_ci
|