mirror of
https://github.com/Icinga/icingadb.git
synced 2026-02-03 20:40:34 -05:00
27d27d4539
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.
11 lines
505 B
SQL
11 lines
505 B
SQL
ALTER TABLE host ALTER COLUMN icon_image_alt TYPE text;
|
|
ALTER TABLE service ALTER COLUMN icon_image_alt TYPE text;
|
|
|
|
COMMENT ON COLUMN endpoint.properties_checksum IS 'sha1(all properties)';
|
|
COMMENT ON COLUMN comment.properties_checksum IS 'sha1(all properties)';
|
|
COMMENT ON COLUMN notification.properties_checksum IS 'sha1(all properties)';
|
|
|
|
ALTER TABLE timeperiod_range ALTER COLUMN range_value TYPE text;
|
|
|
|
INSERT INTO icingadb_schema (version, timestamp)
|
|
VALUES (4, extract(epoch from now()) * 1000);
|