CREATE TABLE `users_roles` ( `users_id` int, `roles_id` int, `` varchar(255), FOREIGN KEY(`users_id`) REFERENCES `users` (`id`), FOREIGN KEY(`roles_id`) REFERENCES `roles` (`id`) ); CREATE TABLE `roles` ( `id` int PRIMARY KEY, `name` varchar(255) ); CREATE TABLE `users` ( `id` int PRIMARY KEY, `name` varchar(255) );