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;