Author: mcaisse Date: Tue May 3 15:10:13 2005 New Revision: 168004 URL: http://svn.apache.org/viewcvs?rev=168004&view=rev Log: JDO-35; JDO-8 interim check-in
Added: incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/CollectionCollections-derby.orm (with props) Modified: incubator/jdo/trunk/tck20/test/jdo/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/SimpleClass.jdo incubator/jdo/trunk/tck20/test/jdo/datastoreidentity/org/apache/jdo/tck/pc/fieldtypes/SimpleClass.jdo incubator/jdo/trunk/tck20/test/sql/derby/schema1.sql Modified: incubator/jdo/trunk/tck20/test/jdo/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/SimpleClass.jdo URL: http://svn.apache.org/viewcvs/incubator/jdo/trunk/tck20/test/jdo/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/SimpleClass.jdo?rev=168004&r1=168003&r2=168004&view=diff ============================================================================== --- incubator/jdo/trunk/tck20/test/jdo/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/SimpleClass.jdo (original) +++ incubator/jdo/trunk/tck20/test/jdo/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/SimpleClass.jdo Tue May 3 15:10:13 2005 @@ -1,10 +1,11 @@ <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE jdo PUBLIC "-//Sun Microsystems, Inc.//DTD Java Data Objects Metadata 2.0//EN" "http://java.sun.com/dtd/jdo_2_0.dtd"> <jdo> -<package name="org.apache.jdo.tck.pc.fieldtypes"> -<class name="SimpleClass" identity-type="application" - objectid-class="org.apache.jdo.tck.pc.fieldtypes.SimpleClass$Oid"> -<field name="id" primary-key="true"/> -</class> -</package> + <package name="org.apache.jdo.tck.pc.fieldtypes"> + <class name="SimpleClass" identity-type="application" + objectid-class="org.apache.jdo.tck.pc.fieldtypes.SimpleClass$Oid"> + <implements name="SimpleInterface"/> + <field name="id" primary-key="true"/> + </class> + </package> </jdo> Modified: incubator/jdo/trunk/tck20/test/jdo/datastoreidentity/org/apache/jdo/tck/pc/fieldtypes/SimpleClass.jdo URL: http://svn.apache.org/viewcvs/incubator/jdo/trunk/tck20/test/jdo/datastoreidentity/org/apache/jdo/tck/pc/fieldtypes/SimpleClass.jdo?rev=168004&r1=168003&r2=168004&view=diff ============================================================================== --- incubator/jdo/trunk/tck20/test/jdo/datastoreidentity/org/apache/jdo/tck/pc/fieldtypes/SimpleClass.jdo (original) +++ incubator/jdo/trunk/tck20/test/jdo/datastoreidentity/org/apache/jdo/tck/pc/fieldtypes/SimpleClass.jdo Tue May 3 15:10:13 2005 @@ -1,8 +1,9 @@ <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE jdo PUBLIC "-//Sun Microsystems, Inc.//DTD Java Data Objects Metadata 2.0//EN" "http://java.sun.com/dtd/jdo_2_0.dtd"> <jdo> -<package name="org.apache.jdo.tck.pc.fieldtypes"> -<class name="SimpleClass" identity-type="datastore"> -</class> -</package> + <package name="org.apache.jdo.tck.pc.fieldtypes"> + <class name="SimpleClass" identity-type="datastore"> + <implements name="SimpleInteface"/> + </class> + </package> </jdo> Added: 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/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/CollectionCollections-derby.orm?rev=168004&view=auto ============================================================================== --- incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/CollectionCollections-derby.orm (added) +++ incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/CollectionCollections-derby.orm Tue May 3 15:10:13 2005 @@ -0,0 +1,177 @@ +<?xml version="1.0" encoding="UTF-8"?> +<!DOCTYPE orm PUBLIC "-//Sun Microsystems, Inc.//DTD Java Data Objects Mapping Metadata 2.0//EN" "http://java.sun.com/dtd/orm_2_0.dtd"> +<orm> + <package name="org.apache.jdo.tck.pc.fieldtypes"> + <class name="CollectionCollections" table="COLLECTION_COLLECTIONS"> + <field name="identifier" column="IDENTIFIER" primary-key="true"/> + <field name="CollectionOfObject0" table="COLLECTION_OF_OBJECT0"> + <join column="IDENTIFIER"/> + <element column="OBJVAL"/> + </field> + <field name="CollectionOfObject1" table="COLLECTION_OF_OBJECT1"> + <join column="IDENTIFIER"/> + <element column="OBJVAL"/> + </field> + <field name="CollectionOfObject2" table="COLLECTION_OF_OBJECT2"> + <join column="IDENTIFIER"/> + <element column="OBJVAL"/> + </field> + <field name="CollectionOfSimpleClass3" table="COLLECTION_OF_SIMPLE_CLASS3"> + <join column="IDENTIFIER"/> + <element column="SIMPINTVAL"/> + </field> + <field name="CollectionOfSimpleClass4" table="COLLECTION_OF_SIMPLE_CLASS4"> + <join column="IDENTIFIER"/> + <element column="SIMPINTVAL"/> + </field> + <field name="CollectionOfSimpleClass5" table="COLLECTION_OF_SIMPLE_CLASS5"> + <join column="IDENTIFIER"/> + <element column="SIMPINTVAL"/> + </field> + <field name="CollectionOfSimpleInterface6" table="COLLECTION_OF_SIMPLE_INTERFACE6"> + <join column="IDENTIFIER"/> + <element column="SIMPINTVAL"/> + </field> + <field name="CollectionOfSimpleInterface7" table="COLLECTION_OF_SIMPLE_INTERFACE7"> + <join column="IDENTIFIER"/> + <element column="SIMPINTVAL"/> + </field> + <field name="CollectionOfSimpleInterface8" table="COLLECTION_OF_SIMPLE_INTERFACE8"> + <join column="IDENTIFIER"/> + <element column="SIMPINTVAL"/> + </field> + <field name="CollectionOfString9" table="COLLECTION_OF_STRING9"> + <join column="IDENTIFIER"/> + <element column="STRINGVAL"/> + </field> + <field name="CollectionOfString10" table="COLLECTION_OF_STRING10"> + <join column="IDENTIFIER"/> + <element column="STRINGVAL"/> + </field> + <field name="CollectionOfString11" table="COLLECTION_OF_STRING11"> + <join column="IDENTIFIER"/> + <element column="STRINGVAL"/> + </field> + <field name="CollectionOfDate12" table="COLLECTION_OF_DATE12"> + <join column="IDENTIFIER"/> + <element column="DATEVAL"/> + </field> + <field name="CollectionOfDate13" table="COLLECTION_OF_DATE13"> + <join column="IDENTIFIER"/> + <element column="DATEVAL"/> + </field> + <field name="CollectionOfDate14" table="COLLECTION_OF_DATE14"> + <join column="IDENTIFIER"/> + <element column="DATEVAL"/> + </field> + <field name="CollectionOfLocale15" table="COLLECTION_OF_LOCALE15"> + <join column="IDENTIFIER"/> + <element column="LOCALEVAL"/> + </field> + <field name="CollectionOfLocale16" table="COLLECTION_OF_LOCALE16"> + <join column="IDENTIFIER"/> + <element column="LOCALEVAL"/> + </field> + <field name="CollectionOfLocale17" table="COLLECTION_OF_LOCALE17"> + <join column="IDENTIFIER"/> + <element column="LOCALEVAL"/> + </field> + <field name="CollectionOfBigDecimal18" table="COLLECTION_OF_BIG_DECIMAL18"> + <join column="IDENTIFIER"/> + <element column="BIG_DECIMALVAL"/> + </field> + <field name="CollectionOfBigDecimal19" table="COLLECTION_OF_BIG_DECIMAL19"> + <join column="IDENTIFIER"/> + <element column="BIG_DECIMALVAL"/> + </field> + <field name="CollectionOfBigDecimal20" table="COLLECTION_OF_BIG_DECIMAL20"> + <join column="IDENTIFIER"/> + <element column="BIG_DECIMALVAL"/> + </field> + <field name="CollectionOfBigInteger21" table="COLLECTION_OF_BIG_INTEGER21"> + <join column="IDENTIFIER"/> + <element column="BIG_INTEGERVAL"/> + </field> + <field name="CollectionOfBigInteger22" table="COLLECTION_OF_BIG_INTEGER22"> + <join column="IDENTIFIER"/> + <element column="BIG_INTEGERVAL"/> + </field> + <field name="CollectionOfBigInteger23" table="COLLECTION_OF_BIG_INTEGER23"> + <join column="IDENTIFIER"/> + <element column="BIG_INTEGERVAL"/> + </field> + <field name="CollectionOfByte24" table="COLLECTION_OF_BYTE24"> + <join column="IDENTIFIER"/> + <element column="BYTEVAL"/> + </field> + <field name="CollectionOfByte25" table="COLLECTION_OF_BYTE25"> + <join column="IDENTIFIER"/> + <element column="BYTEVAL"/> + </field> + <field name="CollectionOfByte26" table="COLLECTION_OF_BYTE27"> + <join column="IDENTIFIER"/> + <element column="BYTEVAL"/> + </field> + <field name="CollectionOfDouble27" table="COLLECTION_OF_DOUBLE27"> + <join column="IDENTIFIER"/> + <element column="DOUBLEVAL"/> + </field> + <field name="CollectionOfDouble28" table="COLLECTION_OF_DOUBLE28"> + <join column="IDENTIFIER"/> + <element column="DOUBLEVAL"/> + </field> + <field name="CollectionOfDouble29" table="COLLECTION_OF_DOUBLE29"> + <join column="IDENTIFIER"/> + <element column="DOUBLEVAL"/> + </field> + <field name="CollectionOfFloat30" table="COLLECTION_OF_FLOAT30"> + <join column="IDENTIFIER"/> + <element column="FLOATVAL"/> + </field> + <field name="CollectionOfFloat31" table="COLLECTION_OF_FLOAT31"> + <join column="IDENTIFIER"/> + <element column="FLOATVAL"/> + </field> + <field name="CollectionOfFloat32" table="COLLECTION_OF_FLOAT32"> + <join column="IDENTIFIER"/> + <element column="FLOATVAL"/> + </field> + <field name="CollectionOfInteger33" table="COLLECTION_OF_INTEGER33"> + <join column="IDENTIFIER"/> + <element column="INTEGERVAL"/> + </field> + <field name="CollectionOfInteger34" table="COLLECTION_OF_INTEGER34"> + <join column="IDENTIFIER"/> + <element column="INTEGERVAL"/> + </field> + <field name="CollectionOfInteger35" table="COLLECTION_OF_INTEGER35"> + <join column="IDENTIFIER"/> + <element column="INTEGERVAL"/> + </field> + <field name="CollectionOfLong36" table="COLLECTION_OF_LONG36"> + <join column="IDENTIFIER"/> + <element column="LONGVAL"/> + </field> + <field name="CollectionOfLong37" table="COLLECTION_OF_LONG37"> + <join column="IDENTIFIER"/> + <element column="LONGVAL"/> + </field> + <field name="CollectionOfLong38" table="COLLECTION_OF_LONG38"> + <join column="IDENTIFIER"/> + <element column="LONGVAL"/> + </field> + <field name="CollectionOfShort39" table="COLLECTION_OF_SHORT39"> + <join column="IDENTIFIER"/> + <element column="SHORTVAL"/> + </field> + <field name="CollectionOfShort40" table="COLLECTION_OF_SHORT40"> + <join column="IDENTIFIER"/> + <element column="SHORTVAL"/> + </field> + <field name="CollectionOfShort41" table="COLLECTION_OF_SHORT41"> + <join column="IDENTIFIER"/> + <element column="SHORTVAL"/> + </field> + </class> + </package> +</orm> Propchange: incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/CollectionCollections-derby.orm ------------------------------------------------------------------------------ svn:executable = * 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=168004&r1=168003&r2=168004&view=diff ============================================================================== --- incubator/jdo/trunk/tck20/test/sql/derby/schema1.sql (original) +++ incubator/jdo/trunk/tck20/test/sql/derby/schema1.sql Tue May 3 15:10:13 2005 @@ -179,6 +179,36 @@ DROP TABLE FIELDSOFPRIMITIVESHORT; 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; CREATE TABLE FIELDSOFBIGDECIMAL ( @@ -1909,75 +1939,6 @@ CONSTRAINT FieldsOfByte_PK PRIMARY KEY (IDENTIFIER) ); -------------------------- ---inheritance -------------------------- - -DROP TABLE AllPersist; -DROP TABLE TopNonPersistB; -DROP TABLE TopPersist; -DROP TABLE FieldSameName; - -CREATE TABLE AllPersist ( - KEY_VALUE INTEGER NOT NULL, - DOUBLE_B DOUBLE, - INT_B INTEGER, - FLOAT_E FLOAT, - SHORT_F SMALLINT, - SECOND_OBJ INTEGER, - THIRD_OBJ INTEGER, - INT_H INTEGER, - DISCRIMINATOR varchar(64) NOT NULL, - CONSTRAINT AllPersist_PK PRIMARY KEY (KEY_VALUE), - FOREIGN KEY (SECOND_OBJ) REFERENCES AllPersist (KEY_VALUE), - FOREIGN KEY (THIRD_OBJ) REFERENCES AllPersist (KEY_VALUE) -); - -CREATE TABLE TopNonPersistB ( - KEY_VALUE INTEGER NOT NULL, - DOUBLE_B DOUBLE, - INT_B INTEGER, - FLOAT_E FLOAT, - SHORT_F SMALLINT, - SECOND_OBJ INTEGER, - THIRD_OBJ INTEGER, - INT_H INTEGER, - DISCRIMINATOR varchar(64) NOT NULL, - CONSTRAINT TopNonPersistB_PK PRIMARY KEY (KEY_VALUE), - FOREIGN KEY (SECOND_OBJ) REFERENCES TopNonPersistB (KEY_VALUE), - FOREIGN KEY (THIRD_OBJ) REFERENCES TopNonPersistB (KEY_VALUE) -); - -CREATE TABLE TopPersist ( - KEY_VALUE INTEGER NOT NULL, - DOUBLE_B DOUBLE, - INT_B INTEGER, - FLOAT_E FLOAT, - SHORT_F SMALLINT, - SECOND_OBJ INTEGER, - THIRD_OBJ INTEGER, - INT_H INTEGER, - DISCRIMINATOR varchar(64) NOT NULL, - CONSTRAINT TopPersist_PK PRIMARY KEY (KEY_VALUE), - FOREIGN KEY (SECOND_OBJ) REFERENCES TopPersist (KEY_VALUE), - FOREIGN KEY (THIRD_OBJ) REFERENCES TopPersist (KEY_VALUE) -); - -CREATE TABLE FieldSameName ( - KEY_VALUE INTEGER NOT NULL, - N2 DOUBLE, - N3 INTEGER, - FSN2_N3 FLOAT, - FSN3_N1 SMALLINT, - FSN3_N2 INTEGER, - FSN3_N3 INTEGER, - FSN4_N3 INTEGER, - DISCRIMINATOR varchar(64) NOT NULL, - CONSTRAINT FieldSameName_PK PRIMARY KEY (KEY_VALUE), - FOREIGN KEY (FSN3_N2) REFERENCES FieldSameName (KEY_VALUE), - FOREIGN KEY (FSN3_N3) REFERENCES FieldSameName (KEY_VALUE) -); - CREATE TABLE ARRAY_COLLECTIONS ( IDENTIFIER INTEGER NOT NULL, @@ -2211,6 +2172,280 @@ CREATE TABLE ARRAYLISTCOLLECTIONS ( IDENTIFIER INTEGER NOT NULL +); + +--CollectionCollections + + +CREATE TABLE COLLECTION_COLLECTIONS +( + IDENTIFIER INTEGER NOT NULL, + CONSTRAINT AK12_PK PRIMARY KEY (IDENTIFIER) +); + +CREATE TABLE COLLECTION_OF_OBJECT0 +( + IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL, + OBJVAL BLOB, + CONSTRAINT OB0_PK PRIMARY KEY (IDENTIFIER) +); + +CREATE TABLE COLLECTION_OF_OBJECT1 +( + IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL, + OBJVAL BLOB, + CONSTRAINT OB1_PK PRIMARY KEY (IDENTIFIER) +); + +CREATE TABLE COLLECTION_OF_SIMPLE_CLASS2 +( + IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL, + SIMPINTERFVAL BLOB, + CONSTRAINT SI4_PK PRIMARY KEY (IDENTIFIER) +); + +CREATE TABLE COLLECTION_OF_SIMPLE_CLASS3 +( + IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL, + SIMPINTERFVAL BLOB, + CONSTRAINT SI4_PK PRIMARY KEY (IDENTIFIER) +); + +CREATE TABLE COLLECTION_OF_SIMPLE_INTERFACE4 +( + IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL, + SIMPINTERFVAL BLOB, + CONSTRAINT SI4_PK PRIMARY KEY (IDENTIFIER) +); + +CREATE TABLE COLLECTION_OF_SIMPLE_INTERFACE5 +( + IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL, + SIMPINTERFVAL BLOB, + CONSTRAINT SI5_PK PRIMARY KEY (IDENTIFIER) +); + +CREATE TABLE COLLECTION_OF_STRING6 +( + IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL, + STRINGVAL VARCHAR(1024), + CONSTRAINT ST6_PK PRIMARY KEY (IDENTIFIER) +); + +CREATE TABLE COLLECTION_OF_STRING7 +( + IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL, + STRINGVAL VARCHAR(1024), + CONSTRAINT ST7_PK PRIMARY KEY (IDENTIFIER) +); + +CREATE TABLE COLLECTION_OF_DATE8 +( + IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL, + DATEVAL DATE, + CONSTRAINT BY8_PK PRIMARY KEY (IDENTIFIER) +); + +CREATE TABLE COLLECTION_OF_DATE9 +( + IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL, + DATEVAL DATE, + CONSTRAINT BY9_PK PRIMARY KEY (IDENTIFIER) +); + +CREATE TABLE COLLECTION_OF_LOCALE10 +( + IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL, + LOCALEVAL CHAR(20), + CONSTRAINT LOC10 PRIMARY KEY (IDENTIFIER) +); + +CREATE TABLE COLLECTION_OF_LOCALE11 +( + IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL, + LOCALEVAL CHAR(20), + CONSTRAINT LOC11 PRIMARY KEY (IDENTIFIER) +); + +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) +); + +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) +); + +CREATE TABLE COLLECTION_OF_BIG_INTEGER14 +( + IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL, + BIG_INTEGERVAL BIGINT, + CONSTRAINT BI14_PK PRIMARY KEY (IDENTIFIER) +); + +CREATE TABLE COLLECTION_OF_BIG_INTEGER15 +( + IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL, + BIG_INTEGERVAL BIGINT, + CONSTRAINT BI15_PK PRIMARY KEY (IDENTIFIER) +); + +CREATE TABLE COLLECTION_OF_BYTE16 +( + IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL, + BYTEVAL SMALLINT, + CONSTRAINT BY16_PK PRIMARY KEY (IDENTIFIER) +); + +CREATE TABLE COLLECTION_OF_BYTE17 +( + IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL, + BYTEVAL SMALLINT, + CONSTRAINT BY17_PK PRIMARY KEY (IDENTIFIER) +); + +CREATE TABLE COLLECTION_OF_DOUBLE18 +( + IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL, + DOUBLEVAL DOUBLE, + CONSTRAINT DO18_PK PRIMARY KEY (IDENTIFIER) +); + +CREATE TABLE COLLECTION_OF_DOUBLE19 +( + IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL, + DOUBLEVAL DOUBLE, + CONSTRAINT DO19_PK PRIMARY KEY (IDENTIFIER) +); + +CREATE TABLE COLLECTION_OF_FLOAT20 +( + IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL, + FLOATVAL FLOAT, + CONSTRAINT FL20 PRIMARY KEY (IDENTIFIER) +); + +CREATE TABLE COLLECTION_OF_FLOAT21 +( + IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL, + FLOATVAL FLOAT, + CONSTRAINT FL21 PRIMARY KEY (IDENTIFIER) +); + +CREATE TABLE COLLECTION_OF_INTEGER22 +( + IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL, + INTEGERVAL INTEGER, + CONSTRAINT IN22 PRIMARY KEY (IDENTIFIER) +); + +CREATE TABLE COLLECTION_OF_INTEGER23 +( + IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL, + INTEGERVAL INTEGER, + CONSTRAINT IN23 PRIMARY KEY (IDENTIFIER) +); + +CREATE TABLE COLLECTION_OF_LONG24 +( + IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL, + LONGVAL BIGINT, + CONSTRAINT BI24_PK PRIMARY KEY (IDENTIFIER) +); + +CREATE TABLE COLLECTION_OF_LONG25 +( + IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL, + LONGVAL BIGINT, + CONSTRAINT BI25_PK PRIMARY KEY (IDENTIFIER) +); + +CREATE TABLE COLLECTION_OF_SHORT26 +( + IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL, + SHORTVAL SMALLINT, + CONSTRAINT SM26_PK PRIMARY KEY (IDENTIFIER) +); + +CREATE TABLE COLLECTION_OF_SHORT27 +( + IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL, + SHORTVAL SMALLINT, + CONSTRAINT SM27_PK PRIMARY KEY (IDENTIFIER) +); + +------------------------- +--inheritance +------------------------- + +DROP TABLE AllPersist; +DROP TABLE TopNonPersistB; +DROP TABLE TopPersist; +DROP TABLE FieldSameName; + +CREATE TABLE AllPersist ( + KEY_VALUE INTEGER NOT NULL, + DOUBLE_B DOUBLE, + INT_B INTEGER, + FLOAT_E FLOAT, + SHORT_F SMALLINT, + SECOND_OBJ INTEGER, + THIRD_OBJ INTEGER, + INT_H INTEGER, + DISCRIMINATOR varchar(64) NOT NULL, + CONSTRAINT AllPersist_PK PRIMARY KEY (KEY_VALUE), + FOREIGN KEY (SECOND_OBJ) REFERENCES AllPersist (KEY_VALUE), + FOREIGN KEY (THIRD_OBJ) REFERENCES AllPersist (KEY_VALUE) +); + +CREATE TABLE TopNonPersistB ( + KEY_VALUE INTEGER NOT NULL, + DOUBLE_B DOUBLE, + INT_B INTEGER, + FLOAT_E FLOAT, + SHORT_F SMALLINT, + SECOND_OBJ INTEGER, + THIRD_OBJ INTEGER, + INT_H INTEGER, + DISCRIMINATOR varchar(64) NOT NULL, + CONSTRAINT TopNonPersistB_PK PRIMARY KEY (KEY_VALUE), + FOREIGN KEY (SECOND_OBJ) REFERENCES TopNonPersistB (KEY_VALUE), + FOREIGN KEY (THIRD_OBJ) REFERENCES TopNonPersistB (KEY_VALUE) +); + +CREATE TABLE TopPersist ( + KEY_VALUE INTEGER NOT NULL, + DOUBLE_B DOUBLE, + INT_B INTEGER, + FLOAT_E FLOAT, + SHORT_F SMALLINT, + SECOND_OBJ INTEGER, + THIRD_OBJ INTEGER, + INT_H INTEGER, + DISCRIMINATOR varchar(64) NOT NULL, + CONSTRAINT TopPersist_PK PRIMARY KEY (KEY_VALUE), + FOREIGN KEY (SECOND_OBJ) REFERENCES TopPersist (KEY_VALUE), + FOREIGN KEY (THIRD_OBJ) REFERENCES TopPersist (KEY_VALUE) +); + +CREATE TABLE FieldSameName ( + KEY_VALUE INTEGER NOT NULL, + N2 DOUBLE, + N3 INTEGER, + FSN2_N3 FLOAT, + FSN3_N1 SMALLINT, + FSN3_N2 INTEGER, + FSN3_N3 INTEGER, + FSN4_N3 INTEGER, + DISCRIMINATOR varchar(64) NOT NULL, + CONSTRAINT FieldSameName_PK PRIMARY KEY (KEY_VALUE), + FOREIGN KEY (FSN3_N2) REFERENCES FieldSameName (KEY_VALUE), + FOREIGN KEY (FSN3_N3) REFERENCES FieldSameName (KEY_VALUE) ); -------------------------