xt-laravel-admin/database/sql/admin_permission_role.sql
2018-12-16 11:38:44 +08:00

6 lines
255 B
SQL

CREATE TABLE `admin_permission_role` (
`permission_id` int(10) unsigned NOT NULL,
`role_id` int(10) unsigned NOT NULL,
PRIMARY KEY (`permission_id`,`role_id`),
KEY `permission_role_role_id_foreign` (`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;