....I..PS. [ZBXNEXT-1736] changed db patch to be optional only for server's history and trends tables

3 files changed, 0 insertions, 34 deletions

diff --git a/database/mysql/double.sql b/database/mysql/double.sql
index c4205a873eb..22124d16bb4 100644
--- a/database/mysql/double.sql
+++ b/database/mysql/double.sql
@@ -1,11 +1,5 @@
-ALTER TABLE graphs
-	MODIFY yaxismin DOUBLE PRECISION DEFAULT '0' NOT NULL,
-	MODIFY yaxismax DOUBLE PRECISION DEFAULT '100' NOT NULL,
-	MODIFY percent_left DOUBLE PRECISION DEFAULT '0' NOT NULL,
-	MODIFY percent_right DOUBLE PRECISION DEFAULT '0' NOT NULL;
 ALTER TABLE trends
 	MODIFY value_min DOUBLE PRECISION DEFAULT '0.0000' NOT NULL,
 	MODIFY value_avg DOUBLE PRECISION DEFAULT '0.0000' NOT NULL,
 	MODIFY value_max DOUBLE PRECISION DEFAULT '0.0000' NOT NULL;
-ALTER TABLE services MODIFY goodsla DOUBLE PRECISION DEFAULT '99.9' NOT NULL;
 ALTER TABLE history MODIFY value DOUBLE PRECISION DEFAULT '0.0000' NOT NULL;
diff --git a/database/oracle/double.sql b/database/oracle/double.sql
index 26a2ca54b23..d0950980cba 100644
--- a/database/oracle/double.sql
+++ b/database/oracle/double.sql
@@ -1,21 +1,3 @@
-ALTER TABLE graphs RENAME COLUMN yaxismin TO zbx_old_tmp1;
-ALTER TABLE graphs RENAME COLUMN yaxismax TO zbx_old_tmp2;
-ALTER TABLE graphs RENAME COLUMN percent_left TO zbx_old_tmp3;
-ALTER TABLE graphs RENAME COLUMN percent_right TO zbx_old_tmp4;
-ALTER TABLE graphs
-	ADD (yaxismin BINARY_DOUBLE DEFAULT '0' NOT NULL,
-		yaxismax BINARY_DOUBLE DEFAULT '100' NOT NULL,
-		percent_left BINARY_DOUBLE DEFAULT '0' NOT NULL,
-		percent_right BINARY_DOUBLE DEFAULT '0' NOT NULL);
-UPDATE graphs
-	SET yaxismin=zbx_old_tmp1,
-		yaxismax=zbx_old_tmp2,
-		percent_left=zbx_old_tmp3,
-		percent_right=zbx_old_tmp4;
-ALTER TABLE graphs DROP COLUMN zbx_old_tmp1;
-ALTER TABLE graphs DROP COLUMN zbx_old_tmp2;
-ALTER TABLE graphs DROP COLUMN zbx_old_tmp3;
-ALTER TABLE graphs DROP COLUMN zbx_old_tmp4;
 ALTER TABLE trends RENAME COLUMN value_min TO zbx_old_tmp1;
 ALTER TABLE trends RENAME COLUMN value_avg TO zbx_old_tmp2;
 ALTER TABLE trends RENAME COLUMN value_max TO zbx_old_tmp3;
@@ -30,10 +12,6 @@ UPDATE trends
 ALTER TABLE trends DROP COLUMN zbx_old_tmp1;
 ALTER TABLE trends DROP COLUMN zbx_old_tmp2;
 ALTER TABLE trends DROP COLUMN zbx_old_tmp3;
-ALTER TABLE services RENAME COLUMN goodsla TO zbx_old_tmp1;
-ALTER TABLE services ADD goodsla BINARY_DOUBLE DEFAULT '99.9' NOT NULL;
-UPDATE services SET goodsla=zbx_old_tmp1;
-ALTER TABLE services DROP COLUMN zbx_old_tmp1;
 ALTER TABLE history RENAME COLUMN value TO zbx_old_tmp1;
 ALTER TABLE history ADD value BINARY_DOUBLE DEFAULT '0.0000' NOT NULL;
 UPDATE history SET value=zbx_old_tmp1;
diff --git a/database/postgresql/double.sql b/database/postgresql/double.sql
index 3056e907e70..b9570728aab 100644
--- a/database/postgresql/double.sql
+++ b/database/postgresql/double.sql
@@ -1,11 +1,5 @@
-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;