[otrs-cvs] otrs/scripts DBUpdate-to-2.2.oracle.sql, 1.6, 1.7 DBUpdate-to-2.2.postgresql.sql, 1.7, 1.8

[cvs-log at otrs.org]

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

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

Author: mh

Index: DBUpdate-to-2.2.oracle.sql
===================================================================
RCS file: /home/cvs/otrs/scripts/DBUpdate-to-2.2.oracle.sql,v
retrieving revision 1.6
retrieving revision 1.7
diff -C2 -d -r1.6 -r1.7
*** DBUpdate-to-2.2.oracle.sql	5 Mar 2007 02:26:29 -0000	1.6
--- DBUpdate-to-2.2.oracle.sql	2 Apr 2007 14:11:10 -0000	1.7
***************
*** 143,144 ****
--- 143,153 ----
  ALTER TABLE sla ADD CONSTRAINT fk_sla_change_by_id FOREIGN KEY (change_by) REFERENCES system_user(id);
  ALTER TABLE sla ADD CONSTRAINT fk_sla_service_id_id FOREIGN KEY (service_id) REFERENCES service(id);
+ 
+ --
+ -- xml_storage
+ --
+ 
+ DROP INDEX xml_type;
+ DROP INDEX xml_key;
+ CREATE INDEX xml_type_key ON xml_storage (xml_type, xml_key);
+ 

Author: mh

Index: DBUpdate-to-2.2.postgresql.sql
===================================================================
RCS file: /home/cvs/otrs/scripts/DBUpdate-to-2.2.postgresql.sql,v
retrieving revision 1.7
retrieving revision 1.8
diff -C2 -d -r1.7 -r1.8
*** DBUpdate-to-2.2.postgresql.sql	7 Mar 2007 19:33:27 -0000	1.7
--- DBUpdate-to-2.2.postgresql.sql	2 Apr 2007 14:11:10 -0000	1.8
***************
*** 107,108 ****
--- 107,117 ----
  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
+ --
+ 
+ DROP INDEX xml_type;
+ DROP INDEX xml_key;
+ CREATE INDEX xml_type_key ON xml_storage (xml_type, xml_key);
+