20 lines
1017 B
PL/PgSQL
20 lines
1017 B
PL/PgSQL
|
BEGIN;
|
||
|
|
|
||
|
|
ALTER TABLE integration_issue
|
||
|
|
ADD COLUMN severity varchar(16) NOT NULL DEFAULT 'MEDIUM',
|
||
|
|
ADD COLUMN root_cause varchar(4000),
|
||
|
|
ADD COLUMN fixed_version varchar(128),
|
||
|
|
ADD COLUMN regression_evidence varchar(4000),
|
||
|
|
ADD CONSTRAINT integration_issue_severity_check
|
||
|
|
CHECK (severity IN ('LOW','MEDIUM','HIGH','CRITICAL'));
|
||
|
|
|
||
|
|
CREATE INDEX integration_issue_tenant_severity_status_idx
|
||
|
|
ON integration_issue (tenant_id, severity, status, updated_at DESC, id DESC);
|
||
|
|
|
||
|
|
COMMENT ON COLUMN integration_issue.severity IS 'Acceptance severity used by the release-blocking summary.';
|
||
|
|
COMMENT ON COLUMN integration_issue.root_cause IS 'Root-cause conclusion; must not contain transcript, recording content, credentials, or signed URLs.';
|
||
|
|
COMMENT ON COLUMN integration_issue.fixed_version IS 'Candidate version or immutable build identifier containing the fix.';
|
||
|
|
COMMENT ON COLUMN integration_issue.regression_evidence IS 'Deidentified evidence references and repeatable regression result.';
|
||
|
|
|
||
|
|
COMMIT;
|