11 lines
697 B
SQL
11 lines
697 B
SQL
 
|
-- Utterance-level flags: a dialogue line can AWARD an achievement when reached, and
|
||
|
|
-- an option can REQUIRE an achievement to be offered (gates player choices on prior
|
||
|
|
-- discoveries). Mirrors the merit node's award and node-enable requirements — this is
|
||
|
|
-- how asking Dobby the name grants dobby.knows_barricelli_name, and how Glitch Hunter's
|
||
|
|
-- "…a Norwegian-Italian mathematician" option only shows once you know it.
|
||
|
|
|
||
|
|
ALTER TABLE osint.utterances ADD COLUMN awards_flag TEXT
|
||
|
|
CHECK (awards_flag IS NULL OR awards_flag ~ '^[a-z][a-z0-9_.-]{0,63}$');
|
||
|
|
ALTER TABLE osint.utterances ADD COLUMN requires_flag TEXT
|
||
|
|
CHECK (requires_flag IS NULL OR requires_flag ~ '^[a-z][a-z0-9_.-]{0,63}$');
|