[otrs-cvs] otrs/scripts DBUpdate-to-2.2.mysql.sql,1.8,1.9
cvs-log at otrs.org
cvs-log at otrs.org
Mon Apr 2 14:46:59 GMT 2007
Comments:
Update of /home/cvs/otrs/scripts
In directory lancelot:/tmp/cvs-serv5242/scripts
Modified Files:
DBUpdate-to-2.2.mysql.sql
Log Message:
Add missing index name.
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.8
retrieving revision 1.9
diff -C2 -d -r1.8 -r1.9
*** DBUpdate-to-2.2.mysql.sql 2 Apr 2007 13:50:15 -0000 1.8
--- DBUpdate-to-2.2.mysql.sql 2 Apr 2007 14:46:54 -0000 1.9
***************
*** 121,124 ****
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`);
--- 121,124 ----
ALTER TABLE xml_storage DROP INDEX `xml_type`;
ALTER TABLE xml_storage DROP INDEX `xml_key`;
! ALTER TABLE xml_storage ADD INDEX `xml_type_key` (`xml_type`, `xml_key`);
More information about the cvs-log
mailing list