diff options
| author | Dhravya <[email protected]> | 2024-04-02 18:30:53 -0700 |
|---|---|---|
| committer | Dhravya <[email protected]> | 2024-04-02 18:30:53 -0700 |
| commit | f8a917a89893612048959dd06affa435d1369302 (patch) | |
| tree | 32cab1877b64a3f53c75ab6eff62b3448b247a5a /apps/web/db/prepare.sql | |
| parent | added category support: add and search (diff) | |
| download | supermemory-f8a917a89893612048959dd06affa435d1369302.tar.xz supermemory-f8a917a89893612048959dd06affa435d1369302.zip | |
added category support in d1 db, changed schema
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..bca149c2 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, + `category` 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_category_idx` ON `storedContent` (`category`);--> 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 |