db-jdo-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From mcai...@apache.org
Subject svn commit: r168361 - in /incubator/jdo/trunk/tck20: ./ test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/ test/orm/applicationidentity/org/apache/jdo/tck/pc/mylib/ test/orm/datastoreidentity/org/apache/jdo/tck/pc/mylib/ test/sql/derby/
Date Thu, 05 May 2005 17:49:09 GMT
Author: mcaisse
Date: Thu May  5 10:49:08 2005
New Revision: 168361

URL: http://svn.apache.org/viewcvs?rev=168361&view=rev
Log:
JDO-8 interim check-in; JDO-37 work-around

Added:
    incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/ListCollections-derby.orm
  (with props)
    incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/SetCollections-derby.orm
  (with props)
Modified:
    incubator/jdo/trunk/tck20/maven.xml
    incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/mylib/package-derby.orm
    incubator/jdo/trunk/tck20/test/orm/datastoreidentity/org/apache/jdo/tck/pc/mylib/package-derby.orm
    incubator/jdo/trunk/tck20/test/sql/derby/schema1.sql

Modified: incubator/jdo/trunk/tck20/maven.xml
URL: http://svn.apache.org/viewcvs/incubator/jdo/trunk/tck20/maven.xml?rev=168361&r1=168360&r2=168361&view=diff
==============================================================================
--- incubator/jdo/trunk/tck20/maven.xml (original)
+++ incubator/jdo/trunk/tck20/maven.xml Thu May  5 10:49:08 2005
@@ -409,7 +409,7 @@
     <!-- ==== -->
 
     <goal name="database">
-        <delete dir="${jdo.tck.testdir}/database/${jdo.tck.database}"/>
+<!--        <delete dir="${jdo.tck.testdir}/database/${jdo.tck.database}"/> -->
         <mkdir dir="${jdo.tck.testdir}/database/${jdo.tck.database}"/>
         <copy todir="${jdo.tck.testdir}/database/${jdo.tck.database}">
             <fileset dir="${basedir}/test/conf">

Added: incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/ListCollections-derby.orm
URL: http://svn.apache.org/viewcvs/incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/ListCollections-derby.orm?rev=168361&view=auto
==============================================================================
--- incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/ListCollections-derby.orm
(added)
+++ incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/ListCollections-derby.orm
Thu May  5 10:49:08 2005
@@ -0,0 +1,219 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE orm PUBLIC "-//Sun Microsystems, Inc.//DTD Java Data Objects Metadata 2.0//EN"
"http://java.sun.com/dtd/orm_2_0.dtd">
+<orm>
+    <package name="org.apache.jdo.tck.pc.fieldtypes">
+        <class name="ListCollections" table="LIST_COLLECTIONS">
+            <field name="identifier" column="IDENTIFIER" primary-key="true"/>
+            <field name="ListOfObject0" table="LIST_OF_OBJECT0">
+                <join column="IDENTIFIER"/>
+                <element column="OBJREF"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="ListOfObject1" table="LIST_OF_OBJECT1">
+                <join column="IDENTIFIER"/>
+                <element column="OBJREF"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="ListOfObject2" table="LIST_OF_OBJECT2">
+                <join column="IDENTIFIER"/>
+                <element column="OBJREF"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="ListOfSimpleClass3" table="LIST_OF_SIMPLE_CLASS3">
+                <join column="IDENTIFIER"/>
+                <element column="SIMPCLSREF"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="ListOfSimpleClass4" table="LIST_OF_SIMPLE_CLASS4">
+                <join column="IDENTIFIER"/>
+                <element column="SIMPCLSREF"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="ListOfSimpleClass5" table="LIST_OF_SIMPLE_CLASS5">
+                <join column="IDENTIFIER"/>
+                <element column="SIMPCLSREF"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="ListOfSimpleInterface6" table="LIST_OF_SIMPLE_INTERFACE6">
+                <join column="IDENTIFIER"/>
+                <element column="SIMPINTREF"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="ListOfSimpleInterface7" table="LIST_OF_SIMPLE_INTERFACE7">
+                <join column="IDENTIFIER"/>
+                <element column="SIMPINTREF"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="ListOfSimpleInterface8" table="LIST_OF_SIMPLE_INTERFACE8">
+                <join column="IDENTIFIER"/>
+                <element column="SIMPINTREF"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="ListOfString9" table="LIST_OF_STRING9">
+                <join column="IDENTIFIER"/>
+                <element column="STRINGVAL"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="ListOfString10" table="LIST_OF_STRING10">
+                <join column="IDENTIFIER"/>
+                <element column="STRINGVAL"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="ListOfString11" table="LIST_OF_STRING11">
+                <join column="IDENTIFIER"/>
+                <element column="STRINGVAL"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="ListOfDate12" table="LIST_OF_DATE12">
+                <join column="IDENTIFIER"/>
+                <element column="DATEVAL"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="ListOfDate13" table="LIST_OF_DATE13">
+                <join column="IDENTIFIER"/>
+                <element column="DATEVAL"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="ListOfDate14" table="LIST_OF_DATE14">
+                <join column="IDENTIFIER"/>
+                <element column="DATEVAL"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="ListOfLocale15" table="LIST_OF_LOCALE15">
+                <join column="IDENTIFIER"/>
+                <element column="LOCALEVAL"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="ListOfLocale16" table="LIST_OF_LOCALE16">
+                <join column="IDENTIFIER"/>
+                <element column="LOCALEVAL"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="ListOfLocale17" table="LIST_OF_LOCALE17">
+                <join column="IDENTIFIER"/>
+                <element column="LOCALEVAL"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="ListOfBigDecimal18" table="LIST_OF_BIG_DECIMAL18">
+                <join column="IDENTIFIER"/>
+                <element column="BIG_DECIMALVAL"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="ListOfBigDecimal19" table="LIST_OF_BIG_DECIMAL19">
+                <join column="IDENTIFIER"/>
+                <element column="BIG_DECIMALVAL"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="ListOfBigDecimal20" table="LIST_OF_BIG_DECIMAL20">
+                <join column="IDENTIFIER"/>
+                <element column="BIG_DECIMALVAL"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="ListOfBigInteger21" table="LIST_OF_BIG_INTEGER21">
+                <join column="IDENTIFIER"/>
+                <element column="BIG_INTEGERVAL"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="ListOfBigInteger22" table="LIST_OF_BIG_INTEGER22">
+                <join column="IDENTIFIER"/>
+                <element column="BIG_INTEGERVAL"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="ListOfBigInteger23" table="LIST_OF_BIG_INTEGER23">
+                <join column="IDENTIFIER"/>
+                <element column="BIG_INTEGERVAL"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="ListOfByte24" table="LIST_OF_BYTE24">
+                <join column="IDENTIFIER"/>
+                <element column="BYTEVAL"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="ListOfByte25" table="LIST_OF_BYTE25">
+                <join column="IDENTIFIER"/>
+                <element column="BYTEVAL"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="ListOfByte26" table="LIST_OF_BYTE27">
+                <join column="IDENTIFIER"/>
+                <element column="BYTEVAL"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="ListOfDouble27" table="LIST_OF_DOUBLE27">
+                <join column="IDENTIFIER"/>
+                <element column="DOUBLEVAL"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="ListOfDouble28" table="LIST_OF_DOUBLE28">
+                <join column="IDENTIFIER"/>
+                <element column="DOUBLEVAL"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="ListOfDouble29" table="LIST_OF_DOUBLE29">
+                <join column="IDENTIFIER"/>
+                <element column="DOUBLEVAL"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="ListOfFloat30" table="LIST_OF_FLOAT30">
+                <join column="IDENTIFIER"/>
+                <element column="FLOATVAL"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="ListOfFloat31" table="LIST_OF_FLOAT31">
+                <join column="IDENTIFIER"/>
+                <element column="FLOATVAL"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="ListOfFloat32" table="LIST_OF_FLOAT32">
+                <join column="IDENTIFIER"/>
+                <element column="FLOATVAL"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="ListOfInteger33" table="LIST_OF_INTEGER33">
+                <join column="IDENTIFIER"/>
+                <element column="INTEGERVAL"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="ListOfInteger34" table="LIST_OF_INTEGER34">
+                <join column="IDENTIFIER"/>
+                <element column="INTEGERVAL"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="ListOfInteger35" table="LIST_OF_INTEGER35">
+                <join column="IDENTIFIER"/>
+                <element column="INTEGERVAL"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="ListOfLong36" table="LIST_OF_LONG36">
+                <join column="IDENTIFIER"/>
+                <element column="LONGVAL"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="ListOfLong37" table="LIST_OF_LONG37">
+                <join column="IDENTIFIER"/>
+                <element column="LONGVAL"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="ListOfLong38" table="LIST_OF_LONG38">
+                <join column="IDENTIFIER"/>
+                <element column="LONGVAL"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="ListOfShort39" table="LIST_OF_SHORT39">
+                <join column="IDENTIFIER"/>
+                <element column="SHORTVAL"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="ListOfShort40" table="LIST_OF_SHORT40">
+                <join column="IDENTIFIER"/>
+                <element column="SHORTVAL"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="ListOfShort41" table="LIST_OF_SHORT41">
+                <join column="IDENTIFIER"/>
+                <element column="SHORTVAL"/>
+                <order column="INDEX"/>
+            </field>
+        </class>
+    </package>
+</orm>

Propchange: incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/ListCollections-derby.orm
------------------------------------------------------------------------------
    svn:executable = *

Added: incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/SetCollections-derby.orm
URL: http://svn.apache.org/viewcvs/incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/SetCollections-derby.orm?rev=168361&view=auto
==============================================================================
--- incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/SetCollections-derby.orm
(added)
+++ incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/SetCollections-derby.orm
Thu May  5 10:49:08 2005
@@ -0,0 +1,219 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE orm PUBLIC "-//Sun Microsystems, Inc.//DTD Java Data Objects Mapping Metadata
2.0//EN" "http://java.sun.com/dtd/orm_2_0.dtd">
+<orm>
+    <package name="org.apache.jdo.tck.pc.fieldtypes">
+        <class name="SetCollections" table="SET_COLLECTIONS">
+            <field name="identifier" column="IDENTIFIER" primary-key="true"/>
+            <field name="SetOfObject0" table="SET_OF_OBJECT0">
+                <join column="IDENTIFIER"/>
+                <element column="OBJREF"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="SetOfObject1" table="SET_OF_OBJECT1">
+                <join column="IDENTIFIER"/>
+                <element column="OBJREF"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="SetOfObject2" table="SET_OF_OBJECT2">
+                <join column="IDENTIFIER"/>
+                <element column="OBJREF"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="SetOfSimpleClass3" table="SET_OF_SIMPLE_CLASS3">
+                <join column="IDENTIFIER"/>
+                <element column="SIMPCLSREF"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="SetOfSimpleClass4" table="SET_OF_SIMPLE_CLASS4">
+                <join column="IDENTIFIER"/>
+                <element column="SIMPCLSREF"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="SetOfSimpleClass5" table="SET_OF_SIMPLE_CLASS5">
+                <join column="IDENTIFIER"/>
+                <element column="SIMPCLSREF"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="SetOfSimpleInterface6" table="SET_OF_SIMPLE_INTERFACE6">
+                <join column="IDENTIFIER"/>
+                <element column="SIMPINTREF"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="SetOfSimpleInterface7" table="SET_OF_SIMPLE_INTERFACE7">
+                <join column="IDENTIFIER"/>
+                <element column="SIMPINTREF"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="SetOfSimpleInterface8" table="SET_OF_SIMPLE_INTERFACE8">
+                <join column="IDENTIFIER"/>
+                <element column="SIMPINTREF"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="SetOfString9" table="SET_OF_STRING9">
+                <join column="IDENTIFIER"/>
+                <element column="STRINGVAL"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="SetOfString10" table="SET_OF_STRING10">
+                <join column="IDENTIFIER"/>
+                <element column="STRINGVAL"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="SetOfString11" table="SET_OF_STRING11">
+                <join column="IDENTIFIER"/>
+                <element column="STRINGVAL"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="SetOfDate12" table="SET_OF_DATE12">
+                <join column="IDENTIFIER"/>
+                <element column="DATEVAL"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="SetOfDate13" table="SET_OF_DATE13">
+                <join column="IDENTIFIER"/>
+                <element column="DATEVAL"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="SetOfDate14" table="SET_OF_DATE14">
+                <join column="IDENTIFIER"/>
+                <element column="DATEVAL"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="SetOfLocale15" table="SET_OF_LOCALE15">
+                <join column="IDENTIFIER"/>
+                <element column="LOCALEVAL"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="SetOfLocale16" table="SET_OF_LOCALE16">
+                <join column="IDENTIFIER"/>
+                <element column="LOCALEVAL"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="SetOfLocale17" table="SET_OF_LOCALE17">
+                <join column="IDENTIFIER"/>
+                <element column="LOCALEVAL"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="SetOfBigDecimal18" table="SET_OF_BIG_DECIMAL18">
+                <join column="IDENTIFIER"/>
+                <element column="BIG_DECIMALVAL"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="SetOfBigDecimal19" table="SET_OF_BIG_DECIMAL19">
+                <join column="IDENTIFIER"/>
+                <element column="BIG_DECIMALVAL"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="SetOfBigDecimal20" table="SET_OF_BIG_DECIMAL20">
+                <join column="IDENTIFIER"/>
+                <element column="BIG_DECIMALVAL"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="SetOfBigInteger21" table="SET_OF_BIG_INTEGER21">
+                <join column="IDENTIFIER"/>
+                <element column="BIG_INTEGERVAL"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="SetOfBigInteger22" table="SET_OF_BIG_INTEGER22">
+                <join column="IDENTIFIER"/>
+                <element column="BIG_INTEGERVAL"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="SetOfBigInteger23" table="SET_OF_BIG_INTEGER23">
+                <join column="IDENTIFIER"/>
+                <element column="BIG_INTEGERVAL"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="SetOfByte24" table="SET_OF_BYTE24">
+                <join column="IDENTIFIER"/>
+                <element column="BYTEVAL"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="SetOfByte25" table="SET_OF_BYTE25">
+                <join column="IDENTIFIER"/>
+                <element column="BYTEVAL"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="SetOfByte26" table="SET_OF_BYTE27">
+                <join column="IDENTIFIER"/>
+                <element column="BYTEVAL"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="SetOfDouble27" table="SET_OF_DOUBLE27">
+                <join column="IDENTIFIER"/>
+                <element column="DOUBLEVAL"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="SetOfDouble28" table="SET_OF_DOUBLE28">
+                <join column="IDENTIFIER"/>
+                <element column="DOUBLEVAL"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="SetOfDouble29" table="SET_OF_DOUBLE29">
+                <join column="IDENTIFIER"/>
+                <element column="DOUBLEVAL"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="SetOfFloat30" table="SET_OF_FLOAT30">
+                <join column="IDENTIFIER"/>
+                <element column="FLOATVAL"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="SetOfFloat31" table="SET_OF_FLOAT31">
+                <join column="IDENTIFIER"/>
+                <element column="FLOATVAL"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="SetOfFloat32" table="SET_OF_FLOAT32">
+                <join column="IDENTIFIER"/>
+                <element column="FLOATVAL"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="SetOfInteger33" table="SET_OF_INTEGER33">
+                <join column="IDENTIFIER"/>
+                <element column="INTEGERVAL"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="SetOfInteger34" table="SET_OF_INTEGER34">
+                <join column="IDENTIFIER"/>
+                <element column="INTEGERVAL"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="SetOfInteger35" table="SET_OF_INTEGER35">
+                <join column="IDENTIFIER"/>
+                <element column="INTEGERVAL"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="SetOfLong36" table="SET_OF_LONG36">
+                <join column="IDENTIFIER"/>
+                <element column="LONGVAL"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="SetOfLong37" table="SET_OF_LONG37">
+                <join column="IDENTIFIER"/>
+                <element column="LONGVAL"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="SetOfLong38" table="SET_OF_LONG38">
+                <join column="IDENTIFIER"/>
+                <element column="LONGVAL"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="SetOfShort39" table="SET_OF_SHORT39">
+                <join column="IDENTIFIER"/>
+                <element column="SHORTVAL"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="SetOfShort40" table="SET_OF_SHORT40">
+                <join column="IDENTIFIER"/>
+                <element column="SHORTVAL"/>
+                <order column="INDEX"/>
+            </field>
+            <field name="SetOfShort41" table="SET_OF_SHORT41">
+                <join column="IDENTIFIER"/>
+                <element column="SHORTVAL"/>
+                <order column="INDEX"/>
+            </field>
+        </class>
+    </package>
+</orm>

Propchange: incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/SetCollections-derby.orm
------------------------------------------------------------------------------
    svn:executable = *

Modified: incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/mylib/package-derby.orm
URL: http://svn.apache.org/viewcvs/incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/mylib/package-derby.orm?rev=168361&r1=168360&r2=168361&view=diff
==============================================================================
--- incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/mylib/package-derby.orm
(original)
+++ incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/mylib/package-derby.orm
Thu May  5 10:49:08 2005
@@ -17,8 +17,12 @@
 
     <class name="PCRect" table="PCRect">
       <field name="id" column="ID" primary-key="true"/>
-      <field name="lowerRight" column="LOWER_RIGHT" foreign-key="true"/>
-      <field name="upperLeft" column="UPPER_LEFT" foreign-key="true"/>
+      <field name="lowerRight" column="LOWER_RIGHT">
+        <foreign-key/>
+      </field>
+      <field name="upperLeft" column="UPPER_LEFT">
+        <foreign-key/>
+      </field>
     </class>
 
     <class name="PrimitiveTypes" table="PrimitiveTypes">

Modified: incubator/jdo/trunk/tck20/test/orm/datastoreidentity/org/apache/jdo/tck/pc/mylib/package-derby.orm
URL: http://svn.apache.org/viewcvs/incubator/jdo/trunk/tck20/test/orm/datastoreidentity/org/apache/jdo/tck/pc/mylib/package-derby.orm?rev=168361&r1=168360&r2=168361&view=diff
==============================================================================
--- incubator/jdo/trunk/tck20/test/orm/datastoreidentity/org/apache/jdo/tck/pc/mylib/package-derby.orm
(original)
+++ incubator/jdo/trunk/tck20/test/orm/datastoreidentity/org/apache/jdo/tck/pc/mylib/package-derby.orm
Thu May  5 10:49:08 2005
@@ -17,8 +17,12 @@
 
     <class name="PCRect" table="PCRect">
       <datastore-identity strategy="identity" column="ID"/>
-      <field name="lowerRight" column="LOWER_RIGHT" foreign-key="true"/>
-      <field name="upperLeft" column="UPPER_LEFT" foreign-key="true"/>
+      <field name="lowerRight" column="LOWER_RIGHT">
+        <foreign-key/>
+      </field>
+      <field name="upperLeft" column="UPPER_LEFT">
+        <foreign-key/>
+      </field>
     </class>
 
     <class name="PrimitiveTypes" table="PrimitiveTypes">

Modified: incubator/jdo/trunk/tck20/test/sql/derby/schema1.sql
URL: http://svn.apache.org/viewcvs/incubator/jdo/trunk/tck20/test/sql/derby/schema1.sql?rev=168361&r1=168360&r2=168361&view=diff
==============================================================================
--- incubator/jdo/trunk/tck20/test/sql/derby/schema1.sql (original)
+++ incubator/jdo/trunk/tck20/test/sql/derby/schema1.sql Thu May  5 10:49:08 2005
@@ -6,9 +6,9 @@
 -- mylib
 -------------------------
 
+DROP TABLE PCRect;
 DROP TABLE PCPoint;
 DROP TABLE PCPoint2;
-DROP TABLE PCRect;
 DROP TABLE PrimitiveTypes;
 
 CREATE TABLE PCPoint (
@@ -62,6 +62,7 @@
 -- company
 -------------------------
 
+ALTER TABLE departments DROP CONSTRAINT EMP_MO_FK;
 DROP TABLE insuranceplans;
 DROP TABLE project_reviewer;
 DROP TABLE project_member;
@@ -157,32 +158,6 @@
 --fieldtypes
 -------------------------
 
-DROP TABLE SIMPLE_CLASS;
-DROP TABLE FIELDSOFSIMPLECLASS;
-DROP TABLE FieldsOfByte;
-DROP TABLE FIELDSOFBIGDECIMAL;
-DROP TABLE FIELDSOFBIGINTEGER;
-DROP TABLE FIELDSOFBOOLEAN;
-DROP TABLE FIELDSOFCHARACTER;
-DROP TABLE FIELDSOFDATE;
-DROP TABLE FIELDSOFDOUBLE;
-DROP TABLE FIELDSOFFLOAT;
-DROP TABLE FIELDSOFINTEGER;
-DROP TABLE FIELDSOFLOCALE;
-DROP TABLE FIELDSOFLONG;
-DROP TABLE FIELDSOFOBJECT;
-DROP TABLE FIELDSOFPRIMITIVEBOOLEAN;
-DROP TABLE FIELDSOFPRIMITIVEBYTE;
-DROP TABLE FIELDSOFPRIMITIVECHAR;
-DROP TABLE FIELDSOFPRIMITIVEDOUBLE;
-DROP TABLE FIELDSOFPRIMITIVEFLOAT;
-DROP TABLE FIELDSOFPRIMITIVEINT;
-DROP TABLE FIELDSOFPRIMITIVELONG;
-DROP TABLE FIELDSOFPRIMITIVESHORT;
-DROP TABLE FIELDSOFSHORT;
-DROP TABLE FIELDSOFSTRING;
-DROP TABLE ARRAY_COLLECTIONS;
-DROP TABLE COLLECTION_COLLECTIONS;
 DROP TABLE COLLECTION_OF_OBJECT0;
 DROP TABLE COLLECTION_OF_OBJECT1;
 DROP TABLE COLLECTION_OF_SIMPLE_CLASS2;
@@ -211,7 +186,121 @@
 DROP TABLE COLLECTION_OF_LONG25;
 DROP TABLE COLLECTION_OF_SHORT26;
 DROP TABLE COLLECTION_OF_SHORT27;
+DROP TABLE COLLECTION_COLLECTIONS;
 
+DROP TABLE LIST_OF_OBJECT0;
+DROP TABLE LIST_OF_OBJECT1;
+DROP TABLE LIST_OF_OBJECT2;
+DROP TABLE LIST_OF_SIMPLE_CLASS3;
+DROP TABLE LIST_OF_SIMPLE_CLASS4;
+DROP TABLE LIST_OF_SIMPLE_CLASS5;
+DROP TABLE LIST_OF_SIMPLE_INTERFACE6;
+DROP TABLE LIST_OF_SIMPLE_INTERFACE7;
+DROP TABLE LIST_OF_SIMPLE_INTERFACE8;
+DROP TABLE LIST_OF_STRING9;
+DROP TABLE LIST_OF_STRING10;
+DROP TABLE LIST_OF_STRING11;
+DROP TABLE LIST_OF_DATE12;
+DROP TABLE LIST_OF_DATE13;
+DROP TABLE LIST_OF_DATE14;
+DROP TABLE LIST_OF_LOCALE15;
+DROP TABLE LIST_OF_LOCALE16;
+DROP TABLE LIST_OF_LOCALE17;
+DROP TABLE LIST_OF_BIG_DECIMAL18;
+DROP TABLE LIST_OF_BIG_DECIMAL19;
+DROP TABLE LIST_OF_BIG_DECIMAL20;
+DROP TABLE LIST_OF_BIG_INTEGER21;
+DROP TABLE LIST_OF_BIG_INTEGER22;
+DROP TABLE LIST_OF_BIG_INTEGER23;
+DROP TABLE LIST_OF_BYTE24;
+DROP TABLE LIST_OF_BYTE25;
+DROP TABLE LIST_OF_BYTE26;
+DROP TABLE LIST_OF_DOUBLE27;
+DROP TABLE LIST_OF_DOUBLE28;
+DROP TABLE LIST_OF_DOUBLE29;
+DROP TABLE LIST_OF_FLOAT30;
+DROP TABLE LIST_OF_FLOAT31;
+DROP TABLE LIST_OF_FLOAT32;
+DROP TABLE LIST_OF_INTEGER33;
+DROP TABLE LIST_OF_INTEGER34;
+DROP TABLE LIST_OF_INTEGER35;
+DROP TABLE LIST_OF_LONG36;
+DROP TABLE LIST_OF_LONG37;
+DROP TABLE LIST_OF_LONG38;
+DROP TABLE LIST_OF_SHORT39;
+DROP TABLE LIST_OF_SHORT40;
+DROP TABLE LIST_OF_SHORT41;
+DROP TABLE LIST_COLLECTIONS;
+
+DROP TABLE SET_OF_OBJECT0;
+DROP TABLE SET_OF_OBJECT1;
+DROP TABLE SET_OF_OBJECT2;
+DROP TABLE SET_OF_SIMPLE_CLASS3;
+DROP TABLE SET_OF_SIMPLE_CLASS4;
+DROP TABLE SET_OF_SIMPLE_CLASS5;
+DROP TABLE SET_OF_SIMPLE_INTERFACE6;
+DROP TABLE SET_OF_SIMPLE_INTERFACE7;
+DROP TABLE SET_OF_SIMPLE_INTERFACE8;
+DROP TABLE SET_OF_STRING9;
+DROP TABLE SET_OF_STRING10;
+DROP TABLE SET_OF_STRING11;
+DROP TABLE SET_OF_DATE12;
+DROP TABLE SET_OF_DATE13;
+DROP TABLE SET_OF_DATE14;
+DROP TABLE SET_OF_LOCALE15;
+DROP TABLE SET_OF_LOCALE16;
+DROP TABLE SET_OF_LOCALE17;
+DROP TABLE SET_OF_BIG_DECIMAL18;
+DROP TABLE SET_OF_BIG_DECIMAL19;
+DROP TABLE SET_OF_BIG_DECIMAL20;
+DROP TABLE SET_OF_BIG_INTEGER21;
+DROP TABLE SET_OF_BIG_INTEGER22;
+DROP TABLE SET_OF_BIG_INTEGER23;
+DROP TABLE SET_OF_BYTE24;
+DROP TABLE SET_OF_BYTE25;
+DROP TABLE SET_OF_BYTE26;
+DROP TABLE SET_OF_DOUBLE27;
+DROP TABLE SET_OF_DOUBLE28;
+DROP TABLE SET_OF_DOUBLE29;
+DROP TABLE SET_OF_FLOAT30;
+DROP TABLE SET_OF_FLOAT31;
+DROP TABLE SET_OF_FLOAT32;
+DROP TABLE SET_OF_INTEGER33;
+DROP TABLE SET_OF_INTEGER34;
+DROP TABLE SET_OF_INTEGER35;
+DROP TABLE SET_OF_LONG36;
+DROP TABLE SET_OF_LONG37;
+DROP TABLE SET_OF_LONG38;
+DROP TABLE SET_OF_SHORT39;
+DROP TABLE SET_OF_SHORT40;
+DROP TABLE SET_OF_SHORT41;
+DROP TABLE SET_COLLECTIONS;
+
+DROP TABLE FIELDSOFSIMPLECLASS;
+DROP TABLE SIMPLE_CLASS;
+DROP TABLE FIELDSOFBYTE;
+DROP TABLE FIELDSOFBIGDECIMAL;
+DROP TABLE FIELDSOFBIGINTEGER;
+DROP TABLE FIELDSOFBOOLEAN;
+DROP TABLE FIELDSOFCHARACTER;
+DROP TABLE FIELDSOFDATE;
+DROP TABLE FIELDSOFDOUBLE;
+DROP TABLE FIELDSOFFLOAT;
+DROP TABLE FIELDSOFINTEGER;
+DROP TABLE FIELDSOFLOCALE;
+DROP TABLE FIELDSOFLONG;
+DROP TABLE FIELDSOFOBJECT;
+DROP TABLE FIELDSOFPRIMITIVEBOOLEAN;
+DROP TABLE FIELDSOFPRIMITIVEBYTE;
+DROP TABLE FIELDSOFPRIMITIVECHAR;
+DROP TABLE FIELDSOFPRIMITIVEDOUBLE;
+DROP TABLE FIELDSOFPRIMITIVEFLOAT;
+DROP TABLE FIELDSOFPRIMITIVEINT;
+DROP TABLE FIELDSOFPRIMITIVELONG;
+DROP TABLE FIELDSOFPRIMITIVESHORT;
+DROP TABLE FIELDSOFSHORT;
+DROP TABLE FIELDSOFSTRING;
+DROP TABLE ARRAY_COLLECTIONS;
 
 CREATE TABLE FIELDSOFBIGDECIMAL
 (
@@ -2092,7 +2181,6 @@
 
 --CollectionCollections
 
-
 CREATE TABLE COLLECTION_COLLECTIONS
 (
     IDENTIFIER INTEGER NOT NULL,
@@ -2265,6 +2353,610 @@
 (
     IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL,
     SHORTVAL SMALLINT
+);
+
+--ListCollections
+
+
+CREATE TABLE LIST_COLLECTIONS
+(
+    IDENTIFIER INTEGER NOT NULL,
+    CONSTRAINT LC_PK PRIMARY KEY (IDENTIFIER)
+);
+
+CREATE TABLE LIST_OF_OBJECT0
+(
+    IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
+    OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE LIST_OF_OBJECT1
+(
+    IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
+    OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE LIST_OF_OBJECT2
+(
+    IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
+    OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE LIST_OF_SIMPLE_CLASS3
+(
+    IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
+    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE LIST_OF_SIMPLE_CLASS4
+(
+    IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
+    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE LIST_OF_SIMPLE_CLASS5
+(
+    IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
+    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE LIST_OF_SIMPLE_INTERFACE6
+(
+    IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
+    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE LIST_OF_SIMPLE_INTERFACE7
+(
+    IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
+    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE LIST_OF_SIMPLE_INTERFACE8
+(
+    IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
+    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE LIST_OF_STRING9
+(
+    IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
+    STRINGVAL VARCHAR(1024),
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE LIST_OF_STRING10
+(
+    IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
+    STRINGVAL VARCHAR(1024),
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE LIST_OF_STRING11
+(
+    IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
+    STRINGVAL VARCHAR(1024),
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE LIST_OF_DATE12
+(
+    IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
+    DATEVAL DATE,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE LIST_OF_DATE13
+(
+    IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
+    DATEVAL DATE,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE LIST_OF_DATE14
+(
+    IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
+    DATEVAL DATE,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE LIST_OF_LOCALE15
+(
+    IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
+    LOCALEVAL CHAR(20),
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE LIST_OF_LOCALE16
+(
+    IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
+    LOCALEVAL CHAR(20),
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE LIST_OF_LOCALE17
+(
+    IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
+    LOCALEVAL CHAR(20),
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE LIST_OF_BIG_DECIMAL18
+(
+    IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
+    BIG_DECIMALVAL LONG VARCHAR FOR BIT DATA,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE LIST_OF_BIG_DECIMAL19
+(
+    IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
+    BIG_DECIMALVAL LONG VARCHAR FOR BIT DATA,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE LIST_OF_BIG_DECIMAL20
+(
+    IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
+    BIG_DECIMALVAL LONG VARCHAR FOR BIT DATA,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE LIST_OF_BIG_INTEGER21
+(
+    IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
+    BIG_INTEGERVAL BIGINT,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE LIST_OF_BIG_INTEGER22
+(
+    IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
+    BIG_INTEGERVAL BIGINT,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE LIST_OF_BIG_INTEGER23
+(
+    IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
+    BIG_INTEGERVAL BIGINT,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE LIST_OF_BYTE24
+(
+    IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
+    BYTEVAL SMALLINT,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE LIST_OF_BYTE25
+(
+    IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
+    BYTEVAL SMALLINT,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE LIST_OF_BYTE26
+(
+    IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
+    BYTEVAL SMALLINT,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE LIST_OF_DOUBLE27
+(
+    IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
+    DOUBLEVAL DOUBLE,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE LIST_OF_DOUBLE28
+(
+    IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
+    DOUBLEVAL DOUBLE,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE LIST_OF_DOUBLE29
+(
+    IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
+    DOUBLEVAL DOUBLE,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE LIST_OF_FLOAT30
+(
+    IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
+    FLOATVAL FLOAT,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE LIST_OF_FLOAT31
+(
+    IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
+    FLOATVAL FLOAT,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE LIST_OF_FLOAT32
+(
+    IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
+    FLOATVAL FLOAT,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE LIST_OF_INTEGER33
+(
+    IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
+    INTEGERVAL INTEGER,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE LIST_OF_INTEGER34
+(
+    IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
+    INTEGERVAL INTEGER,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE LIST_OF_INTEGER35
+(
+    IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
+    INTEGERVAL INTEGER,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE LIST_OF_LONG36
+(
+    IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
+    LONGVAL BIGINT,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE LIST_OF_LONG37
+(
+    IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
+    LONGVAL BIGINT,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE LIST_OF_LONG38
+(
+    IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
+    LONGVAL BIGINT,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE LIST_OF_SHORT39
+(
+    IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
+    SHORTVAL SMALLINT,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE LIST_OF_SHORT40
+(
+    IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
+    SHORTVAL SMALLINT,
+    INDEX INTEGER NOT NULL
+);
+CREATE TABLE LIST_OF_SHORT41
+(
+    IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
+    SHORTVAL SMALLINT,
+    INDEX INTEGER NOT NULL
+);
+
+--SetCollections
+
+
+CREATE TABLE SET_COLLECTIONS
+(
+    IDENTIFIER INTEGER NOT NULL,
+    CONSTRAINT SC_PK PRIMARY KEY (IDENTIFIER)
+);
+
+CREATE TABLE SET_OF_OBJECT0
+(
+    IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+    OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE SET_OF_OBJECT1
+(
+    IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+    OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE SET_OF_OBJECT2
+(
+    IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+    OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE SET_OF_SIMPLE_CLASS3
+(
+    IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE SET_OF_SIMPLE_CLASS4
+(
+    IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE SET_OF_SIMPLE_CLASS5
+(
+    IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE SET_OF_SIMPLE_INTERFACE6
+(
+    IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE SET_OF_SIMPLE_INTERFACE7
+(
+    IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE SET_OF_SIMPLE_INTERFACE8
+(
+    IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE SET_OF_STRING9
+(
+    IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+    STRINGVAL VARCHAR(1024),
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE SET_OF_STRING10
+(
+    IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+    STRINGVAL VARCHAR(1024),
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE SET_OF_STRING11
+(
+    IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+    STRINGVAL VARCHAR(1024),
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE SET_OF_DATE12
+(
+    IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+    DATEVAL DATE,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE SET_OF_DATE13
+(
+    IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+    DATEVAL DATE,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE SET_OF_DATE14
+(
+    IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+    DATEVAL DATE,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE SET_OF_LOCALE15
+(
+    IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+    LOCALEVAL CHAR(20),
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE SET_OF_LOCALE16
+(
+    IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+    LOCALEVAL CHAR(20),
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE SET_OF_LOCALE17
+(
+    IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+    LOCALEVAL CHAR(20),
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE SET_OF_BIG_DECIMAL18
+(
+    IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+    BIG_DECIMALVAL LONG VARCHAR FOR BIT DATA,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE SET_OF_BIG_DECIMAL19
+(
+    IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+    BIG_DECIMALVAL LONG VARCHAR FOR BIT DATA,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE SET_OF_BIG_DECIMAL20
+(
+    IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+    BIG_DECIMALVAL LONG VARCHAR FOR BIT DATA,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE SET_OF_BIG_INTEGER21
+(
+    IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+    BIG_INTEGERVAL BIGINT,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE SET_OF_BIG_INTEGER22
+(
+    IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+    BIG_INTEGERVAL BIGINT,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE SET_OF_BIG_INTEGER23
+(
+    IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+    BIG_INTEGERVAL BIGINT,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE SET_OF_BYTE24
+(
+    IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+    BYTEVAL SMALLINT,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE SET_OF_BYTE25
+(
+    IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+    BYTEVAL SMALLINT,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE SET_OF_BYTE26
+(
+    IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+    BYTEVAL SMALLINT,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE SET_OF_DOUBLE27
+(
+    IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+    DOUBLEVAL DOUBLE,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE SET_OF_DOUBLE28
+(
+    IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+    DOUBLEVAL DOUBLE,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE SET_OF_DOUBLE29
+(
+    IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+    DOUBLEVAL DOUBLE,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE SET_OF_FLOAT30
+(
+    IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+    FLOATVAL FLOAT,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE SET_OF_FLOAT31
+(
+    IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+    FLOATVAL FLOAT,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE SET_OF_FLOAT32
+(
+    IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+    FLOATVAL FLOAT,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE SET_OF_INTEGER33
+(
+    IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+    INTEGERVAL INTEGER,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE SET_OF_INTEGER34
+(
+    IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+    INTEGERVAL INTEGER,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE SET_OF_INTEGER35
+(
+    IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+    INTEGERVAL INTEGER,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE SET_OF_LONG36
+(
+    IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+    LONGVAL BIGINT,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE SET_OF_LONG37
+(
+    IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+    LONGVAL BIGINT,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE SET_OF_LONG38
+(
+    IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+    LONGVAL BIGINT,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE SET_OF_SHORT39
+(
+    IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+    SHORTVAL SMALLINT,
+    INDEX INTEGER NOT NULL
+);
+
+CREATE TABLE SET_OF_SHORT40
+(
+    IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+    SHORTVAL SMALLINT,
+    INDEX INTEGER NOT NULL
+);
+CREATE TABLE SET_OF_SHORT41
+(
+    IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+    SHORTVAL SMALLINT,
+    INDEX INTEGER NOT NULL
 );
 
 -------------------------



Mime
View raw message