5f8aebf5b1
All checks were successful
CI/CD / go-lint (push) Has been skipped
CI/CD / python-lint (push) Has been skipped
CI/CD / nodejs-lint (push) Has been skipped
CI/CD / test-go-ai-compliance (push) Successful in 32s
CI/CD / test-python-backend-compliance (push) Successful in 33s
CI/CD / test-python-document-crawler (push) Successful in 21s
CI/CD / test-python-dsms-gateway (push) Successful in 17s
CI/CD / validate-canonical-controls (push) Successful in 12s
CI/CD / Deploy (push) Successful in 2s
Migrations 048 and 049 reference canonical_processed_chunks and canonical_controls tables which may not exist on all environments. Wrap ALTER TABLE statements in DO blocks that check for table existence first. This unblocks migrations 050-053 on production. Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>
14 lines
660 B
SQL
14 lines
660 B
SQL
-- 049: Add target_audience field to canonical_controls
|
|
-- Distinguishes who a control is relevant for: enterprises, authorities, providers, or all.
|
|
-- Safe: only runs if the table exists (may not exist on all environments)
|
|
|
|
DO $$
|
|
BEGIN
|
|
IF EXISTS (SELECT 1 FROM information_schema.tables WHERE table_name = 'canonical_controls') THEN
|
|
ALTER TABLE canonical_controls ADD COLUMN IF NOT EXISTS
|
|
target_audience VARCHAR(20) DEFAULT NULL
|
|
CHECK (target_audience IN ('enterprise', 'authority', 'provider', 'all'));
|
|
CREATE INDEX IF NOT EXISTS idx_cc_target_audience ON canonical_controls(target_audience);
|
|
END IF;
|
|
END $$;
|