summaryrefslogtreecommitdiffstats
path: root/schema/mysql-legacy-changes/upgrade_40.sql
blob: 55bcbedbffb6a829605a13fe06693ce10910cb18 (plain)
1
2
3
4
5
6
7
8
9
ALTER TABLE director_deployment_log ADD COLUMN config_checksum VARBINARY(20) DEFAULT NULL AFTER config_id;
ALTER TABLE director_deployment_log DROP COLUMN config_id;
ALTER TABLE director_deployment_log ADD CONSTRAINT config_checksum
    FOREIGN KEY config_checksum (config_checksum)
    REFERENCES director_generated_config (checksum)
    ON DELETE SET NULL
    ON UPDATE RESTRICT;