You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jdo-commits@db.apache.org by mc...@apache.org on 2005/08/12 01:37:15 UTC
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/...
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