Skip to content

A self-hostable bookmark-everything app (links, notes and images) with AI-based automatic tagging and full text search

804 B
Raw Blame
CREATE TABLE `userReadingProgress` (
	`id` text PRIMARY KEY NOT NULL,
	`bookmarkId` text NOT NULL,
	`userId` text NOT NULL,
	`readingProgressOffset` integer NOT NULL,
	`readingProgressAnchor` text,
	`readingProgressPercent` integer,
	`modifiedAt` integer,
	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 `userReadingProgress_bookmarkId_idx` ON `userReadingProgress` (`bookmarkId`);--> statement-breakpoint
CREATE INDEX `userReadingProgress_userId_idx` ON `userReadingProgress` (`userId`);--> statement-breakpoint
CREATE UNIQUE INDEX `userReadingProgress_bookmarkId_userId_unique` ON `userReadingProgress` (`bookmarkId`,`userId`);