· 8 years ago · Jun 14, 2018, 03:22 PM
1CREATE TABLE IF NOT EXISTS `roles_users` (
2 `user_id` int(10) UNSIGNED NOT NULL,
3 `role_id` int(10) UNSIGNED NOT NULL,
4 PRIMARY KEY (`user_id`,`role_id`),
5 KEY `fk_role_id` (`role_id`)
6) ENGINE=InnoDB DEFAULT CHARSET=utf8;