CREATE TABLE actions (
id TEXT PRIMARY KEY,
type TEXT NOT NULL,
params TEXT NOT NULL,
tier TEXT NOT NULL CHECK (tier IN ('T0','T1','T2','T3')),
status TEXT NOT NULL CHECK (status IN ('queued','needs_approval','approved','executing','applied','failed','cancelled')),
idempotency_key TEXT NOT NULL,
episode_id TEXT,
proposal_id TEXT,
updated_at TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ','now')),
applied_at TEXT,
created_at TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ','now')),
FOREIGN KEY (episode_id) REFERENCES episodes(id) ON DELETE SET NULL DEFERRABLE INITIALLY DEFERRED
)