24 lines
945 B
PL/PgSQL
24 lines
945 B
PL/PgSQL
BEGIN;
|
|
|
|
SET ROLE work_role;
|
|
|
|
ALTER TABLE work.agent_dispatch_intents
|
|
ADD COLUMN IF NOT EXISTS specialist_purpose TEXT NOT NULL DEFAULT '',
|
|
ADD COLUMN IF NOT EXISTS task_evaluation_profile_id TEXT NOT NULL DEFAULT '',
|
|
ADD COLUMN IF NOT EXISTS task_evaluation_binding_id TEXT NOT NULL DEFAULT '',
|
|
ADD COLUMN IF NOT EXISTS task_evaluation_case_ids TEXT[] NOT NULL DEFAULT '{}';
|
|
|
|
ALTER TABLE work.graphs
|
|
ADD COLUMN IF NOT EXISTS parent_graph_id TEXT NOT NULL DEFAULT '',
|
|
ADD COLUMN IF NOT EXISTS parent_graph_revision BIGINT NOT NULL DEFAULT 0,
|
|
ADD COLUMN IF NOT EXISTS trigger_evidence_ref TEXT NOT NULL DEFAULT '';
|
|
|
|
ALTER TABLE work.graph_nodes
|
|
ADD COLUMN IF NOT EXISTS purpose TEXT NOT NULL DEFAULT 'GENERIC',
|
|
ADD COLUMN IF NOT EXISTS task_profile_id TEXT NOT NULL DEFAULT '',
|
|
ADD COLUMN IF NOT EXISTS binding_id TEXT NOT NULL DEFAULT '',
|
|
ADD COLUMN IF NOT EXISTS case_ids TEXT[] NOT NULL DEFAULT '{}';
|
|
|
|
RESET ROLE;
|
|
COMMIT;
|