Author: andre
Date: 2009-12-03 13:54:04 +0100 (Thu, 03 Dec 2009)
New Revision: 40102
Modified:
mmbase/trunk/core/src/main/config/storage/databases/mysql-lowercase.xml
mmbase/trunk/core/src/main/config/storage/databases/mysql.xml
Log:
indexes MMB-1826
Modified:
mmbase/trunk/core/src/main/config/storage/databases/mysql-lowercase.xml
===================================================================
--- mmbase/trunk/core/src/main/config/storage/databases/mysql-lowercase.xml
2009-12-03 12:53:00 UTC (rev 40101)
+++ mmbase/trunk/core/src/main/config/storage/databases/mysql-lowercase.xml
2009-12-03 12:54:04 UTC (rev 40102)
@@ -32,7 +32,7 @@
<option name="database-supports-blob" />
<!-- uses different syntax for creating unique key constraints -->
- <scheme name="create-unique-key-scheme" >UNIQUE INDEX {2} ({2})</scheme>
+ <scheme name="create-unique-key-scheme" >UNIQUE INDEX {2} ({2}
({4}))</scheme>
<!-- MySQL does not properly support foreign keys, Still create a least an
index -->
<scheme name="create-foreign-key-scheme" >INDEX {2} ({2})</scheme>
Modified: mmbase/trunk/core/src/main/config/storage/databases/mysql.xml
===================================================================
--- mmbase/trunk/core/src/main/config/storage/databases/mysql.xml
2009-12-03 12:53:00 UTC (rev 40101)
+++ mmbase/trunk/core/src/main/config/storage/databases/mysql.xml
2009-12-03 12:54:04 UTC (rev 40102)
@@ -25,7 +25,7 @@
<option name="database-supports-blob" />
<!-- uses different syntax for creating unique key constraints -->
- <scheme name="create-unique-key-scheme" >UNIQUE INDEX {2} ({2})</scheme>
+ <scheme name="create-unique-key-scheme" >UNIQUE INDEX {2} ({2}
({4}))</scheme>
<!-- MySQL does not properly support foreign keys, Still create a least an
index -->
<scheme name="create-foreign-key-scheme" >INDEX {2} ({2})</scheme>
_______________________________________________
Cvs mailing list
Cvs@lists.mmbase.org
http://lists.mmbase.org/mailman/listinfo/cvs
