diff options
| author | hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2003-06-19 10:31:34 +0000 |
|---|---|---|
| committer | hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2003-06-19 10:31:34 +0000 |
| commit | 24e4c0c1e651a3896b966be7ffb03c78e5b86e74 (patch) | |
| tree | b1bc101d5f7f99cf5768aec4b311934cc4923a10 /create/postgresql/schema.sql | |
| parent | b1cf4f71fb1e55fe840887e09aac2317e0c3ea9e (diff) | |
| download | zabbix-24e4c0c1e651a3896b966be7ffb03c78e5b86e74.tar.gz zabbix-24e4c0c1e651a3896b966be7ffb03c78e5b86e74.tar.xz zabbix-24e4c0c1e651a3896b966be7ffb03c78e5b86e74.zip | |
- link map's connector to a trigger, other changes
git-svn-id: svn://svn.zabbix.com/trunk@830 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'create/postgresql/schema.sql')
| -rw-r--r-- | create/postgresql/schema.sql | 8 |
1 files changed, 6 insertions, 2 deletions
diff --git a/create/postgresql/schema.sql b/create/postgresql/schema.sql index 6a82cb8e..8619d9dd 100644 --- a/create/postgresql/schema.sql +++ b/create/postgresql/schema.sql @@ -363,6 +363,8 @@ CREATE TABLE sysmaps_links ( sysmapid int4 DEFAULT '0' NOT NULL, shostid1 int4 DEFAULT '0' NOT NULL, shostid2 int4 DEFAULT '0' NOT NULL, +-- may be NULL + triggerid int4, PRIMARY KEY (linkid), FOREIGN KEY (sysmapid) REFERENCES sysmaps, FOREIGN KEY (shostid1) REFERENCES sysmaps_hosts, @@ -515,8 +517,10 @@ CREATE TABLE stats ( month int4 DEFAULT '0' NOT NULL, day int4 DEFAULT '0' NOT NULL, hour int4 DEFAULT '0' NOT NULL, - value float8 DEFAULT '0.0000' NOT NULL, - PRIMARY KEY (itemid,year,month,day,hour), + value_max float8 DEFAULT '0.0000' NOT NULL, + value_min float8 DEFAULT '0.0000' NOT NULL, + value_avg float8 DEFAULT '0.0000' NOT NULL, + PRIMARY KEY (itemid,year,month,day,hour) ); VACUUM ANALYZE; |