refactor: Include userId in the assets table

1 files changed, 14 insertions, 0 deletions

diff --git a/packages/db/drizzle/0029_short_gunslinger.sql b/packages/db/drizzle/0029_short_gunslinger.sql
new file mode 100644
index 00000000..7913fb68
--- /dev/null
+++ b/packages/db/drizzle/0029_short_gunslinger.sql
@@ -0,0 +1,14 @@
+CREATE TABLE `assets_new` (
+        `id` text PRIMARY KEY NOT NULL,
+        `assetType` text NOT NULL,
+        `bookmarkId` text,
+		`userId` text 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
+INSERT INTO `assets_new` (`id`, `assetType`, `bookmarkId`, `userId`) SELECT `id`, `assetType`, `bookmarkId`, (select `bookmarks`.`userId` from `bookmarks` where `bookmarks`.`id` = `assets`.`bookmarkId`) FROM `assets`;--> statement-breakpoint
+DROP TABLE `assets`;--> statement-breakpoint
+ALTER TABLE `assets_new` RENAME TO `assets`;--> statement-breakpoint
+CREATE INDEX `assets_bookmarkId_idx` ON `assets` (`bookmarkId`);--> statement-breakpoint
+CREATE INDEX `assets_assetType_idx` ON `assets` (`assetType`);--> statement-breakpoint
+CREATE INDEX `assets_userId_idx` ON `assets` (`userId`);