Zabbix
Public
Source
1
1
ALTER TABLE ONLY trends2
2
ALTER COLUMN value_min TYPE DOUBLE PRECISION,3
+
ALTER COLUMN value_min SET DEFAULT '0.0000',3
4
ALTER COLUMN value_avg TYPE DOUBLE PRECISION,4
-
ALTER COLUMN value_max TYPE DOUBLE PRECISION;5
-
ALTER TABLE ONLY history ALTER COLUMN value TYPE DOUBLE PRECISION;5
+
ALTER COLUMN value_avg SET DEFAULT '0.0000',6
+
ALTER COLUMN value_max TYPE DOUBLE PRECISION,7
+
ALTER COLUMN value_max SET DEFAULT '0.0000';8
+
ALTER TABLE ONLY history9
+
ALTER COLUMN value TYPE DOUBLE PRECISION,10
+
ALTER COLUMN value SET DEFAULT '0.0000';