diff options
| author | Yash <[email protected]> | 2024-04-05 08:27:54 +0000 |
|---|---|---|
| committer | Yash <[email protected]> | 2024-04-05 08:27:54 +0000 |
| commit | 97988798bdc8b225ec6dbe7b0a725bfde6059157 (patch) | |
| tree | 3b673f17600332f36747f381b1ad83acb7baff9a /apps/web/db/prepare.sql | |
| parent | context added (diff) | |
| parent | make ext work with dev mode (diff) | |
| download | supermemory-97988798bdc8b225ec6dbe7b0a725bfde6059157.tar.xz supermemory-97988798bdc8b225ec6dbe7b0a725bfde6059157.zip | |
Merge branch 'new-ui' of https://github.com/Dhravya/supermemory into new-ui
Diffstat (limited to 'apps/web/db/prepare.sql')
| -rw-r--r-- | apps/web/db/prepare.sql | 25 |
1 files changed, 13 insertions, 12 deletions
diff --git a/apps/web/db/prepare.sql b/apps/web/db/prepare.sql index da9173a8..62cba941 100644 --- a/apps/web/db/prepare.sql +++ b/apps/web/db/prepare.sql @@ -24,23 +24,25 @@ CREATE TABLE `session` ( FOREIGN KEY (`userId`) REFERENCES `user`(`id`) ON UPDATE no action ON DELETE no action ); --> statement-breakpoint +CREATE TABLE `spaces` ( + `id` integer PRIMARY KEY AUTOINCREMENT NOT NULL, + `name` text DEFAULT 'all' NOT NULL, + `description` text(255) +); +--> statement-breakpoint CREATE TABLE `storedContent` ( `id` integer PRIMARY KEY AUTOINCREMENT NOT NULL, `content` text NOT NULL, `title` text(255), `description` text(255), `url` text NOT NULL, - `space` text(255), + `space` text(255) DEFAULT 'all', `savedAt` integer NOT NULL, `baseUrl` text(255), - `image` text(255) -); ---> statement-breakpoint -CREATE TABLE `userStoredContent` ( - `userId` text NOT NULL, - `contentId` integer NOT NULL, - FOREIGN KEY (`userId`) REFERENCES `user`(`id`) ON UPDATE no action ON DELETE no action, - FOREIGN KEY (`contentId`) REFERENCES `storedContent`(`id`) ON UPDATE no action ON DELETE no action + `image` text(255), + `user` text(255), + FOREIGN KEY (`space`) REFERENCES `spaces`(`name`) ON UPDATE no action ON DELETE no action, + FOREIGN KEY (`user`) REFERENCES `user`(`id`) ON UPDATE no action ON DELETE no action ); --> statement-breakpoint CREATE TABLE `user` ( @@ -60,10 +62,9 @@ CREATE TABLE `verificationToken` ( --> statement-breakpoint CREATE INDEX `account_userId_idx` ON `account` (`userId`);--> statement-breakpoint CREATE INDEX `session_userId_idx` ON `session` (`userId`);--> statement-breakpoint -CREATE UNIQUE INDEX `storedContent_url_unique` ON `storedContent` (`url`);--> statement-breakpoint +CREATE INDEX `spaces_name_idx` ON `spaces` (`name`);--> statement-breakpoint CREATE INDEX `storedContent_url_idx` ON `storedContent` (`url`);--> statement-breakpoint CREATE INDEX `storedContent_savedAt_idx` ON `storedContent` (`savedAt`);--> statement-breakpoint CREATE INDEX `storedContent_title_idx` ON `storedContent` (`title`);--> statement-breakpoint CREATE INDEX `storedContent_space_idx` ON `storedContent` (`space`);--> statement-breakpoint -CREATE INDEX `userStoredContent_idx` ON `userStoredContent` (`userId`,`contentId`);--> statement-breakpoint -CREATE UNIQUE INDEX `unique_user_content` ON `userStoredContent` (`userId`,`contentId`);
\ No newline at end of file +CREATE INDEX `storedContent_user_idx` ON `storedContent` (`user`);
\ No newline at end of file |