diff options
| author | hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2005-05-14 09:43:39 +0000 |
|---|---|---|
| committer | hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2005-05-14 09:43:39 +0000 |
| commit | ec883aa97f0d7d508ca853ab19aea2f5ee3f2bf7 (patch) | |
| tree | 40830c21624f628de95360e562a460eeee81f7a2 | |
| parent | 1abd8d7429b3c7d5dd4888876f72b542c223b93a (diff) | |
| download | zabbix-ec883aa97f0d7d508ca853ab19aea2f5ee3f2bf7.tar.gz zabbix-ec883aa97f0d7d508ca853ab19aea2f5ee3f2bf7.tar.xz zabbix-ec883aa97f0d7d508ca853ab19aea2f5ee3f2bf7.zip | |
- changed definition of services.goodsla to double(5.2) (Alexei)
git-svn-id: svn://svn.zabbix.com/trunk@1768 97f52cf1-0a1b-0410-bd0e-c28be96e8082
| -rw-r--r-- | ChangeLog | 1 | ||||
| -rw-r--r-- | create/mysql/schema.sql | 2 | ||||
| -rw-r--r-- | upgrades/dbpatches/1.1alpha8_to_1.1alpha9/mysql/patch.sql | 1 | ||||
| -rw-r--r-- | upgrades/dbpatches/1.1alpha8_to_1.1alpha9/postgresql/patch.sql | 0 |
4 files changed, 3 insertions, 1 deletions
@@ -1,5 +1,6 @@ Changes for 1.1alpha8: + - changed definition of services.goodsla to double(5.2) (Alexei) - minor fix for users.php (Alexei) - fixed graph.php. Thanks to Michael Durket. (Alexei) - added SuSE 9.2 startup scripts. Thanks to Kiepe Andre. (Alexei) diff --git a/create/mysql/schema.sql b/create/mysql/schema.sql index cd7b9bb6..49bd8afe 100644 --- a/create/mysql/schema.sql +++ b/create/mysql/schema.sql @@ -29,7 +29,7 @@ CREATE TABLE services ( algorithm int(1) DEFAULT '0' NOT NULL, triggerid int(4), showsla int(1) DEFAULT '0' NOT NULL, - goodsla double(3,2) DEFAULT '99.9' NOT NULL, + goodsla double(5,2) DEFAULT '99.9' NOT NULL, sortorder int(4) DEFAULT '0' NOT NULL, PRIMARY KEY (serviceid) ) type=InnoDB; diff --git a/upgrades/dbpatches/1.1alpha8_to_1.1alpha9/mysql/patch.sql b/upgrades/dbpatches/1.1alpha8_to_1.1alpha9/mysql/patch.sql new file mode 100644 index 00000000..b7ad3d7c --- /dev/null +++ b/upgrades/dbpatches/1.1alpha8_to_1.1alpha9/mysql/patch.sql @@ -0,0 +1 @@ +alter table services modify goodsla double(5,2) DEFAULT '99.9' NOT NULL; diff --git a/upgrades/dbpatches/1.1alpha8_to_1.1alpha9/postgresql/patch.sql b/upgrades/dbpatches/1.1alpha8_to_1.1alpha9/postgresql/patch.sql new file mode 100644 index 00000000..e69de29b --- /dev/null +++ b/upgrades/dbpatches/1.1alpha8_to_1.1alpha9/postgresql/patch.sql |