schema/pgsql-migrations/upgrade_169.sql


1
2
3
4
5
6
7
8

CREATE DOMAIN d_smallint AS integer CHECK (VALUE >= 0) CHECK (VALUE < 65536);

ALTER TABLE icinga_endpoint ALTER COLUMN port TYPE d_smallint;


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