CREATE TABLE `users_groups` ( `user_id` integer, `group_id` integer, PRIMARY KEY(`user_id`, `group_id`), FOREIGN KEY (`user_id`) REFERENCES `users`(`id`) ON UPDATE no action ON DELETE no action, FOREIGN KEY (`group_id`) REFERENCES `groups`(`id`) ON UPDATE no action ON DELETE no action );