18 lines
665 B
PL/PgSQL
18 lines
665 B
PL/PgSQL
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;
|