12 lines
392 B
PL/PgSQL
12 lines
392 B
PL/PgSQL
|
BEGIN;
|
||
|
|
|
||
|
|
ALTER TABLE ops_config_evaluation
|
||
|
|
ADD COLUMN evidence_type varchar(32) NOT NULL DEFAULT 'GENERIC',
|
||
|
|
ADD CONSTRAINT ops_config_evaluation_type_check
|
||
|
|
CHECK (evidence_type IN ('GENERIC', 'AGENT_QUALITY_V1'));
|
||
|
|
|
||
|
|
CREATE INDEX ops_config_evaluation_type_result_idx
|
||
|
|
ON ops_config_evaluation(tenant_id, config_version_id, evidence_type, result, evaluated_at DESC);
|
||
|
|
|
||
|
|
COMMIT;
|