max / makenotwork

607 B · 14 lines History Blame Raw

1	-- Tier 0 creator theming: a creator picks a built-in theme for their public
2	-- profile and for each project. NULL means the platform default (mnw-default).
3	-- The id references a bundled theme-common theme (shared/themes/*.toml); it is
4	-- validated app-side against the embedded registry before write, so no FK here.
5	-- The length cap is a defensive backstop against oversized values.
6
7	ALTER TABLE users
8	ADD COLUMN theme_id TEXT
9	CHECK (theme_id IS NULL OR char_length(theme_id) <= 64);
10
11	ALTER TABLE projects
12	ADD COLUMN theme_id TEXT
13	CHECK (theme_id IS NULL OR char_length(theme_id) <= 64);
14