You are viewing a plain text version of this content. The canonical link for it is here.
Posted to torque-dev@db.apache.org by tf...@apache.org on 2005/05/05 10:14:44 UTC
cvs commit: db-torque/src/rttest test-schema.xml
tfischer 2005/05/05 01:14:44
Modified: src/rttest test-schema.xml
Log:
added a table to test primary keys which are also foreign keys, and a table to test lobs
Revision Changes Path
1.20 +23 -1 db-torque/src/rttest/test-schema.xml
Index: test-schema.xml
===================================================================
RCS file: /home/cvs/db-torque/src/rttest/test-schema.xml,v
retrieving revision 1.19
retrieving revision 1.20
diff -u -r1.19 -r1.20
--- test-schema.xml 23 Apr 2005 14:58:14 -0000 1.19
+++ test-schema.xml 5 May 2005 08:14:44 -0000 1.20
@@ -2,7 +2,7 @@
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database_3_2.dtd">
<!-- this schema is used to test problems users reported -->
-<database name="@DATABASE_DEFAULT@" defaultIdMethod="idbroker" package="org.apache.torque.test">
+<database name="@DATABASE_DEFAULT@" defaultIdMethod="@DATABASE_ID_METHOD@" package="org.apache.torque.test">
<external-schema filename="ext-schema.xml" />
@@ -169,5 +169,27 @@
<column name="LEAGUEYEAR" required="false" type="INTEGER" javaType="primitive"/>
<column name="LEAGUESCORETYPE" required="false" type="SMALLINT" default="0" javaType="primitive"/>
</table>
+
+ <!-- test primary keys which are foreign keys as well -->
+ <table name="multi_pk_foreign_key" idMethod="none">
+ <column name="id" primaryKey="true" required="true" type="INTEGER" />
+ <column name="integer_pk_id" primaryKey="true" required="true" type="INTEGER"/>
+ <column name="name" size="100" type="VARCHAR"/>
+
+ <foreign-key foreignTable="integer_pk">
+ <reference local="integer_pk_id" foreign="id"/>
+ </foreign-key>
+ </table>
+
+ <table name="integer_pk">
+ <column name="id" type="INTEGER" primaryKey="true" required="true"/>
+ <column name="name" size="100" type="VARCHAR"/>
+ </table>
+
+ <table name="lob_test">
+ <column name="id" required="true" primaryKey="true" type="long" />
+ <column name="blob" type="blob" required="false"/>
+ <column name="clob" type="clob" required="false"/>
+ </table>
</database>
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-dev-unsubscribe@db.apache.org
For additional commands, e-mail: torque-dev-help@db.apache.org