diff options
author | hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2003-02-16 14:28:23 +0000 |
---|---|---|
committer | hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2003-02-16 14:28:23 +0000 |
commit | 97713f1b9da38b6848e144a9d4e776f03b178e8e (patch) | |
tree | c0923626f66eb44af93412a86c8e9730f940428d /create | |
parent | a43d9df41c9c70a7f0b7a0f8624d67ccedef12b6 (diff) | |
download | zabbix-97713f1b9da38b6848e144a9d4e776f03b178e8e.tar.gz zabbix-97713f1b9da38b6848e144a9d4e776f03b178e8e.tar.xz zabbix-97713f1b9da38b6848e144a9d4e776f03b178e8e.zip |
- fixed type of services.goodsla. It's float now. (Alexei)
git-svn-id: svn://svn.zabbix.com/trunk@699 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'create')
-rw-r--r-- | create/mysql/schema.sql | 2 | ||||
-rw-r--r-- | create/postgresql/schema.sql | 2 |
2 files changed, 2 insertions, 2 deletions
diff --git a/create/mysql/schema.sql b/create/mysql/schema.sql index 15d3e6aa..a23633fd 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 int(4) DEFAULT '99.9' NOT NULL, + goodsla double(3,2) DEFAULT '99.9' NOT NULL, PRIMARY KEY (serviceid) ) type=InnoDB; diff --git a/create/postgresql/schema.sql b/create/postgresql/schema.sql index 10e6b05b..723ffa91 100644 --- a/create/postgresql/schema.sql +++ b/create/postgresql/schema.sql @@ -384,7 +384,7 @@ CREATE TABLE services ( algorithm int2 DEFAULT '0' NOT NULL, triggerid int4, showsla int4 DEFAULT '0' NOT NULL, - goodsla int4 DEFAULT '99.9' NOT NULL, + goodsla float8 DEFAULT '99.9' NOT NULL, PRIMARY KEY (serviceid) ); |