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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
