CREATE TABLE `admin_role_user` ( `user_id` int(10) unsigned NOT NULL, `role_id` int(10) unsigned NOT NULL, PRIMARY KEY (`user_id`,`role_id`), KEY `role_user_role_id_foreign` (`role_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;