diff options
| author | Dhravya <[email protected]> | 2024-04-03 00:14:07 -0700 |
|---|---|---|
| committer | Dhravya <[email protected]> | 2024-04-03 00:14:07 -0700 |
| commit | 4ff97a09049bdf755146db1699eb534270e01ff4 (patch) | |
| tree | 47744225a3c8a5ef2366a75197805e2f6092ff48 /apps/web/db/prepare.sql | |
| parent | Merge branch 'new-ui' of https://github.com/Dhravya/supermemory into new-ui (diff) | |
| parent | change 'categories' to 'spaces' (diff) | |
| download | archived-supermemory-4ff97a09049bdf755146db1699eb534270e01ff4.tar.xz archived-supermemory-4ff97a09049bdf755146db1699eb534270e01ff4.zip | |
update: catch up with main
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 |