-- 000019_reasoning_mode_state: actor-scoped /think state and -- per-turn idempotency for successful reasoning-mode completions. CREATE TABLE IF NOT EXISTS reasoning_mode_states ( tenant_key TEXT NOT NULL, channel TEXT NOT NULL, external_actor_id TEXT NOT NULL, mode TEXT NOT NULL DEFAULT 'quick' CHECK (mode IN ('quick', 'reasoning')), max_rounds INTEGER NOT NULL DEFAULT 10 CHECK (max_rounds BETWEEN 1 AND 50), rounds_used INTEGER NOT NULL DEFAULT 0 CHECK (rounds_used >= 0 AND rounds_used <= max_rounds), hint_enabled BOOLEAN NOT NULL DEFAULT TRUE, last_activity_at TIMESTAMPTZ, expires_at TIMESTAMPTZ, onboarding_shown_at TIMESTAMPTZ, updated_at TIMESTAMPTZ NOT NULL DEFAULT NOW(), PRIMARY KEY (tenant_key, channel, external_actor_id) ); CREATE INDEX IF NOT EXISTS idx_reasoning_mode_states_expiry ON reasoning_mode_states (expires_at) WHERE mode = 'reasoning' AND expires_at IS NOT NULL; CREATE TABLE IF NOT EXISTS reasoning_mode_turns ( id TEXT PRIMARY KEY, tenant_key TEXT NOT NULL, channel TEXT NOT NULL, turn_id TEXT NOT NULL REFERENCES turns(id), external_actor_id TEXT NOT NULL, execution_mode TEXT NOT NULL CHECK (execution_mode IN ('quick', 'reasoning', 'reasoning_single')), round_number INTEGER NOT NULL DEFAULT 0 CHECK (round_number >= 0), showed_hint BOOLEAN NOT NULL DEFAULT FALSE, auto_closed BOOLEAN NOT NULL DEFAULT FALSE, showed_onboarding BOOLEAN NOT NULL DEFAULT FALSE, created_at TIMESTAMPTZ NOT NULL DEFAULT NOW(), UNIQUE (tenant_key, channel, turn_id) ); CREATE INDEX IF NOT EXISTS idx_reasoning_mode_turns_actor_created ON reasoning_mode_turns (tenant_key, channel, external_actor_id, created_at DESC);