Diff of /incubator/jdo/trunk/tck20/test/sql/derby/schema1.sql

Parent Directory | Revision Log | Patch

--- incubator/jdo/trunk/tck20/test/sql/derby/schema1.sql	2005/05/03 22:04:46	168003
+++ incubator/jdo/trunk/tck20/test/sql/derby/schema1.sql	2005/05/03 22:10:13	168004
@@ -179,6 +179,36 @@ DROP TABLE FIELDSOFPRIMITIVELONG;
 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 @@ CREATE TABLE FieldsOfByte (
     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,
@@ -2213,6 +2174,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)
+);
+
 -------------------------
 --instancecallbacks
 -------------------------