db-torque-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From tfisc...@apache.org
Subject cvs commit: db-torque/src/rttest test-schema.xml
Date Thu, 05 May 2005 08:14:44 GMT
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


Mime
View raw message