diff options
| author | hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2001-07-23 09:34:04 +0000 |
|---|---|---|
| committer | hugetoad <hugetoad@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2001-07-23 09:34:04 +0000 |
| commit | cd811d94c672faf95f62fda77f4369c7d918e7a8 (patch) | |
| tree | 1704f7557c7e1cc5b046104dc3c86bbf81b4d5cb | |
| parent | 60b70ebb2393adb34d7dc3166954fafb23ecccde (diff) | |
| download | zabbix-cd811d94c672faf95f62fda77f4369c7d918e7a8.tar.gz zabbix-cd811d94c672faf95f62fda77f4369c7d918e7a8.tar.xz zabbix-cd811d94c672faf95f62fda77f4369c7d918e7a8.zip | |
Added index (triggerid,clock) for table alarms
git-svn-id: svn://svn.zabbix.com/trunk@143 97f52cf1-0a1b-0410-bd0e-c28be96e8082
| -rw-r--r-- | ChangeLog | 2 | ||||
| -rw-r--r-- | create/mysql/schema.sql | 3 | ||||
| -rw-r--r-- | create/postgresql/schema.sql | 3 | ||||
| -rw-r--r-- | upgrades/dbpatches/1.0alpha7_to_1.0alpha8/mysql/patch.sql | 1 | ||||
| -rw-r--r-- | upgrades/dbpatches/1.0alpha7_to_1.0alpha8/postgresql/patch.sql | 1 |
5 files changed, 7 insertions, 3 deletions
@@ -1,7 +1,7 @@ Changes for 1.0alpha8: + - added index (triggerid,clock) for table alarms - status of triggers will not be shown for disabled and not-supported parameters - - fixed availability report - optimization of chart.html - added trend.html diff --git a/create/mysql/schema.sql b/create/mysql/schema.sql index 57ed174f..72178f15 100644 --- a/create/mysql/schema.sql +++ b/create/mysql/schema.sql @@ -140,7 +140,8 @@ CREATE TABLE alarms ( triggerid int(4) DEFAULT '0' NOT NULL, clock int(4) DEFAULT '0' NOT NULL, istrue int(4) DEFAULT '0' NOT NULL, - PRIMARY KEY (alarmid) + PRIMARY KEY (alarmid), + KEY (triggerid,clock) ); # diff --git a/create/postgresql/schema.sql b/create/postgresql/schema.sql index 5ca0d532..46b81e89 100644 --- a/create/postgresql/schema.sql +++ b/create/postgresql/schema.sql @@ -158,7 +158,8 @@ CREATE TABLE alarms ( clock int4 DEFAULT '0' NOT NULL, istrue int4 DEFAULT '0' NOT NULL, PRIMARY KEY (alarmid), - FOREIGN KEY (triggerid) REFERENCES triggers + FOREIGN KEY (triggerid) REFERENCES triggers, + KEY (triggerid, clock) ); -- diff --git a/upgrades/dbpatches/1.0alpha7_to_1.0alpha8/mysql/patch.sql b/upgrades/dbpatches/1.0alpha7_to_1.0alpha8/mysql/patch.sql index 729f2d05..c1a2413c 100644 --- a/upgrades/dbpatches/1.0alpha7_to_1.0alpha8/mysql/patch.sql +++ b/upgrades/dbpatches/1.0alpha7_to_1.0alpha8/mysql/patch.sql @@ -1,2 +1,3 @@ alter table graphs_items add color varchar(32) DEFAULT 'Dark Green' NOT NULL; alter table sysmaps_hosts add icon varchar(32) DEFAULT 'Server' NOT NULL; +alter table alarms add key (triggerid,clock); diff --git a/upgrades/dbpatches/1.0alpha7_to_1.0alpha8/postgresql/patch.sql b/upgrades/dbpatches/1.0alpha7_to_1.0alpha8/postgresql/patch.sql index 729f2d05..db47d6ec 100644 --- a/upgrades/dbpatches/1.0alpha7_to_1.0alpha8/postgresql/patch.sql +++ b/upgrades/dbpatches/1.0alpha7_to_1.0alpha8/postgresql/patch.sql @@ -1,2 +1,3 @@ alter table graphs_items add color varchar(32) DEFAULT 'Dark Green' NOT NULL; alter table sysmaps_hosts add icon varchar(32) DEFAULT 'Server' NOT NULL; +create index alarms_trggerid_clock on alarms (triggerid,clock); |