diff options
| author | Mohamed Bassem <me@mbassem.com> | 2024-12-27 16:09:29 +0000 |
|---|---|---|
| committer | Mohamed Bassem <me@mbassem.com> | 2024-12-27 16:09:29 +0000 |
| commit | 86d74e3f32dd5bccc8df195b55391e206df9a1c4 (patch) | |
| tree | 0db92b5139f9ef0c8909c16db72fbef782b770b6 /packages/db/drizzle/0035_gorgeous_may_parker.sql | |
| parent | a23044bb74e01c861a92417c00d293ff86384e83 (diff) | |
| download | karakeep-86d74e3f32dd5bccc8df195b55391e206df9a1c4.tar.zst | |
feat: Implement highlights support for links. Fixes #620
Diffstat (limited to 'packages/db/drizzle/0035_gorgeous_may_parker.sql')
| -rw-r--r-- | packages/db/drizzle/0035_gorgeous_may_parker.sql | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/packages/db/drizzle/0035_gorgeous_may_parker.sql b/packages/db/drizzle/0035_gorgeous_may_parker.sql new file mode 100644 index 00000000..52242a43 --- /dev/null +++ b/packages/db/drizzle/0035_gorgeous_may_parker.sql @@ -0,0 +1,15 @@ +CREATE TABLE `highlights` ( + `id` text PRIMARY KEY NOT NULL, + `bookmarkId` text NOT NULL, + `userId` text NOT NULL, + `startOffset` integer NOT NULL, + `endOffset` integer NOT NULL, + `color` text DEFAULT 'yellow' NOT NULL, + `note` text, + `createdAt` integer NOT NULL, + FOREIGN KEY (`bookmarkId`) REFERENCES `bookmarks`(`id`) ON UPDATE no action ON DELETE cascade, + FOREIGN KEY (`userId`) REFERENCES `user`(`id`) ON UPDATE no action ON DELETE cascade +); +--> statement-breakpoint +CREATE INDEX `highlights_bookmarkId_idx` ON `highlights` (`bookmarkId`);--> statement-breakpoint +CREATE INDEX `highlights_userId_idx` ON `highlights` (`userId`);
\ No newline at end of file |