Menu
▾
▴
[jboss-cvs] jboss/src/etc/conf/default standardjbosscmp-jdbc.xml
|
From: Alexey L. <lou...@us...> - 2003-10-05 14:23:50
|
User: loubyansky
Date: 03/10/05 07:23:48
Modified: src/etc/conf/default Tag: Branch_3_2
standardjbosscmp-jdbc.xml
Log:
Removed ADD INDEX from FK constraint template for mySQL. It does not work for compound keys.
Revision Changes Path
No revision
No revision
1.39.2.27 +3 -2 jboss/src/etc/conf/default/standardjbosscmp-jdbc.xml
Index: standardjbosscmp-jdbc.xml
===================================================================
RCS file: /cvsroot/jboss/jboss/src/etc/conf/default/standardjbosscmp-jdbc.xml,v
retrieving revision 1.39.2.26
retrieving revision 1.39.2.27
diff -u -r1.39.2.26 -r1.39.2.27
--- standardjbosscmp-jdbc.xml 9 Sep 2003 13:02:18 -0000 1.39.2.26
+++ standardjbosscmp-jdbc.xml 5 Oct 2003 14:23:47 -0000 1.39.2.27
@@ -9,7 +9,7 @@
<!-- -->
<!-- ===================================================================== -->
-<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.26 2003/09/09 13:02:18 lqd Exp $ -->
+<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.27 2003/10/05 14:23:47 loubyansky Exp $ -->
<jbosscmp-jdbc>
@@ -1559,7 +1559,8 @@
<name>mySQL</name>
<row-locking-template>SELECT ?1 FROM ?2 WHERE ?3 FOR UPDATE</row-locking-template>
<pk-constraint-template>CONSTRAINT ?1 PRIMARY KEY (?2)</pk-constraint-template>
- <fk-constraint-template>ALTER TABLE ?1 ADD INDEX ind_?3 (?3), ADD CONSTRAINT ?2 FOREIGN KEY (?3) REFERENCES ?4 (?5)</fk-constraint-template>
+ <!-- does not work for compound keys <fk-constraint-template>ALTER TABLE ?1 ADD INDEX ind_?3 (?3), ADD CONSTRAINT ?2 FOREIGN KEY (?3) REFERENCES ?4 (?5)</fk-constraint-template> -->
+ <fk-constraint-template>ALTER TABLE ?1 ADD CONSTRAINT ?2 FOREIGN KEY (?3) REFERENCES ?4 (?5)</fk-constraint-template>
<auto-increment-template>?1 auto_increment</auto-increment-template>
<alias-header-prefix>t</alias-header-prefix>
<alias-header-suffix>_</alias-header-suffix>
|
