blob: da4aa94b0f678a697e00e3c4a3d5ec8bc96a46b2 (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
|
CREATE TABLE `canvas` (
`id` text PRIMARY KEY NOT NULL,
`title` text DEFAULT 'Untitled' NOT NULL,
`description` text DEFAULT 'Untitled' NOT NULL,
`url` text DEFAULT '' NOT NULL,
`userId` text NOT NULL,
FOREIGN KEY (`userId`) REFERENCES `user`(`id`) ON UPDATE no action ON DELETE cascade
);
--> statement-breakpoint
CREATE INDEX `canvas_user_userId` ON `canvas` (`userId`);
|