1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
|
CREATE TABLE `assets` (
`id` text PRIMARY KEY NOT NULL,
`assetType` text NOT NULL,
`bookmarkId` text NOT NULL,
FOREIGN KEY (`bookmarkId`) REFERENCES `bookmarks`(`id`) ON UPDATE no action ON DELETE cascade
);
--> statement-breakpoint
CREATE INDEX `assets_bookmarkId_idx` ON `assets` (`bookmarkId`);
--> statement-breakpoint
CREATE INDEX `assets_assetType_idx` ON `assets` (`assetType`);
--> statement-breakpoint
INSERT INTO `assets` (`id`, `assetType`, `bookmarkId`)
SELECT `screenshotAssetId`, 'linkScreenshot', `id`
FROM `bookmarkLinks`
WHERE screenshotAssetId IS NOT NULL;
--> statement-breakpoint
INSERT INTO `assets` (`id`, `assetType`, `bookmarkId`)
SELECT `fullPageArchiveAssetId`, 'linkFullPageArchive', `id`
FROM `bookmarkLinks`
WHERE `fullPageArchiveAssetId` IS NOT NULL;
--> statement-breakpoint
INSERT INTO `assets` (`id`, `assetType`, `bookmarkId`)
SELECT `imageAssetId`, 'linkBannerImage', `id`
FROM `bookmarkLinks`
WHERE `imageAssetId` IS NOT NULL;
--> statement-breakpoint
ALTER TABLE `bookmarkLinks` DROP COLUMN `screenshotAssetId`;
--> statement-breakpoint
ALTER TABLE `bookmarkLinks` DROP COLUMN `fullPageArchiveAssetId`;
--> statement-breakpoint
ALTER TABLE `bookmarkLinks` DROP COLUMN `imageAssetId`;
|
