migrations/0003_empty_matthew_murdock.sql


1
2
3
4
5
6
7

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
);