You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@turbine.apache.org by jm...@apache.org on 2002/03/08 00:29:54 UTC
cvs commit: jakarta-turbine-torque/src/rttest bookstore-schema.xml
jmcnally 02/03/07 15:29:54
Modified: src/rttest bookstore-schema.xml
Log:
Adds an associative table as and a table that references the associative table
Revision Changes Path
1.7 +116 -0 jakarta-turbine-torque/src/rttest/bookstore-schema.xml
Index: bookstore-schema.xml
===================================================================
RCS file: /home/cvs/jakarta-turbine-torque/src/rttest/bookstore-schema.xml,v
retrieving revision 1.6
retrieving revision 1.7
diff -u -r1.6 -r1.7
--- bookstore-schema.xml 18 Dec 2001 23:26:07 -0000 1.6
+++ bookstore-schema.xml 7 Mar 2002 23:29:54 -0000 1.7
@@ -66,4 +66,120 @@
</table>
+
+
+ <!-- =================================================== -->
+ <!-- A T A B L E -->
+ <!-- =================================================== -->
+
+ <table name="a" description="A table">
+ <column
+ name="a_id"
+ required="true"
+ primaryKey="true"
+ type="INTEGER"
+ />
+ <column
+ name="name"
+ required="true"
+ type="VARCHAR"
+ size="50"
+ />
+
+ </table>
+
+ <!-- =================================================== -->
+ <!-- B T A B L E -->
+ <!-- =================================================== -->
+
+ <table name="b" description="B table">
+ <column
+ name="b_id"
+ required="true"
+ primaryKey="true"
+ type="INTEGER"
+ />
+ <column
+ name="name"
+ required="true"
+ type="VARCHAR"
+ size="50"
+ />
+
+ </table>
+
+
+ <!-- =================================================== -->
+ <!-- AB T A B L E -->
+ <!-- =================================================== -->
+
+ <table name="r_ab" description="r_ab table" idMethod="none">
+ <column
+ name="a_id"
+ required="true"
+ primaryKey="true"
+ type="INTEGER"
+ />
+ <column
+ name="b_id"
+ required="true"
+ primaryKey="true"
+ type="INTEGER"
+ />
+ <column
+ name="name"
+ required="true"
+ type="VARCHAR"
+ size="50"
+ />
+
+ <foreign-key foreignTable="a">
+ <reference local="a_id" foreign="a_id"/>
+ </foreign-key>
+
+ <foreign-key foreignTable="b">
+ <reference local="b_id" foreign="b_id"/>
+ </foreign-key>
+
+ </table>
+
+ <!-- =================================================== -->
+ <!-- C T A B L E -->
+ <!-- =================================================== -->
+
+ <table name="c" description="c table contains fk to r_ab">
+ <column
+ name="c_id"
+ required="true"
+ primaryKey="true"
+ type="INTEGER"
+ />
+ <column
+ name="a_id"
+ required="true"
+ type="INTEGER"
+ />
+ <column
+ name="b_id"
+ required="true"
+ type="INTEGER"
+ />
+ <column
+ name="name"
+ required="true"
+ type="VARCHAR"
+ size="50"
+ />
+
+ <foreign-key foreignTable="r_ab">
+ <reference local="a_id" foreign="a_id"/>
+ <reference local="b_id" foreign="b_id"/>
+ </foreign-key>
+
+ <foreign-key foreignTable="b">
+ <reference local="b_id" foreign="b_id"/>
+ </foreign-key>
+
+ </table>
+
</database>
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>