cvs commit: db-torque/src/rttest test-schema.xml

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

cvs commit: db-torque/src/rttest test-schema.xml

tfischer
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: [hidden email]
For additional commands, e-mail: [hidden email]