diff options
| author | hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2006-06-02 07:29:29 +0000 |
|---|---|---|
| committer | hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2006-06-02 07:29:29 +0000 |
| commit | 42e5b73f8c9b3f5f88938345987d4484d71b435c (patch) | |
| tree | 7a8ca86219f6589d76529f64ce585c18f45bfcc8 /create/oracle | |
| parent | 718006b053768538623b9753a889a8735ec5c2c3 (diff) | |
| download | zabbix-42e5b73f8c9b3f5f88938345987d4484d71b435c.tar.gz zabbix-42e5b73f8c9b3f5f88938345987d4484d71b435c.tar.xz zabbix-42e5b73f8c9b3f5f88938345987d4484d71b435c.zip | |
- fixes in Oracle schema (Alexei)
git-svn-id: svn://svn.zabbix.com/trunk@2942 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'create/oracle')
| -rw-r--r-- | create/oracle/schema.sql | 14 |
1 files changed, 7 insertions, 7 deletions
diff --git a/create/oracle/schema.sql b/create/oracle/schema.sql index 9a279a53..f425079c 100644 --- a/create/oracle/schema.sql +++ b/create/oracle/schema.sql @@ -35,7 +35,7 @@ CREATE TABLE config ( CREATE TABLE history ( itemid number(10) DEFAULT '0' NOT NULL, clock number(10) DEFAULT '0' NOT NULL, - value number(16,4) DEFAULT '0.0000' NOT NULL + value number(20,4) DEFAULT '0.0000' NOT NULL ); CREATE INDEX history_itemidclock on history (itemid, clock); @@ -146,8 +146,8 @@ CREATE TABLE graphs ( width number(10) DEFAULT '0' NOT NULL, height number(10) DEFAULT '0' NOT NULL, yaxistype number(3) DEFAULT '0' NOT NULL, - yaxismin number(16,4) DEFAULT '0' NOT NULL, - yaxismax number(16,4) DEFAULT '0' NOT NULL, + yaxismin number(20,4) DEFAULT '0' NOT NULL, + yaxismax number(20,4) DEFAULT '0' NOT NULL, templateid number(10) DEFAULT '0' NOT NULL, show_work_period number(3) DEFAULT '1' NOT NULL, show_triggers number(3) DEFAULT '1' NOT NULL, @@ -576,7 +576,7 @@ CREATE TABLE items ( units varchar2(10) DEFAULT NULL, multiplier number(10) DEFAULT '0' NOT NULL, delta number(3) DEFAULT '0' NOT NULL, - prevorgvalue number(16,4) DEFAULT NULL, + prevorgvalue number(20,4) DEFAULT NULL, snmpv3_securityname varchar2(64) DEFAULT NULL, snmpv3_securitylevel number(3) DEFAULT '0' NOT NULL, snmpv3_authpassphrase varchar2(64) DEFAULT NULL, @@ -1003,9 +1003,9 @@ CREATE TABLE trends ( itemid number(10) DEFAULT '0' NOT NULL, clock number(10) DEFAULT '0' NOT NULL, num number(5) DEFAULT '0' NOT NULL, - value_min number(16,4) DEFAULT '0.0000' NOT NULL, - value_avg number(16,4) DEFAULT '0.0000' NOT NULL, - value_max number(16,4) DEFAULT '0.0000' NOT NULL, + value_min number(20,4) DEFAULT '0.0000' NOT NULL, + value_avg number(20,4) DEFAULT '0.0000' NOT NULL, + value_max number(20,4) DEFAULT '0.0000' NOT NULL, CONSTRAINT trends_pk PRIMARY KEY (itemid, clock) ); |