db-ojb-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From arm...@apache.org
Subject cvs commit: db-ojb/src/schema ojbtest-schema.xml
Date Fri, 04 Nov 2005 13:10:12 GMT
arminw      2005/11/04 05:10:12

  Modified:    src/schema ojbtest-schema.xml
  Log:
  change order of table declaration to avoid problems with constraints on table creation with
torque (nevertheless exceptions could arise on table drop call next time the script was executed)
  
  Revision  Changes    Path
  1.103     +20 -17    db-ojb/src/schema/ojbtest-schema.xml
  
  Index: ojbtest-schema.xml
  ===================================================================
  RCS file: /home/cvs/db-ojb/src/schema/ojbtest-schema.xml,v
  retrieving revision 1.102
  retrieving revision 1.103
  diff -u -r1.102 -r1.103
  --- ojbtest-schema.xml	3 Nov 2005 13:38:23 -0000	1.102
  +++ ojbtest-schema.xml	4 Nov 2005 13:10:12 -0000	1.103
  @@ -1478,6 +1478,12 @@
       <!-- =================================================== -->
       <!-- LockCircularTest - odmg                             -->
       <!-- =================================================== -->
  +    <table name="CT_DETAIL">
  +        <column name="OBJ_ID" required="true" primaryKey="true" type="INTEGER"/>
  +        <column name="NAME" type="VARCHAR" size="250"/>
  +        <column name="SHOP_FK" type="INTEGER"/>
  +    </table>
  +
       <table name="CT_SHOP">
           <column name="OBJ_ID" required="true" primaryKey="true" type="INTEGER"/>
           <column name="NAME" type="VARCHAR" size="250"/>
  @@ -1487,12 +1493,6 @@
           </foreign-key>
       </table>
   
  -    <table name="CT_DETAIL">
  -        <column name="OBJ_ID" required="true" primaryKey="true" type="INTEGER"/>
  -        <column name="NAME" type="VARCHAR" size="250"/>
  -        <column name="SHOP_FK" type="INTEGER"/>
  -    </table>
  -
       <table name="CT_DISTRIBUTOR">
           <column name="OBJ_ID" required="true" primaryKey="true" type="INTEGER"/>
           <column name="NAME" type="VARCHAR" size="250"/>
  @@ -1522,35 +1522,38 @@
           </foreign-key>
       </table>
   
  -    <table name="CT_OBJECT_A">
  +    <table name="CT_OBJECT_AAAA">
           <column name="OBJ_ID" required="true" primaryKey="true" type="INTEGER"/>
           <column name="NAME" type="VARCHAR" size="250"/>
           <column name="FK_ID" type="INTEGER"/>
  -        <foreign-key foreignTable="CT_OBJECT_AA">
  -            <reference local="FK_ID" foreign="OBJ_ID"/>
  -        </foreign-key>
       </table>
  -    <table name="CT_OBJECT_AA">
  +
  +    <table name="CT_OBJECT_AAA">
           <column name="OBJ_ID" required="true" primaryKey="true" type="INTEGER"/>
           <column name="NAME" type="VARCHAR" size="250"/>
           <column name="FK_ID" type="INTEGER"/>
  -        <foreign-key foreignTable="CT_OBJECT_AAA">
  +        <column name="FK_ID_A" type="INTEGER"/>
  +        <foreign-key foreignTable="CT_OBJECT_AAAA">
               <reference local="FK_ID" foreign="OBJ_ID"/>
           </foreign-key>
       </table>
  -    <table name="CT_OBJECT_AAA">
  +
  +    <table name="CT_OBJECT_AA">
           <column name="OBJ_ID" required="true" primaryKey="true" type="INTEGER"/>
           <column name="NAME" type="VARCHAR" size="250"/>
           <column name="FK_ID" type="INTEGER"/>
  -        <column name="FK_ID_A" type="INTEGER"/>
  -        <foreign-key foreignTable="CT_OBJECT_AAAA">
  +        <foreign-key foreignTable="CT_OBJECT_AAA">
               <reference local="FK_ID" foreign="OBJ_ID"/>
           </foreign-key>
       </table>
  -    <table name="CT_OBJECT_AAAA">
  +
  +    <table name="CT_OBJECT_A">
           <column name="OBJ_ID" required="true" primaryKey="true" type="INTEGER"/>
           <column name="NAME" type="VARCHAR" size="250"/>
           <column name="FK_ID" type="INTEGER"/>
  +        <foreign-key foreignTable="CT_OBJECT_AA">
  +            <reference local="FK_ID" foreign="OBJ_ID"/>
  +        </foreign-key>
       </table>
   
       <!-- =================================================== -->
  
  
  

---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-dev-help@db.apache.org


Mime
View raw message