db-jdo-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From mcai...@apache.org
Subject svn commit: r231540 [2/2] - in /incubator/jdo/trunk/tck20/test: java/org/apache/jdo/tck/pc/fieldtypes/ jdo/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/ jdo/datastoreidentity/org/apache/jdo/tck/pc/fieldtypes/ orm/applicationidentity/org/apache/...
Date Thu, 11 Aug 2005 23:37:15 GMT
Modified: incubator/jdo/trunk/tck20/test/orm/datastoreidentity/org/apache/jdo/tck/pc/fieldtypes/FieldsOfObject-derby.orm
URL: http://svn.apache.org/viewcvs/incubator/jdo/trunk/tck20/test/orm/datastoreidentity/org/apache/jdo/tck/pc/fieldtypes/FieldsOfObject-derby.orm?rev=231540&r1=231539&r2=231540&view=diff
==============================================================================
--- incubator/jdo/trunk/tck20/test/orm/datastoreidentity/org/apache/jdo/tck/pc/fieldtypes/FieldsOfObject-derby.orm (original)
+++ incubator/jdo/trunk/tck20/test/orm/datastoreidentity/org/apache/jdo/tck/pc/fieldtypes/FieldsOfObject-derby.orm Thu Aug 11 16:36:56 2005
@@ -6,77 +6,173 @@
             <datastore-identity strategy="identity" column="DATASTORE_IDENTITY"/>
             <field name="identifier" column="IDENTIFIER"/>
             <field name="Object0" column="OBJECT0"/>
-            <field name="Object1" column="OBJECT1"/>
-            <field name="Object102" column="OBJECT102"/>
-            <field name="Object103" column="OBJECT103"/>
-            <field name="Object104" column="OBJECT104"/>
-            <field name="Object108" column="OBJECT108"/>
-            <field name="Object109" column="OBJECT109"/>
-            <field name="Object11" column="OBJECT11"/>
-            <field name="Object110" column="OBJECT110"/>
-            <field name="Object112" column="OBJECT112"/>
-            <field name="Object113" column="OBJECT113"/>
-            <field name="Object114" column="OBJECT114"/>
-            <field name="Object119" column="OBJECT119"/>
-            <field name="Object12" column="OBJECT12"/>
-            <field name="Object120" column="OBJECT120"/>
-            <field name="Object121" column="OBJECT121"/>
-            <field name="Object124" column="OBJECT124"/>
-            <field name="Object125" column="OBJECT125"/>
-            <field name="Object126" column="OBJECT126"/>
-            <field name="Object128" column="OBJECT128"/>
-            <field name="Object129" column="OBJECT129"/>
-            <field name="Object13" column="OBJECT13"/>
-            <field name="Object130" column="OBJECT130"/>
-            <field name="Object138" column="OBJECT138"/>
-            <field name="Object139" column="OBJECT139"/>
-            <field name="Object140" column="OBJECT140"/>
-            <field name="Object16" column="OBJECT16"/>
-            <field name="Object17" column="OBJECT17"/>
-            <field name="Object18" column="OBJECT18"/>
-            <field name="Object2" column="OBJECT2"/>
-            <field name="Object20" column="OBJECT20"/>
-            <field name="Object21" column="OBJECT21"/>
-            <field name="Object22" column="OBJECT22"/>
-            <field name="Object30" column="OBJECT30"/>
-            <field name="Object31" column="OBJECT31"/>
-            <field name="Object32" column="OBJECT32"/>
-            <field name="Object36" column="OBJECT36"/>
-            <field name="Object37" column="OBJECT37"/>
-            <field name="Object38" column="OBJECT38"/>
-            <field name="Object4" column="OBJECT4"/>
-            <field name="Object40" column="OBJECT40"/>
-            <field name="Object41" column="OBJECT41"/>
-            <field name="Object42" column="OBJECT42"/>
-            <field name="Object47" column="OBJECT47"/>
-            <field name="Object48" column="OBJECT48"/>
-            <field name="Object49" column="OBJECT49"/>
-            <field name="Object5" column="OBJECT5"/>
-            <field name="Object52" column="OBJECT52"/>
-            <field name="Object53" column="OBJECT53"/>
-            <field name="Object54" column="OBJECT54"/>
-            <field name="Object56" column="OBJECT56"/>
-            <field name="Object57" column="OBJECT57"/>
-            <field name="Object58" column="OBJECT58"/>
-            <field name="Object6" column="OBJECT6"/>
-            <field name="Object66" column="OBJECT66"/>
-            <field name="Object67" column="OBJECT67"/>
-            <field name="Object68" column="OBJECT68"/>
-            <field name="Object72" column="OBJECT72"/>
-            <field name="Object73" column="OBJECT73"/>
-            <field name="Object74" column="OBJECT74"/>
-            <field name="Object76" column="OBJECT76"/>
-            <field name="Object77" column="OBJECT77"/>
-            <field name="Object78" column="OBJECT78"/>
-            <field name="Object83" column="OBJECT83"/>
-            <field name="Object84" column="OBJECT84"/>
-            <field name="Object85" column="OBJECT85"/>
-            <field name="Object88" column="OBJECT88"/>
-            <field name="Object89" column="OBJECT89"/>
-            <field name="Object90" column="OBJECT90"/>
-            <field name="Object92" column="OBJECT92"/>
-            <field name="Object93" column="OBJECT93"/>
-            <field name="Object94" column="OBJECT94"/>
+            <field name="Object1" column="OBJECT1">
+            </field>
+            <field name="Object102" column="OBJECT102">
+                <foreign-key/>
+            </field>
+            <field name="Object103" column="OBJECT103">
+            </field>
+            <field name="Object104" column="OBJECT104">
+                <foreign-key/>
+            </field>
+            <field name="Object109" column="OBJECT109">
+            </field>
+            <field name="Object11" column="OBJECT11">
+                <foreign-key/>
+            </field>
+            <field name="Object110" column="OBJECT110">
+            </field>
+            <field name="Object112" column="OBJECT112">
+                <foreign-key/>
+            </field>
+            <field name="Object113" column="OBJECT113">
+            </field>
+            <field name="Object114" column="OBJECT114">
+                <foreign-key/>
+            </field>
+            <field name="Object119" column="OBJECT119">
+                <foreign-key/>
+            </field>
+            <field name="Object12" column="OBJECT12">
+            </field>
+            <field name="Object120" column="OBJECT120">
+            </field>
+            <field name="Object121" column="OBJECT121">
+                <foreign-key/>
+            </field>
+            <field name="Object125" column="OBJECT125">
+            </field>
+            <field name="Object126" column="OBJECT126">
+                <foreign-key/>
+            </field>
+            <field name="Object128" column="OBJECT128">
+                <foreign-key/>
+            </field>
+            <field name="Object129" column="OBJECT129">
+            </field>
+            <field name="Object13" column="OBJECT13">
+                <foreign-key/>
+            </field>
+            <field name="Object130" column="OBJECT130">
+                <foreign-key/>
+            </field>
+            <field name="Object138" column="OBJECT138">
+                <foreign-key/>
+            </field>
+            <field name="Object139" column="OBJECT139">
+            </field>
+            <field name="Object140" column="OBJECT140">
+                <foreign-key/>
+            </field>
+            <field name="Object17" column="OBJECT17">
+            </field>
+            <field name="Object18" column="OBJECT18">
+                <foreign-key/>
+            </field>
+            <field name="Object2" column="OBJECT2">
+                <foreign-key/>
+            </field>
+            <field name="Object20" column="OBJECT20">
+                <foreign-key/>
+            </field>
+            <field name="Object21" column="OBJECT21">
+            </field>
+            <field name="Object22" column="OBJECT22">
+                <foreign-key/>
+            </field>
+            <field name="Object30" column="OBJECT30">
+                <foreign-key/>
+            </field>
+            <field name="Object31" column="OBJECT31">
+            </field>
+            <field name="Object32" column="OBJECT32">
+                <foreign-key/>
+            </field>
+            <field name="Object37" column="OBJECT37">
+            </field>
+            <field name="Object38" column="OBJECT38">
+                <foreign-key/>
+            </field>
+            <field name="Object4" column="OBJECT4">
+                <foreign-key/>
+            </field>
+            <field name="Object40" column="OBJECT40">
+                <foreign-key/>
+            </field>
+            <field name="Object41" column="OBJECT41">
+            </field>
+            <field name="Object42" column="OBJECT42">
+                <foreign-key/>
+            </field>
+            <field name="Object47" column="OBJECT47">
+                <foreign-key/>
+            </field>
+            <field name="Object48" column="OBJECT48">
+            </field>
+            <field name="Object49" column="OBJECT49">
+                <foreign-key/>
+            </field>
+            <field name="Object5" column="OBJECT5">
+            </field>
+            <field name="Object53" column="OBJECT53">
+            </field>
+            <field name="Object54" column="OBJECT54">
+                <foreign-key/>
+            </field>
+            <field name="Object56" column="OBJECT56">
+                <foreign-key/>
+            </field>
+            <field name="Object57" column="OBJECT57">
+            </field>
+            <field name="Object58" column="OBJECT58">
+                <foreign-key/>
+            </field>
+            <field name="Object6" column="OBJECT6">
+                <foreign-key/>
+            </field>
+            <field name="Object66" column="OBJECT66">
+                <foreign-key/>
+            </field>
+            <field name="Object67" column="OBJECT67">
+            </field>
+            <field name="Object68" column="OBJECT68">
+                <foreign-key/>
+            </field>
+            <field name="Object73" column="OBJECT73">
+            </field>
+            <field name="Object74" column="OBJECT74">
+                <foreign-key/>
+            </field>
+            <field name="Object76" column="OBJECT76">
+                <foreign-key/>
+            </field>
+            <field name="Object77" column="OBJECT77">
+            </field>
+            <field name="Object78" column="OBJECT78">
+                <foreign-key/>
+            </field>
+            <field name="Object83" column="OBJECT83">
+                <foreign-key/>
+            </field>
+            <field name="Object84" column="OBJECT84">
+            </field>
+            <field name="Object85" column="OBJECT85">
+                <foreign-key/>
+            </field>
+            <field name="Object89" column="OBJECT89">
+            </field>
+            <field name="Object90" column="OBJECT90">
+                <foreign-key/>
+            </field>
+            <field name="Object92" column="OBJECT92">
+                <foreign-key/>
+            </field>
+            <field name="Object93" column="OBJECT93">
+            </field>
+            <field name="Object94" column="OBJECT94">
+                <foreign-key/>
+            </field>
         </class>
     </package>
 </orm>

Modified: incubator/jdo/trunk/tck20/test/orm/datastoreidentity/org/apache/jdo/tck/pc/fieldtypes/FieldsOfSimpleInterface-derby.orm
URL: http://svn.apache.org/viewcvs/incubator/jdo/trunk/tck20/test/orm/datastoreidentity/org/apache/jdo/tck/pc/fieldtypes/FieldsOfSimpleInterface-derby.orm?rev=231540&r1=231539&r2=231540&view=diff
==============================================================================
--- incubator/jdo/trunk/tck20/test/orm/datastoreidentity/org/apache/jdo/tck/pc/fieldtypes/FieldsOfSimpleInterface-derby.orm (original)
+++ incubator/jdo/trunk/tck20/test/orm/datastoreidentity/org/apache/jdo/tck/pc/fieldtypes/FieldsOfSimpleInterface-derby.orm Thu Aug 11 16:36:56 2005
@@ -5,70 +5,173 @@
         <class name="FieldsOfSimpleInterface" table="FIELDSOFSIMPLEINTERFACE">
             <datastore-identity strategy="identity" column="DATASTORE_IDENTITY"/>
             <field name="identifier" column="IDENTIFIER"/>
-            <field name="SimpleInterface1" column="SIMPLEINTERFACE1"/>
-            <field name="SimpleInterface102" column="SIMPLEINTERFACE102"/>
-            <field name="SimpleInterface103" column="SIMPLEINTERFACE103"/>
-            <field name="SimpleInterface104" column="SIMPLEINTERFACE104"/>
-            <field name="SimpleInterface109" column="SIMPLEINTERFACE109"/>
-            <field name="SimpleInterface11" column="SIMPLEINTERFACE11"/>
-            <field name="SimpleInterface110" column="SIMPLEINTERFACE110"/>
-            <field name="SimpleInterface112" column="SIMPLEINTERFACE112"/>
-            <field name="SimpleInterface113" column="SIMPLEINTERFACE113"/>
-            <field name="SimpleInterface114" column="SIMPLEINTERFACE114"/>
-            <field name="SimpleInterface119" column="SIMPLEINTERFACE119"/>
-            <field name="SimpleInterface12" column="SIMPLEINTERFACE12"/>
-            <field name="SimpleInterface120" column="SIMPLEINTERFACE120"/>
-            <field name="SimpleInterface121" column="SIMPLEINTERFACE121"/>
-            <field name="SimpleInterface125" column="SIMPLEINTERFACE125"/>
-            <field name="SimpleInterface126" column="SIMPLEINTERFACE126"/>
-            <field name="SimpleInterface128" column="SIMPLEINTERFACE128"/>
-            <field name="SimpleInterface129" column="SIMPLEINTERFACE129"/>
-            <field name="SimpleInterface13" column="SIMPLEINTERFACE13"/>
-            <field name="SimpleInterface130" column="SIMPLEINTERFACE130"/>
-            <field name="SimpleInterface138" column="SIMPLEINTERFACE138"/>
-            <field name="SimpleInterface139" column="SIMPLEINTERFACE139"/>
-            <field name="SimpleInterface140" column="SIMPLEINTERFACE140"/>
-            <field name="SimpleInterface17" column="SIMPLEINTERFACE17"/>
-            <field name="SimpleInterface18" column="SIMPLEINTERFACE18"/>
-            <field name="SimpleInterface2" column="SIMPLEINTERFACE2"/>
-            <field name="SimpleInterface20" column="SIMPLEINTERFACE20"/>
-            <field name="SimpleInterface21" column="SIMPLEINTERFACE21"/>
-            <field name="SimpleInterface22" column="SIMPLEINTERFACE22"/>
-            <field name="SimpleInterface30" column="SIMPLEINTERFACE30"/>
-            <field name="SimpleInterface31" column="SIMPLEINTERFACE31"/>
-            <field name="SimpleInterface32" column="SIMPLEINTERFACE32"/>
-            <field name="SimpleInterface37" column="SIMPLEINTERFACE37"/>
-            <field name="SimpleInterface38" column="SIMPLEINTERFACE38"/>
-            <field name="SimpleInterface4" column="SIMPLEINTERFACE4"/>
-            <field name="SimpleInterface40" column="SIMPLEINTERFACE40"/>
-            <field name="SimpleInterface41" column="SIMPLEINTERFACE41"/>
-            <field name="SimpleInterface42" column="SIMPLEINTERFACE42"/>
-            <field name="SimpleInterface47" column="SIMPLEINTERFACE47"/>
-            <field name="SimpleInterface48" column="SIMPLEINTERFACE48"/>
-            <field name="SimpleInterface49" column="SIMPLEINTERFACE49"/>
-            <field name="SimpleInterface5" column="SIMPLEINTERFACE5"/>
-            <field name="SimpleInterface53" column="SIMPLEINTERFACE53"/>
-            <field name="SimpleInterface54" column="SIMPLEINTERFACE54"/>
-            <field name="SimpleInterface56" column="SIMPLEINTERFACE56"/>
-            <field name="SimpleInterface57" column="SIMPLEINTERFACE57"/>
-            <field name="SimpleInterface58" column="SIMPLEINTERFACE58"/>
-            <field name="SimpleInterface6" column="SIMPLEINTERFACE6"/>
-            <field name="SimpleInterface66" column="SIMPLEINTERFACE66"/>
-            <field name="SimpleInterface67" column="SIMPLEINTERFACE67"/>
-            <field name="SimpleInterface68" column="SIMPLEINTERFACE68"/>
-            <field name="SimpleInterface73" column="SIMPLEINTERFACE73"/>
-            <field name="SimpleInterface74" column="SIMPLEINTERFACE74"/>
-            <field name="SimpleInterface76" column="SIMPLEINTERFACE76"/>
-            <field name="SimpleInterface77" column="SIMPLEINTERFACE77"/>
-            <field name="SimpleInterface78" column="SIMPLEINTERFACE78"/>
-            <field name="SimpleInterface83" column="SIMPLEINTERFACE83"/>
-            <field name="SimpleInterface84" column="SIMPLEINTERFACE84"/>
-            <field name="SimpleInterface85" column="SIMPLEINTERFACE85"/>
-            <field name="SimpleInterface89" column="SIMPLEINTERFACE89"/>
-            <field name="SimpleInterface90" column="SIMPLEINTERFACE90"/>
-            <field name="SimpleInterface92" column="SIMPLEINTERFACE92"/>
-            <field name="SimpleInterface93" column="SIMPLEINTERFACE93"/>
-            <field name="SimpleInterface94" column="SIMPLEINTERFACE94"/>
+            <field name="SimpleInterface1" column="SIMPLEINTERFACE1">
+            </field>
+            <field name="SimpleInterface102" column="SIMPLEINTERFACE102">
+                <foreign-key/>
+            </field>
+            <field name="SimpleInterface103" column="SIMPLEINTERFACE103">
+            </field>
+            <field name="SimpleInterface104" column="SIMPLEINTERFACE104">
+                <foreign-key/>
+            </field>
+            <field name="SimpleInterface109" column="SIMPLEINTERFACE109">
+            </field>
+            <field name="SimpleInterface11" column="SIMPLEINTERFACE11">
+                <foreign-key/>
+            </field>
+            <field name="SimpleInterface110" column="SIMPLEINTERFACE110">
+            </field>
+            <field name="SimpleInterface112" column="SIMPLEINTERFACE112">
+                <foreign-key/>
+            </field>
+            <field name="SimpleInterface113" column="SIMPLEINTERFACE113">
+            </field>
+            <field name="SimpleInterface114" column="SIMPLEINTERFACE114">
+                <foreign-key/>
+            </field>
+            <field name="SimpleInterface119" column="SIMPLEINTERFACE119">
+                <foreign-key/>
+            </field>
+            <field name="SimpleInterface12" column="SIMPLEINTERFACE12">
+            </field>
+            <field name="SimpleInterface120" column="SIMPLEINTERFACE120">
+            </field>
+            <field name="SimpleInterface121" column="SIMPLEINTERFACE121">
+                <foreign-key/>
+            </field>
+            <field name="SimpleInterface125" column="SIMPLEINTERFACE125">
+            </field>
+            <field name="SimpleInterface126" column="SIMPLEINTERFACE126">
+                <foreign-key/>
+            </field>
+            <field name="SimpleInterface128" column="SIMPLEINTERFACE128">
+                <foreign-key/>
+            </field>
+            <field name="SimpleInterface129" column="SIMPLEINTERFACE129">
+            </field>
+            <field name="SimpleInterface13" column="SIMPLEINTERFACE13">
+                <foreign-key/>
+            </field>
+            <field name="SimpleInterface130" column="SIMPLEINTERFACE130">
+                <foreign-key/>
+            </field>
+            <field name="SimpleInterface138" column="SIMPLEINTERFACE138">
+                <foreign-key/>
+            </field>
+            <field name="SimpleInterface139" column="SIMPLEINTERFACE139">
+            </field>
+            <field name="SimpleInterface140" column="SIMPLEINTERFACE140">
+                <foreign-key/>
+            </field>
+            <field name="SimpleInterface17" column="SIMPLEINTERFACE17">
+            </field>
+            <field name="SimpleInterface18" column="SIMPLEINTERFACE18">
+                <foreign-key/>
+            </field>
+            <field name="SimpleInterface2" column="SIMPLEINTERFACE2">
+                <foreign-key/>
+            </field>
+            <field name="SimpleInterface20" column="SIMPLEINTERFACE20">
+                <foreign-key/>
+            </field>
+            <field name="SimpleInterface21" column="SIMPLEINTERFACE21">
+            </field>
+            <field name="SimpleInterface22" column="SIMPLEINTERFACE22">
+                <foreign-key/>
+            </field>
+            <field name="SimpleInterface30" column="SIMPLEINTERFACE30">
+                <foreign-key/>
+            </field>
+            <field name="SimpleInterface31" column="SIMPLEINTERFACE31">
+            </field>
+            <field name="SimpleInterface32" column="SIMPLEINTERFACE32">
+                <foreign-key/>
+            </field>
+            <field name="SimpleInterface37" column="SIMPLEINTERFACE37">
+            </field>
+            <field name="SimpleInterface38" column="SIMPLEINTERFACE38">
+                <foreign-key/>
+            </field>
+            <field name="SimpleInterface4" column="SIMPLEINTERFACE4">
+                <foreign-key/>
+            </field>
+            <field name="SimpleInterface40" column="SIMPLEINTERFACE40">
+                <foreign-key/>
+            </field>
+            <field name="SimpleInterface41" column="SIMPLEINTERFACE41">
+            </field>
+            <field name="SimpleInterface42" column="SIMPLEINTERFACE42">
+                <foreign-key/>
+            </field>
+            <field name="SimpleInterface47" column="SIMPLEINTERFACE47">
+                <foreign-key/>
+            </field>
+            <field name="SimpleInterface48" column="SIMPLEINTERFACE48">
+            </field>
+            <field name="SimpleInterface49" column="SIMPLEINTERFACE49">
+                <foreign-key/>
+            </field>
+            <field name="SimpleInterface5" column="SIMPLEINTERFACE5">
+            </field>
+            <field name="SimpleInterface53" column="SIMPLEINTERFACE53">
+            </field>
+            <field name="SimpleInterface54" column="SIMPLEINTERFACE54">
+                <foreign-key/>
+            </field>
+            <field name="SimpleInterface56" column="SIMPLEINTERFACE56">
+                <foreign-key/>
+            </field>
+            <field name="SimpleInterface57" column="SIMPLEINTERFACE57">
+            </field>
+            <field name="SimpleInterface58" column="SIMPLEINTERFACE58">
+                <foreign-key/>
+            </field>
+            <field name="SimpleInterface6" column="SIMPLEINTERFACE6">
+                <foreign-key/>
+            </field>
+            <field name="SimpleInterface66" column="SIMPLEINTERFACE66">
+                <foreign-key/>
+            </field>
+            <field name="SimpleInterface67" column="SIMPLEINTERFACE67">
+            </field>
+            <field name="SimpleInterface68" column="SIMPLEINTERFACE68">
+                <foreign-key/>
+            </field>
+            <field name="SimpleInterface73" column="SIMPLEINTERFACE73">
+            </field>
+            <field name="SimpleInterface74" column="SIMPLEINTERFACE74">
+                <foreign-key/>
+            </field>
+            <field name="SimpleInterface76" column="SIMPLEINTERFACE76">
+                <foreign-key/>
+            </field>
+            <field name="SimpleInterface77" column="SIMPLEINTERFACE77">
+            </field>
+            <field name="SimpleInterface78" column="SIMPLEINTERFACE78">
+                <foreign-key/>
+            </field>
+            <field name="SimpleInterface83" column="SIMPLEINTERFACE83">
+                <foreign-key/>
+            </field>
+            <field name="SimpleInterface84" column="SIMPLEINTERFACE84">
+            </field>
+            <field name="SimpleInterface85" column="SIMPLEINTERFACE85">
+                <foreign-key/>
+            </field>
+            <field name="SimpleInterface89" column="SIMPLEINTERFACE89">
+            </field>
+            <field name="SimpleInterface90" column="SIMPLEINTERFACE90">
+                <foreign-key/>
+            </field>
+            <field name="SimpleInterface92" column="SIMPLEINTERFACE92">
+                <foreign-key/>
+            </field>
+            <field name="SimpleInterface93" column="SIMPLEINTERFACE93">
+            </field>
+            <field name="SimpleInterface94" column="SIMPLEINTERFACE94">
+                <foreign-key/>
+            </field>
         </class>
     </package>
 </orm>

Modified: incubator/jdo/trunk/tck20/test/sql/derby/applicationidentity/schema.sql
URL: http://svn.apache.org/viewcvs/incubator/jdo/trunk/tck20/test/sql/derby/applicationidentity/schema.sql?rev=231540&r1=231539&r2=231540&view=diff
==============================================================================
--- incubator/jdo/trunk/tck20/test/sql/derby/applicationidentity/schema.sql (original)
+++ incubator/jdo/trunk/tck20/test/sql/derby/applicationidentity/schema.sql Thu Aug 11 16:36:56 2005
@@ -810,6 +810,14 @@
 
 DROP TABLE SIMPLE_CLASS;
 
+CREATE TABLE SIMPLE_CLASS
+(
+    IDENTIFIER BIGINT NOT NULL,
+    INTVAL INTEGER NOT NULL,
+    STRINGVAL VARCHAR(128) NOT NULL,
+    CONSTRAINT SIMPLE_CLASS_PK PRIMARY KEY (IDENTIFIER)
+);
+
 CREATE TABLE ALLTYPES
 (
     ID INTEGER NOT NULL,
@@ -1631,78 +1639,70 @@
 CREATE TABLE FIELDSOFOBJECT
 (
     IDENTIFIER INTEGER NOT NULL,
-    OBJECT0 LONG VARCHAR FOR BIT DATA,
     OBJECT1 LONG VARCHAR FOR BIT DATA,
-    OBJECT102 LONG VARCHAR FOR BIT DATA,
+    OBJECT102 BIGINT REFERENCES SIMPLE_CLASS,
     OBJECT103 LONG VARCHAR FOR BIT DATA,
-    OBJECT104 LONG VARCHAR FOR BIT DATA,
-    OBJECT108 LONG VARCHAR FOR BIT DATA,
+    OBJECT104 BIGINT REFERENCES SIMPLE_CLASS,
     OBJECT109 LONG VARCHAR FOR BIT DATA,
-    OBJECT11 LONG VARCHAR FOR BIT DATA,
-    OBJECT110 LONG VARCHAR FOR BIT DATA,
-    OBJECT112 LONG VARCHAR FOR BIT DATA,
+    OBJECT11 BIGINT REFERENCES SIMPLE_CLASS,
+    OBJECT110 BIGINT REFERENCES SIMPLE_CLASS,
+    OBJECT112 BIGINT REFERENCES SIMPLE_CLASS,
     OBJECT113 LONG VARCHAR FOR BIT DATA,
-    OBJECT114 LONG VARCHAR FOR BIT DATA,
-    OBJECT119 LONG VARCHAR FOR BIT DATA,
+    OBJECT114 BIGINT REFERENCES SIMPLE_CLASS,
+    OBJECT119 BIGINT REFERENCES SIMPLE_CLASS,
     OBJECT12 LONG VARCHAR FOR BIT DATA,
     OBJECT120 LONG VARCHAR FOR BIT DATA,
-    OBJECT121 LONG VARCHAR FOR BIT DATA,
-    OBJECT124 LONG VARCHAR FOR BIT DATA,
+    OBJECT121 BIGINT REFERENCES SIMPLE_CLASS,
     OBJECT125 LONG VARCHAR FOR BIT DATA,
-    OBJECT126 LONG VARCHAR FOR BIT DATA,
-    OBJECT128 LONG VARCHAR FOR BIT DATA,
+    OBJECT126 BIGINT REFERENCES SIMPLE_CLASS,
+    OBJECT128 BIGINT REFERENCES SIMPLE_CLASS,
     OBJECT129 LONG VARCHAR FOR BIT DATA,
-    OBJECT13 LONG VARCHAR FOR BIT DATA,
-    OBJECT130 LONG VARCHAR FOR BIT DATA,
-    OBJECT138 LONG VARCHAR FOR BIT DATA,
+    OBJECT13 BIGINT REFERENCES SIMPLE_CLASS,
+    OBJECT130 BIGINT REFERENCES SIMPLE_CLASS,
+    OBJECT138 BIGINT REFERENCES SIMPLE_CLASS,
     OBJECT139 LONG VARCHAR FOR BIT DATA,
-    OBJECT140 LONG VARCHAR FOR BIT DATA,
-    OBJECT16 LONG VARCHAR FOR BIT DATA,
+    OBJECT140 BIGINT REFERENCES SIMPLE_CLASS,
     OBJECT17 LONG VARCHAR FOR BIT DATA,
-    OBJECT18 LONG VARCHAR FOR BIT DATA,
-    OBJECT2 LONG VARCHAR FOR BIT DATA,
-    OBJECT20 LONG VARCHAR FOR BIT DATA,
+    OBJECT18 BIGINT REFERENCES SIMPLE_CLASS,
+    OBJECT2 BIGINT REFERENCES SIMPLE_CLASS,
+    OBJECT20 BIGINT REFERENCES SIMPLE_CLASS,
     OBJECT21 LONG VARCHAR FOR BIT DATA,
-    OBJECT22 LONG VARCHAR FOR BIT DATA,
-    OBJECT30 LONG VARCHAR FOR BIT DATA,
+    OBJECT22 BIGINT REFERENCES SIMPLE_CLASS,
+    OBJECT30 BIGINT REFERENCES SIMPLE_CLASS,
     OBJECT31 LONG VARCHAR FOR BIT DATA,
-    OBJECT32 LONG VARCHAR FOR BIT DATA,
-    OBJECT36 LONG VARCHAR FOR BIT DATA,
+    OBJECT32 BIGINT REFERENCES SIMPLE_CLASS,
     OBJECT37 LONG VARCHAR FOR BIT DATA,
-    OBJECT38 LONG VARCHAR FOR BIT DATA,
-    OBJECT4 LONG VARCHAR FOR BIT DATA,
-    OBJECT40 LONG VARCHAR FOR BIT DATA,
+    OBJECT38 BIGINT REFERENCES SIMPLE_CLASS,
+    OBJECT4 BIGINT REFERENCES SIMPLE_CLASS,
+    OBJECT40 BIGINT REFERENCES SIMPLE_CLASS,
     OBJECT41 LONG VARCHAR FOR BIT DATA,
-    OBJECT42 LONG VARCHAR FOR BIT DATA,
-    OBJECT47 LONG VARCHAR FOR BIT DATA,
+    OBJECT42 BIGINT REFERENCES SIMPLE_CLASS,
+    OBJECT47 BIGINT REFERENCES SIMPLE_CLASS,
     OBJECT48 LONG VARCHAR FOR BIT DATA,
-    OBJECT49 LONG VARCHAR FOR BIT DATA,
+    OBJECT49 BIGINT REFERENCES SIMPLE_CLASS,
     OBJECT5 LONG VARCHAR FOR BIT DATA,
-    OBJECT52 LONG VARCHAR FOR BIT DATA,
     OBJECT53 LONG VARCHAR FOR BIT DATA,
-    OBJECT54 LONG VARCHAR FOR BIT DATA,
-    OBJECT56 LONG VARCHAR FOR BIT DATA,
+    OBJECT54 BIGINT REFERENCES SIMPLE_CLASS,
+    OBJECT56 BIGINT REFERENCES SIMPLE_CLASS,
     OBJECT57 LONG VARCHAR FOR BIT DATA,
-    OBJECT58 LONG VARCHAR FOR BIT DATA,
-    OBJECT6 LONG VARCHAR FOR BIT DATA,
-    OBJECT66 LONG VARCHAR FOR BIT DATA,
+    OBJECT58 BIGINT REFERENCES SIMPLE_CLASS,
+    OBJECT6 BIGINT REFERENCES SIMPLE_CLASS,
+    OBJECT66 BIGINT REFERENCES SIMPLE_CLASS,
     OBJECT67 LONG VARCHAR FOR BIT DATA,
-    OBJECT68 LONG VARCHAR FOR BIT DATA,
-    OBJECT72 LONG VARCHAR FOR BIT DATA,
+    OBJECT68 BIGINT REFERENCES SIMPLE_CLASS,
     OBJECT73 LONG VARCHAR FOR BIT DATA,
-    OBJECT74 LONG VARCHAR FOR BIT DATA,
-    OBJECT76 LONG VARCHAR FOR BIT DATA,
+    OBJECT74 BIGINT REFERENCES SIMPLE_CLASS,
+    OBJECT76 BIGINT REFERENCES SIMPLE_CLASS,
     OBJECT77 LONG VARCHAR FOR BIT DATA,
-    OBJECT78 LONG VARCHAR FOR BIT DATA,
-    OBJECT83 LONG VARCHAR FOR BIT DATA,
+    OBJECT78 BIGINT REFERENCES SIMPLE_CLASS,
+    OBJECT83 BIGINT REFERENCES SIMPLE_CLASS,
     OBJECT84 LONG VARCHAR FOR BIT DATA,
-    OBJECT85 LONG VARCHAR FOR BIT DATA,
-    OBJECT88 LONG VARCHAR FOR BIT DATA,
+    OBJECT85 BIGINT REFERENCES SIMPLE_CLASS,
     OBJECT89 LONG VARCHAR FOR BIT DATA,
-    OBJECT90 LONG VARCHAR FOR BIT DATA,
-    OBJECT92 LONG VARCHAR FOR BIT DATA,
+    OBJECT90 BIGINT REFERENCES SIMPLE_CLASS,
+    OBJECT92 BIGINT REFERENCES SIMPLE_CLASS,
     OBJECT93 LONG VARCHAR FOR BIT DATA,
-    OBJECT94 LONG VARCHAR FOR BIT DATA
+    OBJECT94 BIGINT REFERENCES SIMPLE_CLASS
 );
 
 ALTER TABLE FIELDSOFOBJECT ADD CONSTRAINT FIELDSOFOBJECT_PK PRIMARY KEY (IDENTIFIER);
@@ -1711,69 +1711,69 @@
 (
     IDENTIFIER INTEGER NOT NULL,
     SIMPLEINTERFACE1 LONG VARCHAR FOR BIT DATA,
-    SIMPLEINTERFACE102 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE102 BIGINT REFERENCES SIMPLE_CLASS,
     SIMPLEINTERFACE103 LONG VARCHAR FOR BIT DATA,
-    SIMPLEINTERFACE104 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE104 BIGINT REFERENCES SIMPLE_CLASS,
     SIMPLEINTERFACE109 LONG VARCHAR FOR BIT DATA,
-    SIMPLEINTERFACE11 LONG VARCHAR FOR BIT DATA,
-    SIMPLEINTERFACE110 LONG VARCHAR FOR BIT DATA,
-    SIMPLEINTERFACE112 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE11 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLEINTERFACE110 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLEINTERFACE112 BIGINT REFERENCES SIMPLE_CLASS,
     SIMPLEINTERFACE113 LONG VARCHAR FOR BIT DATA,
-    SIMPLEINTERFACE114 LONG VARCHAR FOR BIT DATA,
-    SIMPLEINTERFACE119 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE114 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLEINTERFACE119 BIGINT REFERENCES SIMPLE_CLASS,
     SIMPLEINTERFACE12 LONG VARCHAR FOR BIT DATA,
     SIMPLEINTERFACE120 LONG VARCHAR FOR BIT DATA,
-    SIMPLEINTERFACE121 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE121 BIGINT REFERENCES SIMPLE_CLASS,
     SIMPLEINTERFACE125 LONG VARCHAR FOR BIT DATA,
-    SIMPLEINTERFACE126 LONG VARCHAR FOR BIT DATA,
-    SIMPLEINTERFACE128 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE126 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLEINTERFACE128 BIGINT REFERENCES SIMPLE_CLASS,
     SIMPLEINTERFACE129 LONG VARCHAR FOR BIT DATA,
-    SIMPLEINTERFACE13 LONG VARCHAR FOR BIT DATA,
-    SIMPLEINTERFACE130 LONG VARCHAR FOR BIT DATA,
-    SIMPLEINTERFACE138 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE13 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLEINTERFACE130 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLEINTERFACE138 BIGINT REFERENCES SIMPLE_CLASS,
     SIMPLEINTERFACE139 LONG VARCHAR FOR BIT DATA,
-    SIMPLEINTERFACE140 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE140 BIGINT REFERENCES SIMPLE_CLASS,
     SIMPLEINTERFACE17 LONG VARCHAR FOR BIT DATA,
-    SIMPLEINTERFACE18 LONG VARCHAR FOR BIT DATA,
-    SIMPLEINTERFACE2 LONG VARCHAR FOR BIT DATA,
-    SIMPLEINTERFACE20 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE18 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLEINTERFACE2 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLEINTERFACE20 BIGINT REFERENCES SIMPLE_CLASS,
     SIMPLEINTERFACE21 LONG VARCHAR FOR BIT DATA,
-    SIMPLEINTERFACE22 LONG VARCHAR FOR BIT DATA,
-    SIMPLEINTERFACE30 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE22 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLEINTERFACE30 BIGINT REFERENCES SIMPLE_CLASS,
     SIMPLEINTERFACE31 LONG VARCHAR FOR BIT DATA,
-    SIMPLEINTERFACE32 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE32 BIGINT REFERENCES SIMPLE_CLASS,
     SIMPLEINTERFACE37 LONG VARCHAR FOR BIT DATA,
-    SIMPLEINTERFACE38 LONG VARCHAR FOR BIT DATA,
-    SIMPLEINTERFACE4 LONG VARCHAR FOR BIT DATA,
-    SIMPLEINTERFACE40 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE38 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLEINTERFACE4 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLEINTERFACE40 BIGINT REFERENCES SIMPLE_CLASS,
     SIMPLEINTERFACE41 LONG VARCHAR FOR BIT DATA,
-    SIMPLEINTERFACE42 LONG VARCHAR FOR BIT DATA,
-    SIMPLEINTERFACE47 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE42 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLEINTERFACE47 BIGINT REFERENCES SIMPLE_CLASS,
     SIMPLEINTERFACE48 LONG VARCHAR FOR BIT DATA,
-    SIMPLEINTERFACE49 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE49 BIGINT REFERENCES SIMPLE_CLASS,
     SIMPLEINTERFACE5 LONG VARCHAR FOR BIT DATA,
     SIMPLEINTERFACE53 LONG VARCHAR FOR BIT DATA,
-    SIMPLEINTERFACE54 LONG VARCHAR FOR BIT DATA,
-    SIMPLEINTERFACE56 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE54 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLEINTERFACE56 BIGINT REFERENCES SIMPLE_CLASS,
     SIMPLEINTERFACE57 LONG VARCHAR FOR BIT DATA,
-    SIMPLEINTERFACE58 LONG VARCHAR FOR BIT DATA,
-    SIMPLEINTERFACE6 LONG VARCHAR FOR BIT DATA,
-    SIMPLEINTERFACE66 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE58 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLEINTERFACE6 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLEINTERFACE66 BIGINT REFERENCES SIMPLE_CLASS,
     SIMPLEINTERFACE67 LONG VARCHAR FOR BIT DATA,
-    SIMPLEINTERFACE68 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE68 BIGINT REFERENCES SIMPLE_CLASS,
     SIMPLEINTERFACE73 LONG VARCHAR FOR BIT DATA,
-    SIMPLEINTERFACE74 LONG VARCHAR FOR BIT DATA,
-    SIMPLEINTERFACE76 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE74 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLEINTERFACE76 BIGINT REFERENCES SIMPLE_CLASS,
     SIMPLEINTERFACE77 LONG VARCHAR FOR BIT DATA,
-    SIMPLEINTERFACE78 LONG VARCHAR FOR BIT DATA,
-    SIMPLEINTERFACE83 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE78 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLEINTERFACE83 BIGINT REFERENCES SIMPLE_CLASS,
     SIMPLEINTERFACE84 LONG VARCHAR FOR BIT DATA,
-    SIMPLEINTERFACE85 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE85 BIGINT REFERENCES SIMPLE_CLASS,
     SIMPLEINTERFACE89 LONG VARCHAR FOR BIT DATA,
-    SIMPLEINTERFACE90 LONG VARCHAR FOR BIT DATA,
-    SIMPLEINTERFACE92 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE90 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLEINTERFACE92 BIGINT REFERENCES SIMPLE_CLASS,
     SIMPLEINTERFACE93 LONG VARCHAR FOR BIT DATA,
-    SIMPLEINTERFACE94 LONG VARCHAR FOR BIT DATA
+    SIMPLEINTERFACE94 BIGINT REFERENCES SIMPLE_CLASS
 );
 
 ALTER TABLE FIELDSOFSIMPLEINTERFACE ADD CONSTRAINT FOSI_PK PRIMARY KEY (IDENTIFIER);
@@ -2646,13 +2646,6 @@
     CONSTRAINT FieldsOfByte_PK PRIMARY KEY (IDENTIFIER)
 );
 
-CREATE TABLE SIMPLE_CLASS
-(
-    IDENTIFIER BIGINT NOT NULL,
-    INTVAL INTEGER NOT NULL,
-    STRINGVAL VARCHAR(128) NOT NULL,
-    CONSTRAINT SIMPLE_CLASS_PK PRIMARY KEY (IDENTIFIER)
-);
 
 CREATE TABLE FIELDSOFSIMPLECLASS
 (

Modified: incubator/jdo/trunk/tck20/test/sql/derby/datastoreidentity/schema.sql
URL: http://svn.apache.org/viewcvs/incubator/jdo/trunk/tck20/test/sql/derby/datastoreidentity/schema.sql?rev=231540&r1=231539&r2=231540&view=diff
==============================================================================
--- incubator/jdo/trunk/tck20/test/sql/derby/datastoreidentity/schema.sql (original)
+++ incubator/jdo/trunk/tck20/test/sql/derby/datastoreidentity/schema.sql Thu Aug 11 16:36:56 2005
@@ -758,6 +758,15 @@
 
 DROP TABLE SIMPLE_CLASS;
 
+CREATE TABLE SIMPLE_CLASS
+(
+    DATASTORE_IDENTITY BIGINT NOT NULL GENERATED ALWAYS AS IDENTITY,
+    IDENTIFIER BIGINT,
+    INTVAL INTEGER NOT NULL,
+    STRINGVAL VARCHAR(128) NOT NULL,
+    CONSTRAINT SIMPLE_CLASS_PK PRIMARY KEY (DATASTORE_IDENTITY)
+);
+
 CREATE TABLE ALLTYPES
 (
     DATASTORE_IDENTITY INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY,
@@ -1591,78 +1600,70 @@
 (
     DATASTORE_IDENTITY INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY,
     IDENTIFIER INTEGER,
-    OBJECT0 LONG VARCHAR FOR BIT DATA,
     OBJECT1 LONG VARCHAR FOR BIT DATA,
-    OBJECT102 LONG VARCHAR FOR BIT DATA,
+    OBJECT102 BIGINT REFERENCES SIMPLE_CLASS,
     OBJECT103 LONG VARCHAR FOR BIT DATA,
-    OBJECT104 LONG VARCHAR FOR BIT DATA,
-    OBJECT108 LONG VARCHAR FOR BIT DATA,
+    OBJECT104 BIGINT REFERENCES SIMPLE_CLASS,
     OBJECT109 LONG VARCHAR FOR BIT DATA,
-    OBJECT11 LONG VARCHAR FOR BIT DATA,
-    OBJECT110 LONG VARCHAR FOR BIT DATA,
-    OBJECT112 LONG VARCHAR FOR BIT DATA,
+    OBJECT11 BIGINT REFERENCES SIMPLE_CLASS,
+    OBJECT110 BIGINT REFERENCES SIMPLE_CLASS,
+    OBJECT112 BIGINT REFERENCES SIMPLE_CLASS,
     OBJECT113 LONG VARCHAR FOR BIT DATA,
-    OBJECT114 LONG VARCHAR FOR BIT DATA,
-    OBJECT119 LONG VARCHAR FOR BIT DATA,
+    OBJECT114 BIGINT REFERENCES SIMPLE_CLASS,
+    OBJECT119 BIGINT REFERENCES SIMPLE_CLASS,
     OBJECT12 LONG VARCHAR FOR BIT DATA,
     OBJECT120 LONG VARCHAR FOR BIT DATA,
-    OBJECT121 LONG VARCHAR FOR BIT DATA,
-    OBJECT124 LONG VARCHAR FOR BIT DATA,
+    OBJECT121 BIGINT REFERENCES SIMPLE_CLASS,
     OBJECT125 LONG VARCHAR FOR BIT DATA,
-    OBJECT126 LONG VARCHAR FOR BIT DATA,
-    OBJECT128 LONG VARCHAR FOR BIT DATA,
+    OBJECT126 BIGINT REFERENCES SIMPLE_CLASS,
+    OBJECT128 BIGINT REFERENCES SIMPLE_CLASS,
     OBJECT129 LONG VARCHAR FOR BIT DATA,
-    OBJECT13 LONG VARCHAR FOR BIT DATA,
-    OBJECT130 LONG VARCHAR FOR BIT DATA,
-    OBJECT138 LONG VARCHAR FOR BIT DATA,
+    OBJECT13 BIGINT REFERENCES SIMPLE_CLASS,
+    OBJECT130 BIGINT REFERENCES SIMPLE_CLASS,
+    OBJECT138 BIGINT REFERENCES SIMPLE_CLASS,
     OBJECT139 LONG VARCHAR FOR BIT DATA,
-    OBJECT140 LONG VARCHAR FOR BIT DATA,
-    OBJECT16 LONG VARCHAR FOR BIT DATA,
+    OBJECT140 BIGINT REFERENCES SIMPLE_CLASS,
     OBJECT17 LONG VARCHAR FOR BIT DATA,
-    OBJECT18 LONG VARCHAR FOR BIT DATA,
-    OBJECT2 LONG VARCHAR FOR BIT DATA,
-    OBJECT20 LONG VARCHAR FOR BIT DATA,
+    OBJECT18 BIGINT REFERENCES SIMPLE_CLASS,
+    OBJECT2 BIGINT REFERENCES SIMPLE_CLASS,
+    OBJECT20 BIGINT REFERENCES SIMPLE_CLASS,
     OBJECT21 LONG VARCHAR FOR BIT DATA,
-    OBJECT22 LONG VARCHAR FOR BIT DATA,
-    OBJECT30 LONG VARCHAR FOR BIT DATA,
+    OBJECT22 BIGINT REFERENCES SIMPLE_CLASS,
+    OBJECT30 BIGINT REFERENCES SIMPLE_CLASS,
     OBJECT31 LONG VARCHAR FOR BIT DATA,
-    OBJECT32 LONG VARCHAR FOR BIT DATA,
-    OBJECT36 LONG VARCHAR FOR BIT DATA,
+    OBJECT32 BIGINT REFERENCES SIMPLE_CLASS,
     OBJECT37 LONG VARCHAR FOR BIT DATA,
-    OBJECT38 LONG VARCHAR FOR BIT DATA,
-    OBJECT4 LONG VARCHAR FOR BIT DATA,
-    OBJECT40 LONG VARCHAR FOR BIT DATA,
+    OBJECT38 BIGINT REFERENCES SIMPLE_CLASS,
+    OBJECT4 BIGINT REFERENCES SIMPLE_CLASS,
+    OBJECT40 BIGINT REFERENCES SIMPLE_CLASS,
     OBJECT41 LONG VARCHAR FOR BIT DATA,
-    OBJECT42 LONG VARCHAR FOR BIT DATA,
-    OBJECT47 LONG VARCHAR FOR BIT DATA,
+    OBJECT42 BIGINT REFERENCES SIMPLE_CLASS,
+    OBJECT47 BIGINT REFERENCES SIMPLE_CLASS,
     OBJECT48 LONG VARCHAR FOR BIT DATA,
-    OBJECT49 LONG VARCHAR FOR BIT DATA,
+    OBJECT49 BIGINT REFERENCES SIMPLE_CLASS,
     OBJECT5 LONG VARCHAR FOR BIT DATA,
-    OBJECT52 LONG VARCHAR FOR BIT DATA,
     OBJECT53 LONG VARCHAR FOR BIT DATA,
-    OBJECT54 LONG VARCHAR FOR BIT DATA,
-    OBJECT56 LONG VARCHAR FOR BIT DATA,
+    OBJECT54 BIGINT REFERENCES SIMPLE_CLASS,
+    OBJECT56 BIGINT REFERENCES SIMPLE_CLASS,
     OBJECT57 LONG VARCHAR FOR BIT DATA,
-    OBJECT58 LONG VARCHAR FOR BIT DATA,
-    OBJECT6 LONG VARCHAR FOR BIT DATA,
-    OBJECT66 LONG VARCHAR FOR BIT DATA,
+    OBJECT58 BIGINT REFERENCES SIMPLE_CLASS,
+    OBJECT6 BIGINT REFERENCES SIMPLE_CLASS,
+    OBJECT66 BIGINT REFERENCES SIMPLE_CLASS,
     OBJECT67 LONG VARCHAR FOR BIT DATA,
-    OBJECT68 LONG VARCHAR FOR BIT DATA,
-    OBJECT72 LONG VARCHAR FOR BIT DATA,
+    OBJECT68 BIGINT REFERENCES SIMPLE_CLASS,
     OBJECT73 LONG VARCHAR FOR BIT DATA,
-    OBJECT74 LONG VARCHAR FOR BIT DATA,
-    OBJECT76 LONG VARCHAR FOR BIT DATA,
+    OBJECT74 BIGINT REFERENCES SIMPLE_CLASS,
+    OBJECT76 BIGINT REFERENCES SIMPLE_CLASS,
     OBJECT77 LONG VARCHAR FOR BIT DATA,
-    OBJECT78 LONG VARCHAR FOR BIT DATA,
-    OBJECT83 LONG VARCHAR FOR BIT DATA,
+    OBJECT78 BIGINT REFERENCES SIMPLE_CLASS,
+    OBJECT83 BIGINT REFERENCES SIMPLE_CLASS,
     OBJECT84 LONG VARCHAR FOR BIT DATA,
-    OBJECT85 LONG VARCHAR FOR BIT DATA,
-    OBJECT88 LONG VARCHAR FOR BIT DATA,
+    OBJECT85 BIGINT REFERENCES SIMPLE_CLASS,
     OBJECT89 LONG VARCHAR FOR BIT DATA,
-    OBJECT90 LONG VARCHAR FOR BIT DATA,
-    OBJECT92 LONG VARCHAR FOR BIT DATA,
+    OBJECT90 BIGINT REFERENCES SIMPLE_CLASS,
+    OBJECT92 BIGINT REFERENCES SIMPLE_CLASS,
     OBJECT93 LONG VARCHAR FOR BIT DATA,
-    OBJECT94 LONG VARCHAR FOR BIT DATA
+    OBJECT94 BIGINT REFERENCES SIMPLE_CLASS
 );
 
 ALTER TABLE FIELDSOFOBJECT ADD CONSTRAINT FIELDSOFOBJECT_PK PRIMARY KEY (DATASTORE_IDENTITY);
@@ -1672,69 +1673,69 @@
     DATASTORE_IDENTITY INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY,
     IDENTIFIER INTEGER,
     SIMPLEINTERFACE1 LONG VARCHAR FOR BIT DATA,
-    SIMPLEINTERFACE102 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE102 BIGINT REFERENCES SIMPLE_CLASS,
     SIMPLEINTERFACE103 LONG VARCHAR FOR BIT DATA,
-    SIMPLEINTERFACE104 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE104 BIGINT REFERENCES SIMPLE_CLASS,
     SIMPLEINTERFACE109 LONG VARCHAR FOR BIT DATA,
-    SIMPLEINTERFACE11 LONG VARCHAR FOR BIT DATA,
-    SIMPLEINTERFACE110 LONG VARCHAR FOR BIT DATA,
-    SIMPLEINTERFACE112 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE11 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLEINTERFACE110 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLEINTERFACE112 BIGINT REFERENCES SIMPLE_CLASS,
     SIMPLEINTERFACE113 LONG VARCHAR FOR BIT DATA,
-    SIMPLEINTERFACE114 LONG VARCHAR FOR BIT DATA,
-    SIMPLEINTERFACE119 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE114 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLEINTERFACE119 BIGINT REFERENCES SIMPLE_CLASS,
     SIMPLEINTERFACE12 LONG VARCHAR FOR BIT DATA,
     SIMPLEINTERFACE120 LONG VARCHAR FOR BIT DATA,
-    SIMPLEINTERFACE121 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE121 BIGINT REFERENCES SIMPLE_CLASS,
     SIMPLEINTERFACE125 LONG VARCHAR FOR BIT DATA,
-    SIMPLEINTERFACE126 LONG VARCHAR FOR BIT DATA,
-    SIMPLEINTERFACE128 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE126 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLEINTERFACE128 BIGINT REFERENCES SIMPLE_CLASS,
     SIMPLEINTERFACE129 LONG VARCHAR FOR BIT DATA,
-    SIMPLEINTERFACE13 LONG VARCHAR FOR BIT DATA,
-    SIMPLEINTERFACE130 LONG VARCHAR FOR BIT DATA,
-    SIMPLEINTERFACE138 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE13 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLEINTERFACE130 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLEINTERFACE138 BIGINT REFERENCES SIMPLE_CLASS,
     SIMPLEINTERFACE139 LONG VARCHAR FOR BIT DATA,
-    SIMPLEINTERFACE140 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE140 BIGINT REFERENCES SIMPLE_CLASS,
     SIMPLEINTERFACE17 LONG VARCHAR FOR BIT DATA,
-    SIMPLEINTERFACE18 LONG VARCHAR FOR BIT DATA,
-    SIMPLEINTERFACE2 LONG VARCHAR FOR BIT DATA,
-    SIMPLEINTERFACE20 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE18 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLEINTERFACE2 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLEINTERFACE20 BIGINT REFERENCES SIMPLE_CLASS,
     SIMPLEINTERFACE21 LONG VARCHAR FOR BIT DATA,
-    SIMPLEINTERFACE22 LONG VARCHAR FOR BIT DATA,
-    SIMPLEINTERFACE30 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE22 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLEINTERFACE30 BIGINT REFERENCES SIMPLE_CLASS,
     SIMPLEINTERFACE31 LONG VARCHAR FOR BIT DATA,
-    SIMPLEINTERFACE32 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE32 BIGINT REFERENCES SIMPLE_CLASS,
     SIMPLEINTERFACE37 LONG VARCHAR FOR BIT DATA,
-    SIMPLEINTERFACE38 LONG VARCHAR FOR BIT DATA,
-    SIMPLEINTERFACE4 LONG VARCHAR FOR BIT DATA,
-    SIMPLEINTERFACE40 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE38 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLEINTERFACE4 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLEINTERFACE40 BIGINT REFERENCES SIMPLE_CLASS,
     SIMPLEINTERFACE41 LONG VARCHAR FOR BIT DATA,
-    SIMPLEINTERFACE42 LONG VARCHAR FOR BIT DATA,
-    SIMPLEINTERFACE47 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE42 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLEINTERFACE47 BIGINT REFERENCES SIMPLE_CLASS,
     SIMPLEINTERFACE48 LONG VARCHAR FOR BIT DATA,
-    SIMPLEINTERFACE49 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE49 BIGINT REFERENCES SIMPLE_CLASS,
     SIMPLEINTERFACE5 LONG VARCHAR FOR BIT DATA,
     SIMPLEINTERFACE53 LONG VARCHAR FOR BIT DATA,
-    SIMPLEINTERFACE54 LONG VARCHAR FOR BIT DATA,
-    SIMPLEINTERFACE56 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE54 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLEINTERFACE56 BIGINT REFERENCES SIMPLE_CLASS,
     SIMPLEINTERFACE57 LONG VARCHAR FOR BIT DATA,
-    SIMPLEINTERFACE58 LONG VARCHAR FOR BIT DATA,
-    SIMPLEINTERFACE6 LONG VARCHAR FOR BIT DATA,
-    SIMPLEINTERFACE66 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE58 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLEINTERFACE6 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLEINTERFACE66 BIGINT REFERENCES SIMPLE_CLASS,
     SIMPLEINTERFACE67 LONG VARCHAR FOR BIT DATA,
-    SIMPLEINTERFACE68 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE68 BIGINT REFERENCES SIMPLE_CLASS,
     SIMPLEINTERFACE73 LONG VARCHAR FOR BIT DATA,
-    SIMPLEINTERFACE74 LONG VARCHAR FOR BIT DATA,
-    SIMPLEINTERFACE76 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE74 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLEINTERFACE76 BIGINT REFERENCES SIMPLE_CLASS,
     SIMPLEINTERFACE77 LONG VARCHAR FOR BIT DATA,
-    SIMPLEINTERFACE78 LONG VARCHAR FOR BIT DATA,
-    SIMPLEINTERFACE83 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE78 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLEINTERFACE83 BIGINT REFERENCES SIMPLE_CLASS,
     SIMPLEINTERFACE84 LONG VARCHAR FOR BIT DATA,
-    SIMPLEINTERFACE85 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE85 BIGINT REFERENCES SIMPLE_CLASS,
     SIMPLEINTERFACE89 LONG VARCHAR FOR BIT DATA,
-    SIMPLEINTERFACE90 LONG VARCHAR FOR BIT DATA,
-    SIMPLEINTERFACE92 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE90 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLEINTERFACE92 BIGINT REFERENCES SIMPLE_CLASS,
     SIMPLEINTERFACE93 LONG VARCHAR FOR BIT DATA,
-    SIMPLEINTERFACE94 LONG VARCHAR FOR BIT DATA
+    SIMPLEINTERFACE94 BIGINT REFERENCES SIMPLE_CLASS
 );
 
 ALTER TABLE FIELDSOFSIMPLEINTERFACE ADD CONSTRAINT FOSI_PK PRIMARY KEY (DATASTORE_IDENTITY);
@@ -2616,15 +2617,6 @@
     BYTE139 SMALLINT,
     BYTE140 SMALLINT,
     CONSTRAINT FieldsOfByte_PK PRIMARY KEY (DATASTORE_IDENTITY)
-);
-
-CREATE TABLE SIMPLE_CLASS
-(
-    DATASTORE_IDENTITY BIGINT NOT NULL GENERATED ALWAYS AS IDENTITY,
-    IDENTIFIER BIGINT,
-    INTVAL INTEGER NOT NULL,
-    STRINGVAL VARCHAR(128) NOT NULL,
-    CONSTRAINT SIMPLE_CLASS_PK PRIMARY KEY (DATASTORE_IDENTITY)
 );
 
 CREATE TABLE FIELDSOFSIMPLECLASS



Mime
View raw message