blob: c6540d2040505f052b09f92ed43130b6c3e7169f (
plain) (
blame)
1
2
3
4
5
6
7
|
CREATE TABLE `bookmarkAssets` (
`id` text PRIMARY KEY NOT NULL,
`assetType` text NOT NULL,
`assetId` text NOT NULL,
FOREIGN KEY (`id`) REFERENCES `bookmarks`(`id`) ON UPDATE no action ON DELETE cascade,
FOREIGN KEY (`assetId`) REFERENCES `assets`(`id`) ON UPDATE no action ON DELETE cascade
);
|