BEGIN;
CREATE TABLE IF NOT EXISTS mcp_recovery_intents (
 operation_id uuid PRIMARY KEY REFERENCES mcp_operations(id), state text NOT NULL,
 authority_profile_id uuid NOT NULL REFERENCES mcp_routing_profiles(id),
 created_at timestamptz NOT NULL DEFAULT now(), finished_at timestamptz
);
COMMIT;