icingadb/schema/pgsql/upgrades
Alvar Penning 27d27d4539
schema: Fix values to fit by increasing type sizes
The icon_image_alt column in both the host and service tables contains
an image alt text. However, because it is defined as a varchar(32), many
alt texts do not fit. The type has been expanded to text, as with most
free text fields.

Closes #752.

When defining a TimePeriod, the maximum length of a range value was
capped at 255 characters. This limitation has now also been removed by
switching to the Text type.

Closes #724.

While re-reading the schema, I stumbled upon some missing
properties_checksum comments that were also added.
2024-07-30 10:38:19 +02:00
..
optional Bump version to 1.2.0 2024-04-11 13:23:34 +02:00
1.1.1.sql Increase database schema version 2023-08-07 13:09:01 +02:00
1.2.0.sql Bump version to 1.2.0 2024-04-11 13:23:34 +02:00
1.3.0.sql schema: Fix values to fit by increasing type sizes 2024-07-30 10:38:19 +02:00