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 /upgrades | |
| 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
Diffstat (limited to 'upgrades')
| -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 |
2 files changed, 2 insertions, 0 deletions
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); |