From: Bharat M. <bh...@us...> - 2005-09-25 06:56:26
|
Update of /cvsroot/gallery/gallery2/modules/imageblock/classes/GalleryStorage/DatabaseStorage/schema/xml-src In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv9740/modules/imageblock/classes/GalleryStorage/DatabaseStorage/schema/xml-src Added Files: A_ImageBlockCacheMap.xml Log Message: Fix incorrect index names in MySQL. When we converted index names to <table>_<crc> we didn't update the MySQL generated SQL files so the indexes on MySQL are still in the old format. Update the DTD to allow you to specify the actual name of the index for the various databases, then create a change XML script which drops the old index and replaces it with the new, correctly named one. Unfortunately this requires us to delete and re-add the same index for Postgres and Oracle which were already done correctly. Modules changed: * comment module o module version 1.0.0 -> 1.0.1 o GalleryComment schema 1.0 -> 1.1 * imageblock module o module version 1.0.0 -> 1.0.1 o ImageBlockCacheMap schema 1.0 -> 1.1 * customfield module o module version 1.0.0 -> 1.0.1 o CustomFieldMap schema 1.0 -> 1.1 --- NEW FILE: A_ImageBlockCacheMap.xml --- <?xml version="1.0" encoding="utf-8"?> <!DOCTYPE table SYSTEM "../../../../../../../lib/tools/dtd/DatabaseChangeDefinition2.0.dtd"> <change> <table-name>ImageBlockCacheMap</table-name> <schema-from> <schema-major>1</schema-major> <schema-minor>0</schema-minor> </schema-from> <schema-to> <schema-major>1</schema-major> <schema-minor>1</schema-minor> </schema-to> <remove> <!-- MySQL index name was out of date --> <index name_mysql="DB_COLUMN_PREFIXuserId"> <column-name>userId</column-name> <column-name>itemType</column-name> </index> </remove> <add> <index> <column-name>userId</column-name> <column-name>itemType</column-name> </index> </add> </change> |