....I..... [ZBXNEXT-1736] added optional upgrade patches for MySQL and PostgreSQL

2 files changed, 20 insertions, 0 deletions

diff --git a/database/mysql/double.sql b/database/mysql/double.sql
new file mode 100644
index 00000000000..a48d0f776e9
--- /dev/null
+++ b/database/mysql/double.sql
@@ -0,0 +1,9 @@
+ALTER TABLE graphs MODIFY yaxismin DOUBLE PRECISION;
+ALTER TABLE graphs MODIFY yaxismax DOUBLE PRECISION;
+ALTER TABLE graphs MODIFY percent_left DOUBLE PRECISION;
+ALTER TABLE graphs MODIFY percent_right DOUBLE PRECISION;
+ALTER TABLE trends MODIFY value_min DOUBLE PRECISION;
+ALTER TABLE trends MODIFY value_avg DOUBLE PRECISION;
+ALTER TABLE trends MODIFY value_max DOUBLE PRECISION;
+ALTER TABLE services MODIFY goodsla DOUBLE PRECISION;
+ALTER TABLE history MODIFY value DOUBLE PRECISION;
diff --git a/database/postgresql/double.sql b/database/postgresql/double.sql
new file mode 100644
index 00000000000..3056e907e70
--- /dev/null
+++ b/database/postgresql/double.sql
@@ -0,0 +1,11 @@
+ALTER TABLE ONLY graphs
+	ALTER COLUMN yaxismin TYPE DOUBLE PRECISION,
+	ALTER COLUMN yaxismax TYPE DOUBLE PRECISION,
+	ALTER COLUMN percent_left TYPE DOUBLE PRECISION,
+	ALTER COLUMN percent_right TYPE DOUBLE PRECISION;
+ALTER TABLE ONLY trends
+	ALTER COLUMN value_min TYPE DOUBLE PRECISION,
+	ALTER COLUMN value_avg TYPE DOUBLE PRECISION,
+	ALTER COLUMN value_max TYPE DOUBLE PRECISION;
+ALTER TABLE ONLY services ALTER COLUMN goodsla TYPE DOUBLE PRECISION;
+ALTER TABLE ONLY history ALTER COLUMN value TYPE DOUBLE PRECISION;