39669-vm/db/migrations/20260417_add_global_template_id_to_assessment.sql
2026-04-17 14:22:06 +00:00

3 lines
293 B
SQL

ALTER TABLE center_assessment_types ADD COLUMN global_template_id INT UNSIGNED NULL AFTER cycle_id;
ALTER TABLE center_assessment_types ADD CONSTRAINT fk_center_assessment_types_global_template FOREIGN KEY (global_template_id) REFERENCES global_center_assessment_types(id) ON DELETE SET NULL;