diff options
author | Aleksejs Sestakovs <aleksejs.sestakovs@zabbix.com> | 2020-01-28 21:12:17 +0300 |
---|---|---|
committer | Aleksejs Sestakovs <aleksejs.sestakovs@zabbix.com> | 2020-01-28 21:12:17 +0300 |
commit | 1e1a60ba0afa6ae8d21d223ea348e9092d1046a5 (patch) | |
tree | 35bc6a6f298f3741431c491ef30d63db66f39ccc /database | |
parent | 4cc8387cee981b6349282f6fa91d9a45bf05910d (diff) |
....I..... [ZBXNEXT-1736] added optional upgrade patches for MySQL and PostgreSQL
Diffstat (limited to 'database')
-rw-r--r-- | database/mysql/double.sql | 9 | ||||
-rw-r--r-- | database/postgresql/double.sql | 11 |
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; |