blob: 9b1bac3350e491fe4cb1617e0a1a21cfddfe371b (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
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`;
|
