gitprovandClaude Opus 4.8
ddb3a386f0
Introduce the narrative layer as a directed story-flow graph: an authored campaign a player walks node by node, replacing the interim slot/chapter model. Schema (migrations 015-021): - mysteries, global NPC templates + named poses, per-user playthroughs - story_nodes, terminals, utterances (the flow graph and dialogue trees) - clean cutover: retire slot cutscenes/chapters/seen_dialogue Runtime: - New Game creates a playthrough bound to the JWT identity (dev test-user fallback) - advance() walks the graph cutscene -> dialogue -> level -> ..., auto-skipping gates - branching dialogue: player choices route out through node terminals Admin authoring: - NPC editor: upload named poses to the gupi MinIO bucket - mystery graph editor: vertical node canvas, wiring, entrypoint, delete-by-click - dialogue crafter: utterance tree, Tab to add child, 1/2 speaker, undo Content authored via the manifest importer / admin panel and seeded for Glass Harbour. MinIO added to the dev stack; dev container runs in development mode. Also includes a folder-widget simplification (removes open/close) and a resolveUserId auth helper. Co-Authored-By: Claude Opus 4.8 <noreply@anthropic.com>
26 lines
1.7 KiB
SQL
26 lines
1.7 KiB
SQL
-- Utterances: the content of a dialogue node (and utterance-bearing cutscenes).
|
|
-- One table for both NPC lines and player choices, distinguished by `utterer`.
|
|
-- The intra-node conversation graph uses two self-references; `terminal_id` is the
|
|
-- exit that leaves the node via one of its output terminals. Runtime is Phase 2.
|
|
|
|
CREATE TABLE osint.utterances (
|
|
id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
|
|
node_id UUID NOT NULL REFERENCES osint.story_nodes(id) ON DELETE CASCADE,
|
|
utterer TEXT NOT NULL DEFAULT 'npc' CHECK (utterer IN ('npc','player')),
|
|
npc_id UUID REFERENCES osint.npcs(id), -- speaker for NPC lines; NULL for player choices
|
|
pose_key TEXT, -- resolved with the usual pose fallback
|
|
text TEXT NOT NULL DEFAULT '',
|
|
-- Intra-node conversation graph:
|
|
parent_utterance_id UUID REFERENCES osint.utterances(id) ON DELETE CASCADE, -- player options hang under the NPC prompt they answer
|
|
advances_to_utterance_id UUID REFERENCES osint.utterances(id) ON DELETE SET NULL, -- next line; may loop back to the same one
|
|
-- Inter-node exit:
|
|
terminal_id UUID REFERENCES osint.story_node_terminals(id) ON DELETE SET NULL,
|
|
effect TEXT, -- optional authored side-effect hook (vocabulary TBD)
|
|
xpos DOUBLE PRECISION NOT NULL DEFAULT 0, -- position in the node's utterance sub-canvas
|
|
ypos DOUBLE PRECISION NOT NULL DEFAULT 0,
|
|
sort_order INTEGER NOT NULL DEFAULT 0
|
|
);
|
|
CREATE INDEX utterances_node_idx ON osint.utterances (node_id);
|
|
|
|
COMMENT ON TABLE osint.utterances IS 'Dialogue content per story node. Same-node integrity for parent/advances_to/terminal links is enforced in the repository (Phase 1).';
|