BEGIN;

SET ROLE epistemics_role;

ALTER TABLE epistemics.experience_records
    ADD COLUMN IF NOT EXISTS principal_id TEXT NOT NULL DEFAULT '',
    ADD COLUMN IF NOT EXISTS context_scope_ref TEXT NOT NULL DEFAULT '',
    ADD COLUMN IF NOT EXISTS problem_statement TEXT NOT NULL DEFAULT '',
    ADD COLUMN IF NOT EXISTS applicability_conditions TEXT[] NOT NULL DEFAULT ARRAY[]::TEXT[],
    ADD COLUMN IF NOT EXISTS why_succeeded_or_failed TEXT NOT NULL DEFAULT '';

CREATE INDEX IF NOT EXISTS experience_records_principal_scope_recorded_idx
    ON epistemics.experience_records (principal_id, context_scope_ref, recorded_at_unix_millis DESC);

RESET ROLE;

COMMIT;