- added missing index on items_applications.itemid (Alexei)

   [svn merge -r4562:4565 svn://svn.zabbix.com/branches/1.4.2]


git-svn-id: svn://svn.zabbix.com/trunk@4566 97f52cf1-0a1b-0410-bd0e-c28be96e8082

2 files changed, 2 insertions, 0 deletions

diff --git a/upgrades/dbpatches/1.4/mysql/patch/items_applications.sql b/upgrades/dbpatches/1.4/mysql/patch/items_applications.sql
index 6d02fd7d..d6d37fc1 100644
--- a/upgrades/dbpatches/1.4/mysql/patch/items_applications.sql
+++ b/upgrades/dbpatches/1.4/mysql/patch/items_applications.sql
@@ -17,6 +17,7 @@ CREATE TABLE items_applications_tmp (
 	PRIMARY KEY (itemappid)
 ) ENGINE=InnoDB;
 CREATE INDEX items_applications_1 on items_applications_tmp (applicationid,itemid);
+CREATE INDEX items_applications_2 on items_applications_tmp (itemid);
 
 insert into items_applications_tmp select * from items_applications;
 drop table items_applications;
diff --git a/upgrades/dbpatches/1.4/postgresql/patch/items_applications.sql b/upgrades/dbpatches/1.4/postgresql/patch/items_applications.sql
index f16ccc3e..505d2ce0 100644
--- a/upgrades/dbpatches/1.4/postgresql/patch/items_applications.sql
+++ b/upgrades/dbpatches/1.4/postgresql/patch/items_applications.sql
@@ -17,6 +17,7 @@ CREATE TABLE items_applications_tmp (
 	PRIMARY KEY (itemappid)
 ) with OIDS;
 CREATE INDEX items_applications_1 on items_applications_tmp (applicationid,itemid);
+CREATE INDEX items_applications_2 on items_applications_tmp (itemid);
 
 insert into items_applications_tmp select * from items_applications;
 drop table items_applications;