diff options
| author | hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2003-11-19 18:40:48 +0000 |
|---|---|---|
| committer | hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2003-11-19 18:40:48 +0000 |
| commit | acad88cf60692999e904981a563532445d95a524 (patch) | |
| tree | eb28c570377c37318bb513d2c2a077b40dd60cdc /create/postgresql/schema.sql | |
| parent | 9cbfa5e5b558aee082006628115a6d264d365dd0 (diff) | |
| download | zabbix-acad88cf60692999e904981a563532445d95a524.tar.gz zabbix-acad88cf60692999e904981a563532445d95a524.tar.xz zabbix-acad88cf60692999e904981a563532445d95a524.zip | |
- fixed PostgreSQL schema (Alexei)
git-svn-id: svn://svn.zabbix.com/trunk@1044 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'create/postgresql/schema.sql')
| -rw-r--r-- | create/postgresql/schema.sql | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/create/postgresql/schema.sql b/create/postgresql/schema.sql index 443d3706..e86ecdbf 100644 --- a/create/postgresql/schema.sql +++ b/create/postgresql/schema.sql @@ -63,7 +63,7 @@ CREATE TABLE items ( trapper_hosts varchar(255) DEFAULT '' NOT NULL, units varchar(10) DEFAULT '' NOT NULL, multiplier int4 DEFAULT '0' NOT NULL, - delta int1 DEFAULT '0' NOT NULL, + delta int4 DEFAULT '0' NOT NULL, prevorgvalue float8 DEFAULT NULL, PRIMARY KEY (itemid), FOREIGN KEY (hostid) REFERENCES hosts @@ -176,10 +176,10 @@ CREATE TABLE actions ( subject varchar(255) DEFAULT '' NOT NULL, message text DEFAULT '' NOT NULL, nextcheck int4 DEFAULT '0' NOT NULL, - recipient int1 DEFAULT '0' NOT NULL, + recipient int4 DEFAULT '0' NOT NULL, PRIMARY KEY (actionid), - FOREIGN KEY (triggerid) REFERENCES triggers, - FOREIGN KEY (userid) REFERENCES users + FOREIGN KEY (triggerid) REFERENCES triggers +-- FOREIGN KEY (userid) REFERENCES users ); -- |