CREATE TABLE `users` ( `id` int, `role_id` int, `display_name` varchar(255), `email` varchar(255), `password` varchar(255) ); CREATE TABLE `rights` ( `id` int ); CREATE TABLE `roles` ( `id` int, `name` varchar(255), `description` varchar(255) ); CREATE TABLE `roles_rights` ( `right_id` int, `role_id` int );