mirror of
https://github.com/Icinga/icingadb.git
synced 2026-06-08 16:34:29 -04:00
12 lines
610 B
MySQL
12 lines
610 B
MySQL
|
ALTER TABLE host MODIFY COLUMN icon_image_alt TEXT NOT NULL;
|
||
|
|
ALTER TABLE service MODIFY COLUMN icon_image_alt TEXT NOT NULL;
|
||
|
|
|
||
|
|
ALTER TABLE endpoint MODIFY COLUMN properties_checksum binary(20) NOT NULL COMMENT 'sha1(all properties)';
|
||
|
|
ALTER TABLE comment MODIFY COLUMN properties_checksum binary(20) NOT NULL COMMENT 'sha1(all properties)';
|
||
|
|
ALTER TABLE notification MODIFY COLUMN properties_checksum binary(20) NOT NULL COMMENT 'sha1(all properties)';
|
||
|
|
|
||
|
|
ALTER TABLE timeperiod_range MODIFY COLUMN range_value text NOT NULL;
|
||
|
|
|
||
|
|
INSERT INTO icingadb_schema (version, timestamp)
|
||
|
|
VALUES (6, UNIX_TIMESTAMP() * 1000);
|