diff options
| author | Dhravya <[email protected]> | 2024-07-01 07:55:16 -0500 |
|---|---|---|
| committer | Dhravya <[email protected]> | 2024-07-01 07:55:16 -0500 |
| commit | b00dbd46476636fea1f48bf5164136e3bf217349 (patch) | |
| tree | 2403fd1c546dd6fc0b94e5d72f6fb313e855a7f7 /apps/web/migrations/0003_solid_boom_boom.sql | |
| parent | merge conflicts (diff) | |
| download | supermemory-dev.tar.xz supermemory-dev.zip | |
minor changes in extensiondev
Diffstat (limited to 'apps/web/migrations/0003_solid_boom_boom.sql')
| -rw-r--r-- | apps/web/migrations/0003_solid_boom_boom.sql | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/apps/web/migrations/0003_solid_boom_boom.sql b/apps/web/migrations/0003_solid_boom_boom.sql new file mode 100644 index 00000000..da4aa94b --- /dev/null +++ b/apps/web/migrations/0003_solid_boom_boom.sql @@ -0,0 +1,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`);
\ No newline at end of file |