mirror of
https://github.com/Icinga/icingaweb2-module-director.git
synced 2026-05-28 04:35:53 -04:00
9 lines
384 B
SQL
9 lines
384 B
SQL
|
|
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;
|
|
|