max / makenotwork
| 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 | users |
| 8 | ADD COLUMN theme_id TEXT |
| 9 | CHECK (theme_id IS NULL OR char_length(theme_id) <= 64); |
| 10 | |
| 11 | projects |
| 12 | ADD COLUMN theme_id TEXT |
| 13 | CHECK (theme_id IS NULL OR char_length(theme_id) <= 64); |
| 14 |