diff options
| author | MohamedBassem <me@mbassem.com> | 2024-10-06 14:33:40 +0000 |
|---|---|---|
| committer | MohamedBassem <me@mbassem.com> | 2024-10-06 15:51:45 +0000 |
| commit | 1e5c575e16c8a9e6bd7592e83bea53af7f359e15 (patch) | |
| tree | d706b7d0dad309e1c4e5ede15fcae8a5e2547c8a /packages/db/drizzle/0030_blue_synch.sql | |
| parent | db2d346cd6c265d8e7c69383c6de03bf5f6252f0 (diff) | |
| download | karakeep-1e5c575e16c8a9e6bd7592e83bea53af7f359e15.tar.zst | |
refactor: Start tracking bookmark assets in the assets table
Diffstat (limited to 'packages/db/drizzle/0030_blue_synch.sql')
| -rw-r--r-- | packages/db/drizzle/0030_blue_synch.sql | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/packages/db/drizzle/0030_blue_synch.sql b/packages/db/drizzle/0030_blue_synch.sql new file mode 100644 index 00000000..9b1bac33 --- /dev/null +++ b/packages/db/drizzle/0030_blue_synch.sql @@ -0,0 +1,12 @@ +ALTER TABLE `assets` ADD `size` integer DEFAULT 0 NOT NULL;--> statement-breakpoint +ALTER TABLE `assets` ADD `contentType` text;--> statement-breakpoint +ALTER TABLE `assets` ADD `fileName` text;--> statement-breakpoint +INSERT INTO `assets` (`id`, `assetType`, `bookmarkId`, `userId`, `fileName`) + SELECT + `bookmarkAssets`.`assetId`, + 'bookmarkAsset', + `bookmarkAssets`.`id`, + (SELECT `bookmarks`.`userId` FROM `bookmarks` WHERE `bookmarks`.`id` = `bookmarkAssets`.`id`), + `bookmarkAssets`.`fileName` + FROM `bookmarkAssets`; + |