aboutsummaryrefslogtreecommitdiffstats
path: root/packages/db/drizzle/0011_ordinary_phalanx.sql
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
);