icingaweb2-module-director/schema/pgsql-migrations/upgrade_83.sql
Thomas Gelf 6377ed4bc7 schema/pgsql: allow for longer (> 255) commands
This has already been fixed for MySQL time ago.

refs #11315
2016-03-06 19:28:21 +01:00

7 lines
283 B
SQL

ALTER TABLE icinga_command ALTER COLUMN command TYPE text;
ALTER TABLE icinga_command ALTER COLUMN command DROP DEFAULT;
ALTER TABLE icinga_command ALTER COLUMN command SET DEFAULT NULL;
INSERT INTO director_schema_migration
(schema_version, migration_time)
VALUES (83, NOW());