[otrs-cvs] otrs/scripts DBUpdate-to-2.2.mysql.sql,1.7,1.8

[cvs-log at otrs.org]

Comments:
Update of /home/cvs/otrs/scripts
In directory lancelot:/tmp/cvs-serv3803

Modified Files:
	DBUpdate-to-2.2.mysql.sql 
Log Message:
Improved indexes of xml_storage table

Author: mh

Index: DBUpdate-to-2.2.mysql.sql
===================================================================
RCS file: /home/cvs/otrs/scripts/DBUpdate-to-2.2.mysql.sql,v
retrieving revision 1.7
retrieving revision 1.8
diff -C2 -d -r1.7 -r1.8
*** DBUpdate-to-2.2.mysql.sql	16 Mar 2007 10:02:13 -0000	1.7
--- DBUpdate-to-2.2.mysql.sql	2 Apr 2007 13:50:15 -0000	1.8
***************
*** 114,115 ****
--- 114,124 ----
  ALTER TABLE sla ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`;
  ALTER TABLE sla ADD FOREIGN KEY (service_id) REFERENCES `service(id)`;
+ 
+ --
+ -- xml_storage
+ --
+ 
+ ALTER TABLE xml_storage DROP INDEX `xml_type`;
+ ALTER TABLE xml_storage DROP INDEX `xml_key`;
+ ALTER TABLE xml_storage ADD INDEX (`xml_type`, `xml_key`);
+