[jboss-cvs] jboss/src/etc/conf/default standardjbosscmp-jdbc.xml

[Alexey L. <lou...@us...>]

  User: loubyansky
  Date: 04/07/12 14:22:10

  Modified:    src/etc/conf/default Tag: Branch_3_2
                        standardjbosscmp-jdbc.xml
  Log:
  fixed fk constraint template for mySQL
  
  Revision  Changes    Path
  No                   revision
  
  
  No                   revision
  
  
  1.39.2.49 +6 -3      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.48
  retrieving revision 1.39.2.49
  diff -u -r1.39.2.48 -r1.39.2.49
  --- standardjbosscmp-jdbc.xml	24 Jun 2004 12:21:58 -0000	1.39.2.48
  +++ standardjbosscmp-jdbc.xml	12 Jul 2004 21:22:09 -0000	1.39.2.49
  @@ -9,7 +9,7 @@
   <!--                                                                       -->
   <!-- ===================================================================== -->
   
  -<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.48 2004/06/24 12:21:58 loubyansky Exp $ -->
  +<!-- $Id: standardjbosscmp-jdbc.xml,v 1.39.2.49 2004/07/12 21:22:09 loubyansky Exp $ -->
   
   <jbosscmp-jdbc>
   
  @@ -1711,8 +1711,11 @@
            <name>mySQL</name>
            <row-locking-template>SELECT ?1 FROM ?2 WHERE ?3 ORDER BY ?4 FOR UPDATE</row-locking-template>
            <pk-constraint-template>CONSTRAINT ?1 PRIMARY KEY (?2)</pk-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>
  +         <!-- 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>
  +         -->
  +         <fk-constraint-template>ALTER TABLE ?1 ADD INDEX (?3), 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>