Skip to main content

max / makenotwork

805 B · 16 lines History Blame Raw
1 -- The theme a creator's own SSH console (mnw-cli) renders in.
2 --
3 -- Distinct from users.theme_id, which is the palette *visitors* see on the
4 -- public profile page. This one is the creator's private chrome, so the two
5 -- are free to differ and the profile column cannot stand in for it.
6 --
7 -- Holds a makeover ThemeSelection string: a bundled theme id, or the literal
8 -- 'system' to follow the terminal's ambient light/dark. NULL means the creator
9 -- has never chosen, which resolves to the same behaviour as 'system' but stays
10 -- distinguishable from having chosen it. Validated app-side against makeover's
11 -- embedded registry, so no FK; the length cap is a defensive backstop.
12
13 ALTER TABLE users
14 ADD COLUMN console_theme TEXT
15 CHECK (console_theme IS NULL OR char_length(console_theme) <= 64);
16