diff options
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`; + |