25 lines
852 B
SQL
25 lines
852 B
SQL
CREATE TABLE `campaign_characters` (
|
|
`id` integer,
|
|
`character` integer,
|
|
PRIMARY KEY(`id`, `character`),
|
|
FOREIGN KEY (`id`) REFERENCES `campaign`(`id`) ON UPDATE cascade ON DELETE cascade,
|
|
FOREIGN KEY (`character`) REFERENCES `character`(`id`) ON UPDATE cascade ON DELETE cascade
|
|
);
|
|
--> statement-breakpoint
|
|
CREATE TABLE `campaign_members` (
|
|
`id` integer,
|
|
`user` integer,
|
|
`rights` text,
|
|
PRIMARY KEY(`id`, `user`),
|
|
FOREIGN KEY (`id`) REFERENCES `campaign`(`id`) ON UPDATE cascade ON DELETE cascade,
|
|
FOREIGN KEY (`user`) REFERENCES `users`(`id`) ON UPDATE cascade ON DELETE cascade
|
|
);
|
|
--> statement-breakpoint
|
|
CREATE TABLE `campaign` (
|
|
`id` integer PRIMARY KEY AUTOINCREMENT NOT NULL,
|
|
`name` text NOT NULL,
|
|
`description` text,
|
|
`owner` integer NOT NULL,
|
|
FOREIGN KEY (`owner`) REFERENCES `users`(`id`) ON UPDATE cascade ON DELETE cascade
|
|
);
|