Return-Path: Delivered-To: apmail-db-jdo-commits-archive@www.apache.org Received: (qmail 54846 invoked from network); 5 May 2005 04:00:59 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 5 May 2005 04:00:59 -0000 Received: (qmail 97575 invoked by uid 500); 5 May 2005 04:03:10 -0000 Mailing-List: contact jdo-commits-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: jdo-dev@db.apache.org Delivered-To: mailing list jdo-commits@db.apache.org Received: (qmail 97541 invoked by uid 99); 5 May 2005 04:03:09 -0000 X-ASF-Spam-Status: No, hits=1.1 required=10.0 tests=NO_REAL_NAME,UPPERCASE_50_75 X-Spam-Check-By: apache.org Received: from minotaur.apache.org (HELO minotaur.apache.org) (209.237.227.194) by apache.org (qpsmtpd/0.28) with SMTP; Wed, 04 May 2005 21:03:06 -0700 Received: (qmail 54556 invoked by uid 65534); 5 May 2005 04:00:52 -0000 Message-ID: <20050505040052.54552.qmail@minotaur.apache.org> Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Subject: svn commit: r168257 - in /incubator/jdo/trunk/tck20/test: java/org/apache/jdo/tck/models/fieldtypes/ java/org/apache/jdo/tck/pc/fieldtypes/ orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/ sql/derby/ Date: Thu, 05 May 2005 04:00:51 -0000 To: jdo-commits@db.apache.org From: mcaisse@apache.org X-Mailer: svnmailer-1.0.0-dev X-Virus-Checked: Checked X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Author: mcaisse Date: Wed May 4 21:00:51 2005 New Revision: 168257 URL: http://svn.apache.org/viewcvs?rev=3D168257&view=3Drev Log: jdo-8 interim check-in Added: incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/t= ck/pc/fieldtypes/FieldsOfSimpleClass-derby.orm (with props) incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/t= ck/pc/fieldtypes/SimpleClass-derby.orm (with props) Modified: incubator/jdo/trunk/tck20/test/java/org/apache/jdo/tck/models/fieldtype= s/TestArrayCollections.java incubator/jdo/trunk/tck20/test/java/org/apache/jdo/tck/pc/fieldtypes/Si= mpleClass.java incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/t= ck/pc/fieldtypes/ArrayCollections-derby.orm incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/t= ck/pc/fieldtypes/CollectionCollections-derby.orm incubator/jdo/trunk/tck20/test/sql/derby/schema1.sql Modified: incubator/jdo/trunk/tck20/test/java/org/apache/jdo/tck/models/fie= ldtypes/TestArrayCollections.java URL: http://svn.apache.org/viewcvs/incubator/jdo/trunk/tck20/test/java/org/= apache/jdo/tck/models/fieldtypes/TestArrayCollections.java?rev=3D168257&r1= =3D168256&r2=3D168257&view=3Ddiff =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D --- incubator/jdo/trunk/tck20/test/java/org/apache/jdo/tck/models/fieldtype= s/TestArrayCollections.java (original) +++ incubator/jdo/trunk/tck20/test/java/org/apache/jdo/tck/models/fieldtype= s/TestArrayCollections.java Wed May 4 21:00:51 2005 @@ -166,6 +166,18 @@ Object[] val =3D pi.get(i); =20 if(!Arrays.equals(val, compareWith)){ + if (debug) { + if ((compareWith !=3D null) && (val !=3D null)) { + logger.debug("persistent instance =3D " + val.toSt= ring() + + "compareWith =3D " + compareWith.toString= ()); + } + else { + if (compareWith =3D=3D null) + logger.debug("Persistent instance is null.");=20 + if (val =3D=3D null) + logger.debug("compareWith is null.");=20 + } + } fail(ASSERTION_FAILED, "Incorrect value for " + ArrayCollections.fieldSpecs[= i]); } Modified: incubator/jdo/trunk/tck20/test/java/org/apache/jdo/tck/pc/fieldty= pes/SimpleClass.java URL: http://svn.apache.org/viewcvs/incubator/jdo/trunk/tck20/test/java/org/= apache/jdo/tck/pc/fieldtypes/SimpleClass.java?rev=3D168257&r1=3D168256&r2= =3D168257&view=3Ddiff =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D --- incubator/jdo/trunk/tck20/test/java/org/apache/jdo/tck/pc/fieldtypes/Si= mpleClass.java (original) +++ incubator/jdo/trunk/tck20/test/java/org/apache/jdo/tck/pc/fieldtypes/Si= mpleClass.java Wed May 4 21:00:51 2005 @@ -21,7 +21,7 @@ import java.util.Date; import java.io.Serializable; =20 -public class SimpleClass implements SimpleInterface, Comparable { +public class SimpleClass implements Serializable, SimpleInterface, Compara= ble { =20 private static long counter =3D new Date().getTime(); private static long newId() { Modified: incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache= /jdo/tck/pc/fieldtypes/ArrayCollections-derby.orm URL: http://svn.apache.org/viewcvs/incubator/jdo/trunk/tck20/test/orm/appli= cationidentity/org/apache/jdo/tck/pc/fieldtypes/ArrayCollections-derby.orm?= rev=3D168257&r1=3D168256&r2=3D168257&view=3Ddiff =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D --- incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/t= ck/pc/fieldtypes/ArrayCollections-derby.orm (original) +++ incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/t= ck/pc/fieldtypes/ArrayCollections-derby.orm Wed May 4 21:00:51 2005 @@ -9,32 +9,32 @@ - + - + - + - + - + - + Modified: incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache= /jdo/tck/pc/fieldtypes/CollectionCollections-derby.orm URL: http://svn.apache.org/viewcvs/incubator/jdo/trunk/tck20/test/orm/appli= cationidentity/org/apache/jdo/tck/pc/fieldtypes/CollectionCollections-derby= .orm?rev=3D168257&r1=3D168256&r2=3D168257&view=3Ddiff =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D --- incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/t= ck/pc/fieldtypes/CollectionCollections-derby.orm (original) +++ incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/t= ck/pc/fieldtypes/CollectionCollections-derby.orm Wed May 4 21:00:51 2005 @@ -6,39 +6,39 @@ - + - + - + - + - + - + - + - + - + Added: incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jd= o/tck/pc/fieldtypes/FieldsOfSimpleClass-derby.orm URL: http://svn.apache.org/viewcvs/incubator/jdo/trunk/tck20/test/orm/appli= cationidentity/org/apache/jdo/tck/pc/fieldtypes/FieldsOfSimpleClass-derby.o= rm?rev=3D168257&view=3Dauto =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D --- incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/t= ck/pc/fieldtypes/FieldsOfSimpleClass-derby.orm (added) +++ incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/t= ck/pc/fieldtypes/FieldsOfSimpleClass-derby.orm Wed May 4 21:00:51 2005 @@ -0,0 +1,217 @@ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + Propchange: incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apac= he/jdo/tck/pc/fieldtypes/FieldsOfSimpleClass-derby.orm ---------------------------------------------------------------------------= --- svn:executable =3D * Added: incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jd= o/tck/pc/fieldtypes/SimpleClass-derby.orm URL: http://svn.apache.org/viewcvs/incubator/jdo/trunk/tck20/test/orm/appli= cationidentity/org/apache/jdo/tck/pc/fieldtypes/SimpleClass-derby.orm?rev= =3D168257&view=3Dauto =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D --- incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/t= ck/pc/fieldtypes/SimpleClass-derby.orm (added) +++ incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/t= ck/pc/fieldtypes/SimpleClass-derby.orm Wed May 4 21:00:51 2005 @@ -0,0 +1,11 @@ + + + + + + + + + + + Propchange: incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apac= he/jdo/tck/pc/fieldtypes/SimpleClass-derby.orm ---------------------------------------------------------------------------= --- svn:executable =3D * 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=3D168257&r1=3D168256&r2=3D168257&view=3Ddiff =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D --- incubator/jdo/trunk/tck20/test/sql/derby/schema1.sql (original) +++ incubator/jdo/trunk/tck20/test/sql/derby/schema1.sql Wed May 4 21:00:5= 1 2005 @@ -157,6 +157,8 @@ --fieldtypes ------------------------- =20 +DROP TABLE SIMPLE_CLASS; +DROP TABLE FIELDSOFSIMPLECLASS; DROP TABLE FieldsOfByte; DROP TABLE FIELDSOFBIGDECIMAL; DROP TABLE FIELDSOFBIGINTEGER; @@ -180,35 +182,36 @@ DROP TABLE FIELDSOFSHORT; DROP TABLE FIELDSOFSTRING; DROP TABLE ARRAY_COLLECTIONS; -DROP TABLE ARRAY_OF_BIG_DECIMAL12; -DROP TABLE ARRAY_OF_BIG_DECIMAL13; -DROP TABLE ARRAY_OF_BIG_INTEGER14; -DROP TABLE ARRAY_OF_BIG_INTEGER15; -DROP TABLE ARRAY_OF_BYTE16; -DROP TABLE ARRAY_OF_BYTE17; -DROP TABLE ARRAY_OF_DATE8; -DROP TABLE ARRAY_OF_DATE9; -DROP TABLE ARRAY_OF_DOUBLE18; -DROP TABLE ARRAY_OF_DOUBLE19; -DROP TABLE ARRAY_OF_FLOAT20; -DROP TABLE ARRAY_OF_FLOAT21; -DROP TABLE ARRAY_OF_INTEGER22; -DROP TABLE ARRAY_OF_INTEGER23; -DROP TABLE ARRAY_OF_LOCALE10; -DROP TABLE ARRAY_OF_LOCALE11; -DROP TABLE ARRAY_OF_LONG24; -DROP TABLE ARRAY_OF_LONG25; -DROP TABLE ARRAY_OF_OBJECT0; -DROP TABLE ARRAY_OF_OBJECT1; -DROP TABLE ARRAY_OF_SHORT26; -DROP TABLE ARRAY_OF_SHORT27; -DROP TABLE ARRAY_OF_SIMPLE_CLASS2; -DROP TABLE ARRAY_OF_SIMPLE_CLASS3; -DROP TABLE ARRAY_OF_SIMPLE_INTERFACE4; -DROP TABLE ARRAY_OF_SIMPLE_INTERFACE5; -DROP TABLE ARRAY_OF_STRING6; -DROP TABLE ARRAY_OF_STRING7; -DROP TABLE ARRAYLISTCOLLECTIONS; +DROP TABLE COLLECTION_COLLECTIONS; +DROP TABLE COLLECTION_OF_OBJECT0; +DROP TABLE COLLECTION_OF_OBJECT1; +DROP TABLE COLLECTION_OF_SIMPLE_CLASS2; +DROP TABLE COLLECTION_OF_SIMPLE_CLASS3; +DROP TABLE COLLECTION_OF_SIMPLE_INTERFACE4; +DROP TABLE COLLECTION_OF_SIMPLE_INTERFACE5; +DROP TABLE COLLECTION_OF_STRING6; +DROP TABLE COLLECTION_OF_STRING7; +DROP TABLE COLLECTION_OF_DATE8; +DROP TABLE COLLECTION_OF_DATE9; +DROP TABLE COLLECTION_OF_LOCALE10; +DROP TABLE COLLECTION_OF_LOCALE11; +DROP TABLE COLLECTION_OF_BIG_DECIMAL12; +DROP TABLE COLLECTION_OF_BIG_DECIMAL13; +DROP TABLE COLLECTION_OF_BIG_INTEGER14; +DROP TABLE COLLECTION_OF_BIG_INTEGER15; +DROP TABLE COLLECTION_OF_BYTE16; +DROP TABLE COLLECTION_OF_BYTE17; +DROP TABLE COLLECTION_OF_DOUBLE18; +DROP TABLE COLLECTION_OF_DOUBLE19; +DROP TABLE COLLECTION_OF_FLOAT20; +DROP TABLE COLLECTION_OF_FLOAT21; +DROP TABLE COLLECTION_OF_INTEGER22; +DROP TABLE COLLECTION_OF_INTEGER23; +DROP TABLE COLLECTION_OF_LONG24; +DROP TABLE COLLECTION_OF_LONG25; +DROP TABLE COLLECTION_OF_SHORT26; +DROP TABLE COLLECTION_OF_SHORT27; + =20 CREATE TABLE FIELDSOFBIGDECIMAL ( @@ -1939,239 +1942,152 @@ CONSTRAINT FieldsOfByte_PK PRIMARY KEY (IDENTIFIER) ); =20 -CREATE TABLE ARRAY_COLLECTIONS -( - IDENTIFIER INTEGER NOT NULL, - CONSTRAINT AK12_PK PRIMARY KEY (IDENTIFIER) -); - -CREATE TABLE ARRAY_OF_BIG_DECIMAL12 -( - IDENTIFIER INTEGER REFERENCES ARRAY_COLLECTIONS NOT NULL, - INDEX INTEGER NOT NULL, - BIG_DECIMALVAL LONG VARCHAR FOR BIT DATA, - CONSTRAINT BD12_PK PRIMARY KEY (IDENTIFIER) -); - -CREATE TABLE ARRAY_OF_BIG_DECIMAL13 -( - IDENTIFIER INTEGER REFERENCES ARRAY_COLLECTIONS NOT NULL, - INDEX INTEGER NOT NULL, - BIG_DECIMALVAL LONG VARCHAR FOR BIT DATA, - CONSTRAINT BD13_PK PRIMARY KEY (IDENTIFIER) -); - -CREATE TABLE ARRAY_OF_BIG_INTEGER14 -( - IDENTIFIER INTEGER REFERENCES ARRAY_COLLECTIONS NOT NULL, - INDEX INTEGER NOT NULL, - BIG_INTEGERVAL BIGINT, - CONSTRAINT BI14_PK PRIMARY KEY (IDENTIFIER) -); - -CREATE TABLE ARRAY_OF_BIG_INTEGER15 -( - IDENTIFIER INTEGER REFERENCES ARRAY_COLLECTIONS NOT NULL, - INDEX INTEGER NOT NULL, - BIG_INTEGERVAL BIGINT, - CONSTRAINT BI15_PK PRIMARY KEY (IDENTIFIER) -); - -CREATE TABLE ARRAY_OF_BYTE16 -( - IDENTIFIER INTEGER REFERENCES ARRAY_COLLECTIONS NOT NULL, - INDEX INTEGER NOT NULL, - BYTEVAL SMALLINT, - CONSTRAINT BY16_PK PRIMARY KEY (IDENTIFIER) -); - -CREATE TABLE ARRAY_OF_BYTE17 -( - IDENTIFIER INTEGER REFERENCES ARRAY_COLLECTIONS NOT NULL, - INDEX INTEGER NOT NULL, - BYTEVAL SMALLINT, - CONSTRAINT BY17_PK PRIMARY KEY (IDENTIFIER) -); - -CREATE TABLE ARRAY_OF_DATE8 -( - IDENTIFIER INTEGER REFERENCES ARRAY_COLLECTIONS NOT NULL, - INDEX INTEGER NOT NULL, - DATEVAL DATE, - CONSTRAINT BY8_PK PRIMARY KEY (IDENTIFIER) -); - -CREATE TABLE ARRAY_OF_DATE9 -( - IDENTIFIER INTEGER REFERENCES ARRAY_COLLECTIONS NOT NULL, - INDEX INTEGER NOT NULL, - DATEVAL DATE, - CONSTRAINT BY9_PK PRIMARY KEY (IDENTIFIER) -); - -CREATE TABLE ARRAY_OF_DOUBLE18 -( - IDENTIFIER INTEGER REFERENCES ARRAY_COLLECTIONS NOT NULL, - INDEX INTEGER NOT NULL, - DOUBLEVAL DOUBLE, - CONSTRAINT DO18_PK PRIMARY KEY (IDENTIFIER) -); - -CREATE TABLE ARRAY_OF_DOUBLE19 -( - IDENTIFIER INTEGER REFERENCES ARRAY_COLLECTIONS NOT NULL, - INDEX INTEGER NOT NULL, - DOUBLEVAL DOUBLE, - CONSTRAINT DO19_PK PRIMARY KEY (IDENTIFIER) -); - -CREATE TABLE ARRAY_OF_FLOAT20 -( - IDENTIFIER INTEGER REFERENCES ARRAY_COLLECTIONS NOT NULL, - INDEX INTEGER NOT NULL, - FLOATVAL FLOAT, - CONSTRAINT FL20 PRIMARY KEY (IDENTIFIER) -); - -CREATE TABLE ARRAY_OF_FLOAT21 -( - IDENTIFIER INTEGER REFERENCES ARRAY_COLLECTIONS NOT NULL, - INDEX INTEGER NOT NULL, - FLOATVAL FLOAT, - CONSTRAINT FL21 PRIMARY KEY (IDENTIFIER) -); - -CREATE TABLE ARRAY_OF_INTEGER22 -( - IDENTIFIER INTEGER REFERENCES ARRAY_COLLECTIONS NOT NULL, - INDEX INTEGER NOT NULL, - INTEGERVAL INTEGER, - CONSTRAINT IN22 PRIMARY KEY (IDENTIFIER) -); - -CREATE TABLE ARRAY_OF_INTEGER23 -( - IDENTIFIER INTEGER REFERENCES ARRAY_COLLECTIONS NOT NULL, - INDEX INTEGER NOT NULL, - INTEGERVAL INTEGER, - CONSTRAINT IN23 PRIMARY KEY (IDENTIFIER) -); - -CREATE TABLE ARRAY_OF_LOCALE10 -( - IDENTIFIER INTEGER REFERENCES ARRAY_COLLECTIONS NOT NULL, - INDEX INTEGER NOT NULL, - LOCALEVAL CHAR(20), - CONSTRAINT LOC10 PRIMARY KEY (IDENTIFIER) -); - -CREATE TABLE ARRAY_OF_LOCALE11 -( - IDENTIFIER INTEGER REFERENCES ARRAY_COLLECTIONS NOT NULL, - INDEX INTEGER NOT NULL, - LOCALEVAL CHAR(20), - CONSTRAINT LOC11 PRIMARY KEY (IDENTIFIER) -); - -CREATE TABLE ARRAY_OF_LONG24 -( - IDENTIFIER INTEGER REFERENCES ARRAY_COLLECTIONS NOT NULL, - INDEX INTEGER NOT NULL, - LONGVAL BIGINT, - CONSTRAINT BI24_PK PRIMARY KEY (IDENTIFIER) -); - -CREATE TABLE ARRAY_OF_LONG25 -( - IDENTIFIER INTEGER REFERENCES ARRAY_COLLECTIONS NOT NULL, - INDEX INTEGER NOT NULL, - LONGVAL BIGINT, - CONSTRAINT BI25_PK PRIMARY KEY (IDENTIFIER) -); - -CREATE TABLE ARRAY_OF_OBJECT0 -( - IDENTIFIER INTEGER REFERENCES ARRAY_COLLECTIONS NOT NULL, - INDEX INTEGER NOT NULL, - OBJVAL BLOB, - CONSTRAINT OB0_PK PRIMARY KEY (IDENTIFIER) -); - -CREATE TABLE ARRAY_OF_OBJECT1 -( - IDENTIFIER INTEGER REFERENCES ARRAY_COLLECTIONS NOT NULL, - INDEX INTEGER NOT NULL, - OBJVAL BLOB, - CONSTRAINT OB1_PK PRIMARY KEY (IDENTIFIER) -); - -CREATE TABLE ARRAY_OF_SHORT26 +CREATE TABLE SIMPLE_CLASS ( - IDENTIFIER INTEGER REFERENCES ARRAY_COLLECTIONS NOT NULL, - INDEX INTEGER NOT NULL, - SHORTVAL SMALLINT, - CONSTRAINT SM26_PK PRIMARY KEY (IDENTIFIER) + IDENTIFIER BIGINT NOT NULL, + INTVAL INTEGER NOT NULL, + STRINGVAL VARCHAR(128) NOT NULL, + CONSTRAINT SIMPLE_CLASS_PK PRIMARY KEY (IDENTIFIER) +); + +CREATE TABLE FIELDSOFSIMPLECLASS +( + IDENTIFIER INTEGER NOT NULL, + SIMPLECLASS0 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS1 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS2 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS3 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS4 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS5 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS6 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS7 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS10 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS11 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS12 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS13 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS14 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS16 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS17 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS18 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS19 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS20 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS21 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS22 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS23 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS29 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS30 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS31 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS32 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS33 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS36 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS37 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS38 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS39 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS40 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS41 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS42 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS43 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS46 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS47 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS48 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS49 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS50 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS52 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS53 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS54 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS55 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS56 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS57 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS58 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS59 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS65 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS66 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS67 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS68 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS69 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS72 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS73 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS74 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS75 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS76 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS77 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS78 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS79 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS82 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS83 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS84 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS85 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS86 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS88 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS89 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS90 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS91 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS92 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS93 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS94 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS95 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS101 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS102 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS103 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS104 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS105 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS108 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS109 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS110 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS111 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS112 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS113 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS114 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS115 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS118 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS119 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS120 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS121 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS122 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS124 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS125 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS126 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS127 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS128 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS129 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS130 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS131 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS137 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS138 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS139 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS140 BIGINT REFERENCES SIMPLE_CLASS, + SIMPLECLASS141 BIGINT REFERENCES SIMPLE_CLASS ); =20 -CREATE TABLE ARRAY_OF_SHORT27 -( - IDENTIFIER INTEGER REFERENCES ARRAY_COLLECTIONS NOT NULL, - INDEX INTEGER NOT NULL, - SHORTVAL SMALLINT, - CONSTRAINT SM27_PK PRIMARY KEY (IDENTIFIER) -); - -CREATE TABLE ARRAY_OF_SIMPLE_CLASS2 -( - IDENTIFIER INTEGER REFERENCES ARRAY_COLLECTIONS NOT NULL, - INDEX INTEGER NOT NULL, - SIMPINTERFVAL BLOB, - CONSTRAINT SI4_PK PRIMARY KEY (IDENTIFIER) -); - -CREATE TABLE ARRAY_OF_SIMPLE_CLASS3 -( - IDENTIFIER INTEGER REFERENCES ARRAY_COLLECTIONS NOT NULL, - INDEX INTEGER NOT NULL, - SIMPINTERFVAL BLOB, - CONSTRAINT SI4_PK PRIMARY KEY (IDENTIFIER) -); - -CREATE TABLE ARRAY_OF_SIMPLE_INTERFACE4 -( - IDENTIFIER INTEGER REFERENCES ARRAY_COLLECTIONS NOT NULL, - INDEX INTEGER NOT NULL, - SIMPINTERFVAL BLOB, - CONSTRAINT SI4_PK PRIMARY KEY (IDENTIFIER) -); - -CREATE TABLE ARRAY_OF_SIMPLE_INTERFACE5 -( - IDENTIFIER INTEGER REFERENCES ARRAY_COLLECTIONS NOT NULL, - INDEX INTEGER NOT NULL, - SIMPINTERFVAL BLOB, - CONSTRAINT SI5_PK PRIMARY KEY (IDENTIFIER) -); - -CREATE TABLE ARRAY_OF_STRING6 -( - IDENTIFIER INTEGER REFERENCES ARRAY_COLLECTIONS NOT NULL, - INDEX INTEGER NOT NULL, - STRINGVAL VARCHAR(1024), - CONSTRAINT ST6_PK PRIMARY KEY (IDENTIFIER) -); - -CREATE TABLE ARRAY_OF_STRING7 -( - IDENTIFIER INTEGER REFERENCES ARRAY_COLLECTIONS NOT NULL, - INDEX INTEGER NOT NULL, - STRINGVAL VARCHAR(1024), - CONSTRAINT ST7_PK PRIMARY KEY (IDENTIFIER) -); - -CREATE TABLE ARRAYLISTCOLLECTIONS +CREATE TABLE ARRAY_COLLECTIONS ( - IDENTIFIER INTEGER NOT NULL + IDENTIFIER INTEGER NOT NULL, + ARRAY_OF_BIG_DECIMAL12 LONG VARCHAR FOR BIT DATA, + ARRAY_OF_BIG_DECIMAL13 LONG VARCHAR FOR BIT DATA, + ARRAY_OF_BIG_INTEGER14 LONG VARCHAR FOR BIT DATA, + ARRAY_OF_BIG_INTEGER15 LONG VARCHAR FOR BIT DATA, + ARRAY_OF_BYTE16 LONG VARCHAR FOR BIT DATA, + ARRAY_OF_BYTE17 LONG VARCHAR FOR BIT DATA, + ARRAY_OF_DATE8 LONG VARCHAR FOR BIT DATA, + ARRAY_OF_DATE9 LONG VARCHAR FOR BIT DATA, + ARRAY_OF_DOUBLE18 LONG VARCHAR FOR BIT DATA, + ARRAY_OF_DOUBLE19 LONG VARCHAR FOR BIT DATA, + ARRAY_OF_FLOAT20 LONG VARCHAR FOR BIT DATA, + ARRAY_OF_FLOAT21 LONG VARCHAR FOR BIT DATA, + ARRAY_OF_INTEGER22 LONG VARCHAR FOR BIT DATA, + ARRAY_OF_INTEGER23 LONG VARCHAR FOR BIT DATA, + ARRAY_OF_LOCALE10 LONG VARCHAR FOR BIT DATA, + ARRAY_OF_LOCALE11 LONG VARCHAR FOR BIT DATA, + ARRAY_OF_LONG24 LONG VARCHAR FOR BIT DATA, + ARRAY_OF_LONG25 LONG VARCHAR FOR BIT DATA, + ARRAY_OF_OBJECT0 LONG VARCHAR FOR BIT DATA, + ARRAY_OF_OBJECT1 LONG VARCHAR FOR BIT DATA, + ARRAY_OF_SHORT26 LONG VARCHAR FOR BIT DATA, + ARRAY_OF_SHORT27 LONG VARCHAR FOR BIT DATA, + ARRAY_OF_SIMPLE_INTERFACE4 LONG VARCHAR FOR BIT DATA, + ARRAY_OF_SIMPLE_INTERFACE5 LONG VARCHAR FOR BIT DATA, + ARRAY_OF_STRING6 LONG VARCHAR FOR BIT DATA, + ARRAY_OF_STRING7 LONG VARCHAR FOR BIT DATA ); =20 --CollectionCollections @@ -2180,203 +2096,175 @@ CREATE TABLE COLLECTION_COLLECTIONS ( IDENTIFIER INTEGER NOT NULL, - CONSTRAINT AK12_PK PRIMARY KEY (IDENTIFIER) + CONSTRAINT CC_PK PRIMARY KEY (IDENTIFIER) ); =20 CREATE TABLE COLLECTION_OF_OBJECT0 ( IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL, - OBJVAL BLOB, - CONSTRAINT OB0_PK PRIMARY KEY (IDENTIFIER) + OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL ); =20 CREATE TABLE COLLECTION_OF_OBJECT1 ( IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL, - OBJVAL BLOB, - CONSTRAINT OB1_PK PRIMARY KEY (IDENTIFIER) + OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL ); =20 CREATE TABLE COLLECTION_OF_SIMPLE_CLASS2 ( IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL, - SIMPINTERFVAL BLOB, - CONSTRAINT SI4_PK PRIMARY KEY (IDENTIFIER) + SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL ); =20 CREATE TABLE COLLECTION_OF_SIMPLE_CLASS3 ( IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL, - SIMPINTERFVAL BLOB, - CONSTRAINT SI4_PK PRIMARY KEY (IDENTIFIER) + SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL ); =20 CREATE TABLE COLLECTION_OF_SIMPLE_INTERFACE4 ( IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL, - SIMPINTERFVAL BLOB, - CONSTRAINT SI4_PK PRIMARY KEY (IDENTIFIER) + SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL ); =20 CREATE TABLE COLLECTION_OF_SIMPLE_INTERFACE5 ( IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL, - SIMPINTERFVAL BLOB, - CONSTRAINT SI5_PK PRIMARY KEY (IDENTIFIER) + SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL ); =20 CREATE TABLE COLLECTION_OF_STRING6 ( IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL, - STRINGVAL VARCHAR(1024), - CONSTRAINT ST6_PK PRIMARY KEY (IDENTIFIER) + STRINGVAL VARCHAR(1024) ); =20 CREATE TABLE COLLECTION_OF_STRING7 ( IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL, - STRINGVAL VARCHAR(1024), - CONSTRAINT ST7_PK PRIMARY KEY (IDENTIFIER) + STRINGVAL VARCHAR(1024) ); =20 CREATE TABLE COLLECTION_OF_DATE8 ( IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL, - DATEVAL DATE, - CONSTRAINT BY8_PK PRIMARY KEY (IDENTIFIER) + DATEVAL DATE ); =20 CREATE TABLE COLLECTION_OF_DATE9 ( IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL, - DATEVAL DATE, - CONSTRAINT BY9_PK PRIMARY KEY (IDENTIFIER) + DATEVAL DATE ); =20 CREATE TABLE COLLECTION_OF_LOCALE10 ( IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL, - LOCALEVAL CHAR(20), - CONSTRAINT LOC10 PRIMARY KEY (IDENTIFIER) + LOCALEVAL CHAR(20) ); =20 CREATE TABLE COLLECTION_OF_LOCALE11 ( IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL, - LOCALEVAL CHAR(20), - CONSTRAINT LOC11 PRIMARY KEY (IDENTIFIER) + LOCALEVAL CHAR(20) ); =20 CREATE TABLE COLLECTION_OF_BIG_DECIMAL12 ( IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL, - BIG_DECIMALVAL LONG VARCHAR FOR BIT DATA, - CONSTRAINT BD12_PK PRIMARY KEY (IDENTIFIER) + BIG_DECIMALVAL LONG VARCHAR FOR BIT DATA ); =20 CREATE TABLE COLLECTION_OF_BIG_DECIMAL13 ( IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL, - BIG_DECIMALVAL LONG VARCHAR FOR BIT DATA, - CONSTRAINT BD13_PK PRIMARY KEY (IDENTIFIER) + BIG_DECIMALVAL LONG VARCHAR FOR BIT DATA ); =20 CREATE TABLE COLLECTION_OF_BIG_INTEGER14 ( IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL, - BIG_INTEGERVAL BIGINT, - CONSTRAINT BI14_PK PRIMARY KEY (IDENTIFIER) + BIG_INTEGERVAL BIGINT ); =20 CREATE TABLE COLLECTION_OF_BIG_INTEGER15 ( IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL, - BIG_INTEGERVAL BIGINT, - CONSTRAINT BI15_PK PRIMARY KEY (IDENTIFIER) + BIG_INTEGERVAL BIGINT ); =20 CREATE TABLE COLLECTION_OF_BYTE16 ( IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL, - BYTEVAL SMALLINT, - CONSTRAINT BY16_PK PRIMARY KEY (IDENTIFIER) + BYTEVAL SMALLINT ); =20 CREATE TABLE COLLECTION_OF_BYTE17 ( IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL, - BYTEVAL SMALLINT, - CONSTRAINT BY17_PK PRIMARY KEY (IDENTIFIER) + BYTEVAL SMALLINT ); =20 CREATE TABLE COLLECTION_OF_DOUBLE18 ( IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL, - DOUBLEVAL DOUBLE, - CONSTRAINT DO18_PK PRIMARY KEY (IDENTIFIER) + DOUBLEVAL DOUBLE ); =20 CREATE TABLE COLLECTION_OF_DOUBLE19 ( IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL, - DOUBLEVAL DOUBLE, - CONSTRAINT DO19_PK PRIMARY KEY (IDENTIFIER) + DOUBLEVAL DOUBLE ); =20 CREATE TABLE COLLECTION_OF_FLOAT20 ( IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL, - FLOATVAL FLOAT, - CONSTRAINT FL20 PRIMARY KEY (IDENTIFIER) + FLOATVAL FLOAT ); =20 CREATE TABLE COLLECTION_OF_FLOAT21 ( IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL, - FLOATVAL FLOAT, - CONSTRAINT FL21 PRIMARY KEY (IDENTIFIER) + FLOATVAL FLOAT ); =20 CREATE TABLE COLLECTION_OF_INTEGER22 ( IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL, - INTEGERVAL INTEGER, - CONSTRAINT IN22 PRIMARY KEY (IDENTIFIER) + INTEGERVAL INTEGER ); =20 CREATE TABLE COLLECTION_OF_INTEGER23 ( IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL, - INTEGERVAL INTEGER, - CONSTRAINT IN23 PRIMARY KEY (IDENTIFIER) + INTEGERVAL INTEGER ); =20 CREATE TABLE COLLECTION_OF_LONG24 ( IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL, - LONGVAL BIGINT, - CONSTRAINT BI24_PK PRIMARY KEY (IDENTIFIER) + LONGVAL BIGINT ); =20 CREATE TABLE COLLECTION_OF_LONG25 ( IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL, - LONGVAL BIGINT, - CONSTRAINT BI25_PK PRIMARY KEY (IDENTIFIER) + LONGVAL BIGINT ); =20 CREATE TABLE COLLECTION_OF_SHORT26 ( IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL, - SHORTVAL SMALLINT, - CONSTRAINT SM26_PK PRIMARY KEY (IDENTIFIER) + SHORTVAL SMALLINT ); =20 CREATE TABLE COLLECTION_OF_SHORT27 ( IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL, - SHORTVAL SMALLINT, - CONSTRAINT SM27_PK PRIMARY KEY (IDENTIFIER) + SHORTVAL SMALLINT ); =20 -------------------------