icingadb/schema/pgsql/upgrades/optional/1.2-0-history.sql

mirror of https://github.com/Icinga/icingadb.git synced 2026-04-22 14:49:04 -04:00
ALTER TABLE state_history ALTER COLUMN check_attempt TYPE uint;

COMMENT ON COLUMN state_history.check_attempt IS NULL;
Unify check attempt data type to uint32 already used somewhere A float isn't necessary as in Icinga 2 Checkable#max_check_attempts and check_attempt are ints. But uint8 isn't enough for e.g. 1 check/s to get HARD after 5m (300s > 255). 2024-04-08 09:56:00 -04:00			`ALTER TABLE state_history ALTER COLUMN check_attempt TYPE uint;`

			`COMMENT ON COLUMN state_history.check_attempt IS NULL;`