forked from BRETT/BRETT
16 lines
894 B
SQL
16 lines
894 B
SQL
CREATE TABLE `permissions` (
|
|
`id` bigint unsigned AUTO_INCREMENT NOT NULL,
|
|
`key` varchar(50) NOT NULL,
|
|
`label` varchar(255) NOT NULL,
|
|
CONSTRAINT `permissions_id` PRIMARY KEY(`id`),
|
|
CONSTRAINT `permissions_key_unique` UNIQUE(`key`)
|
|
);
|
|
--> statement-breakpoint
|
|
CREATE TABLE `role_permissions` (
|
|
`role_id` bigint unsigned NOT NULL,
|
|
`permission_id` bigint unsigned NOT NULL,
|
|
CONSTRAINT `role_permissions_role_id_permission_id_pk` PRIMARY KEY(`role_id`,`permission_id`)
|
|
);
|
|
--> statement-breakpoint
|
|
ALTER TABLE `role_permissions` ADD CONSTRAINT `role_permissions_role_id_roles_id_fk` FOREIGN KEY (`role_id`) REFERENCES `roles`(`id`) ON DELETE cascade ON UPDATE no action;--> statement-breakpoint
|
|
ALTER TABLE `role_permissions` ADD CONSTRAINT `role_permissions_permission_id_permissions_id_fk` FOREIGN KEY (`permission_id`) REFERENCES `permissions`(`id`) ON DELETE cascade ON UPDATE no action; |