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 /upgrades | |
| 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 'upgrades')
| -rw-r--r-- | upgrades/dbpatches/1.0beta9_to_1.0beta10/mysql/patch.sql | 7 | ||||
| -rw-r--r-- | upgrades/dbpatches/1.0beta9_to_1.0beta10/postgresql/patch.sql | 7 |
2 files changed, 10 insertions, 4 deletions
diff --git a/upgrades/dbpatches/1.0beta9_to_1.0beta10/mysql/patch.sql b/upgrades/dbpatches/1.0beta9_to_1.0beta10/mysql/patch.sql index ebe6717b..55e32ce8 100644 --- a/upgrades/dbpatches/1.0beta9_to_1.0beta10/mysql/patch.sql +++ b/upgrades/dbpatches/1.0beta9_to_1.0beta10/mysql/patch.sql @@ -1,5 +1,6 @@ alter table items add units varchar(10) DEFAULT '' NOT NULL; alter table items add multiplier int(4) DEFAULT '' NOT NULL; +alter table sysmaps_links add triggerid int(4); update items set units='bps' where key_ like "netload%"; update items set units='bytes' where key_ like "memory[%]"; @@ -19,6 +20,8 @@ CREATE TABLE stats ( month int(4) DEFAULT '0' NOT NULL, day int(4) DEFAULT '0' NOT NULL, hour int(4) DEFAULT '0' NOT NULL, - value double(16,4) DEFAULT '0.0000' NOT NULL, - PRIMARY KEY (itemid,year,month,day,hour), + value_max double(16,4) DEFAULT '0.0000' NOT NULL, + value_min double(16,4) DEFAULT '0.0000' NOT NULL, + value_avg double(16,4) DEFAULT '0.0000' NOT NULL, + PRIMARY KEY (itemid,year,month,day,hour) ) type=InnoDB; diff --git a/upgrades/dbpatches/1.0beta9_to_1.0beta10/postgresql/patch.sql b/upgrades/dbpatches/1.0beta9_to_1.0beta10/postgresql/patch.sql index 9737dd88..3dfd53be 100644 --- a/upgrades/dbpatches/1.0beta9_to_1.0beta10/postgresql/patch.sql +++ b/upgrades/dbpatches/1.0beta9_to_1.0beta10/postgresql/patch.sql @@ -1,5 +1,6 @@ alter table items add units varchar(10) DEFAULT '' NOT NULL; alter table items add multiplier int4 DEFAULT '' NOT NULL; +alter table sysmaps_links add triggerid int4; update items set units='bps' where key_ like "netload%"; update items set units='bytes' where key_ like "memory[%]"; @@ -16,6 +17,8 @@ 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) ); |