diff options
Diffstat (limited to 'apps/web/db/prepare.sql')
| -rw-r--r-- | apps/web/db/prepare.sql | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/apps/web/db/prepare.sql b/apps/web/db/prepare.sql index a14b8e18..da9173a8 100644 --- a/apps/web/db/prepare.sql +++ b/apps/web/db/prepare.sql @@ -30,6 +30,7 @@ CREATE TABLE `storedContent` ( `title` text(255), `description` text(255), `url` text NOT NULL, + `space` text(255), `savedAt` integer NOT NULL, `baseUrl` text(255), `image` text(255) @@ -63,5 +64,6 @@ CREATE UNIQUE INDEX `storedContent_url_unique` ON `storedContent` (`url`);--> st 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 |