schema/pgsql-migrations/upgrade_96.sql


1
2
3
4
5
6
7

CREATE TYPE enum_host_service AS ENUM('host', 'service');

ALTER TABLE icinga_notification ADD apply_to enum_host_service NULL DEFAULT NULL;

INSERT INTO director_schema_migration
  (schema_version, migration_time)
  VALUES (96, NOW());