mirror of
https://github.com/Icinga/icingadb.git
synced 2026-02-03 20:40:34 -05:00
12 lines
505 B
MySQL
12 lines
505 B
MySQL
|
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);
|