db-jdo-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From mcai...@apache.org
Subject svn commit: r345614 [3/3] - in /incubator/jdo/trunk/tck20/test: orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/ orm/datastoreidentity/org/apache/jdo/tck/pc/fieldtypes/ sql/derby/applicationidentity/ sql/derby/datastoreidentity/
Date Sat, 19 Nov 2005 00:51:19 GMT
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=345614&r1=345613&r2=345614&view=diff
==============================================================================
--- incubator/jdo/trunk/tck20/test/sql/derby/datastoreidentity/schema.sql (original)
+++ incubator/jdo/trunk/tck20/test/sql/derby/datastoreidentity/schema.sql Fri Nov 18 16:51:06
2005
@@ -4528,14 +4528,12 @@
 CREATE TABLE SET_OF_OBJECT0
 (
     IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
-    ALLOW_DUPLICATES BIGINT NOT NULL,
     OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE SET_OF_OBJECT1
 (
     IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
-    ALLOW_DUPLICATES BIGINT NOT NULL,
     ID BIGINT NOT NULL,
     INTVAL INTEGER NOT NULL,
     STRINGVAL VARCHAR(128) NOT NULL
@@ -4544,21 +4542,18 @@
 CREATE TABLE SET_OF_OBJECT2
 (
     IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
-    ALLOW_DUPLICATES BIGINT NOT NULL,
 	COLLVAL LONG VARCHAR FOR BIT DATA
 );
 
 CREATE TABLE SET_OF_SIMPLE_CLASS3
 (
     IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
-    ALLOW_DUPLICATES BIGINT NOT NULL,
     SIMPCLSREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE SET_OF_SIMPLE_CLASS4
 (
     IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
-    ALLOW_DUPLICATES BIGINT NOT NULL,
     ID BIGINT NOT NULL,
     INTVAL INTEGER NOT NULL,
     STRINGVAL VARCHAR(128) NOT NULL
@@ -4567,21 +4562,18 @@
 CREATE TABLE SET_OF_SIMPLE_CLASS5
 (
     IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
-    ALLOW_DUPLICATES BIGINT NOT NULL,
 	COLLVAL LONG VARCHAR FOR BIT DATA
 );
 
 CREATE TABLE SET_OF_SIMPLE_INTERFACE6
 (
     IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
-    ALLOW_DUPLICATES BIGINT NOT NULL,
     SIMPINTREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE SET_OF_SIMPLE_INTERFACE7
 (
     IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
-    ALLOW_DUPLICATES BIGINT NOT NULL,
     ID BIGINT NOT NULL,
     INTVAL INTEGER NOT NULL,
     STRINGVAL VARCHAR(128) NOT NULL
@@ -4590,161 +4582,138 @@
 CREATE TABLE SET_OF_SIMPLE_INTERFACE8
 (
     IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
-    ALLOW_DUPLICATES BIGINT NOT NULL,
 	COLLVAL LONG VARCHAR FOR BIT DATA
 );
 
 CREATE TABLE SET_OF_STRING9
 (
     IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
-    ALLOW_DUPLICATES BIGINT NOT NULL,
     STRINGVAL VARCHAR(1024)
 );
 
 CREATE TABLE SET_OF_STRING10
 (
     IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
-    ALLOW_DUPLICATES BIGINT NOT NULL,
     STRINGVAL VARCHAR(1024)
 );
 
 CREATE TABLE SET_OF_DATE12
 (
     IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
-    ALLOW_DUPLICATES BIGINT NOT NULL,
     DATEVAL TIMESTAMP
 );
 
 CREATE TABLE SET_OF_DATE13
 (
     IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
-    ALLOW_DUPLICATES BIGINT NOT NULL,
     DATEVAL TIMESTAMP
 );
 
 CREATE TABLE SET_OF_LOCALE15
 (
     IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
-    ALLOW_DUPLICATES BIGINT NOT NULL,
     LOCALEVAL CHAR(20)
 );
 
 CREATE TABLE SET_OF_LOCALE16
 (
     IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
-    ALLOW_DUPLICATES BIGINT NOT NULL,
     LOCALEVAL CHAR(20)
 );
 
 CREATE TABLE SET_OF_BIG_DECIMAL18
 (
     IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
-    ALLOW_DUPLICATES BIGINT NOT NULL,
     BIG_DECIMALVAL DECIMAL(27,16)
 );
 
 CREATE TABLE SET_OF_BIG_DECIMAL19
 (
     IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
-    ALLOW_DUPLICATES BIGINT NOT NULL,
     BIG_DECIMALVAL DECIMAL(27,16)
 );
 
 CREATE TABLE SET_OF_BIG_INTEGER21
 (
     IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
-    ALLOW_DUPLICATES BIGINT NOT NULL,
     BIG_INTEGERVAL BIGINT
 );
 
 CREATE TABLE SET_OF_BIG_INTEGER22
 (
     IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
-    ALLOW_DUPLICATES BIGINT NOT NULL,
     BIG_INTEGERVAL BIGINT
 );
 
 CREATE TABLE SET_OF_BYTE24
 (
     IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
-    ALLOW_DUPLICATES BIGINT NOT NULL,
     BYTEVAL SMALLINT
 );
 
 CREATE TABLE SET_OF_BYTE25
 (
     IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
-    ALLOW_DUPLICATES BIGINT NOT NULL,
     BYTEVAL SMALLINT
 );
 
 CREATE TABLE SET_OF_DOUBLE27
 (
     IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
-    ALLOW_DUPLICATES BIGINT NOT NULL,
     DOUBLEVAL DOUBLE
 );
 
 CREATE TABLE SET_OF_DOUBLE28
 (
     IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
-    ALLOW_DUPLICATES BIGINT NOT NULL,
     DOUBLEVAL DOUBLE
 );
 
 CREATE TABLE SET_OF_FLOAT30
 (
     IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
-    ALLOW_DUPLICATES BIGINT NOT NULL,
     FLOATVAL FLOAT
 );
 
 CREATE TABLE SET_OF_FLOAT31
 (
     IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
-    ALLOW_DUPLICATES BIGINT NOT NULL,
     FLOATVAL FLOAT
 );
 
 CREATE TABLE SET_OF_INTEGER33
 (
     IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
-    ALLOW_DUPLICATES BIGINT NOT NULL,
     INTEGERVAL INTEGER
 );
 
 CREATE TABLE SET_OF_INTEGER34
 (
     IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
-    ALLOW_DUPLICATES BIGINT NOT NULL,
     INTEGERVAL INTEGER
 );
 
 CREATE TABLE SET_OF_LONG36
 (
     IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
-    ALLOW_DUPLICATES BIGINT NOT NULL,
     LONGVAL BIGINT
 );
 
 CREATE TABLE SET_OF_LONG37
 (
     IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
-    ALLOW_DUPLICATES BIGINT NOT NULL,
     LONGVAL BIGINT
 );
 
 CREATE TABLE SET_OF_SHORT39
 (
     IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
-    ALLOW_DUPLICATES BIGINT NOT NULL,
     SHORTVAL SMALLINT
 );
 
 CREATE TABLE SET_OF_SHORT40
 (
     IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
-    ALLOW_DUPLICATES BIGINT NOT NULL,
     SHORTVAL SMALLINT
 );
 
@@ -4772,14 +4741,12 @@
 CREATE TABLE HASHSET_OF_OBJECT0
 (
     IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
-    ALLOW_DUPLICATES BIGINT NOT NULL,
     OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE HASHSET_OF_OBJECT1
 (
     IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
-    ALLOW_DUPLICATES BIGINT NOT NULL,
     ID BIGINT NOT NULL,
     INTVAL INTEGER NOT NULL,
     STRINGVAL VARCHAR(128) NOT NULL
@@ -4788,21 +4755,18 @@
 CREATE TABLE HASHSET_OF_OBJECT2
 (
     IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
-    ALLOW_DUPLICATES BIGINT NOT NULL,
 	COLLVAL LONG VARCHAR FOR BIT DATA
 );
 
 CREATE TABLE HASHSET_OF_SIMPLE_CLASS3
 (
     IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
-    ALLOW_DUPLICATES BIGINT NOT NULL,
     SIMPCLSREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE HASHSET_OF_SIMPLE_CLASS4
 (
     IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
-    ALLOW_DUPLICATES BIGINT NOT NULL,
     ID BIGINT NOT NULL,
     INTVAL INTEGER NOT NULL,
     STRINGVAL VARCHAR(128) NOT NULL
@@ -4811,21 +4775,18 @@
 CREATE TABLE HASHSET_OF_SIMPLE_CLASS5
 (
     IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
-    ALLOW_DUPLICATES BIGINT NOT NULL,
 	COLLVAL LONG VARCHAR FOR BIT DATA
 );
 
 CREATE TABLE HASHSET_OF_SIMPLE_INTERFACE6
 (
     IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
-    ALLOW_DUPLICATES BIGINT NOT NULL,
     SIMPINTREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE HASHSET_OF_SIMPLE_INTERFACE7
 (
     IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
-    ALLOW_DUPLICATES BIGINT NOT NULL,
     ID BIGINT NOT NULL,
     INTVAL INTEGER NOT NULL,
     STRINGVAL VARCHAR(128) NOT NULL
@@ -4834,161 +4795,138 @@
 CREATE TABLE HASHSET_OF_SIMPLE_INTERFACE8
 (
     IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
-    ALLOW_DUPLICATES BIGINT NOT NULL,
 	COLLVAL LONG VARCHAR FOR BIT DATA
 );
 
 CREATE TABLE HASHSET_OF_STRING9
 (
     IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
-    ALLOW_DUPLICATES BIGINT NOT NULL,
     STRINGVAL VARCHAR(1024)
 );
 
 CREATE TABLE HASHSET_OF_STRING10
 (
     IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
-    ALLOW_DUPLICATES BIGINT NOT NULL,
     STRINGVAL VARCHAR(1024)
 );
 
 CREATE TABLE HASHSET_OF_DATE12
 (
     IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
-    ALLOW_DUPLICATES BIGINT NOT NULL,
     DATEVAL TIMESTAMP
 );
 
 CREATE TABLE HASHSET_OF_DATE13
 (
     IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
-    ALLOW_DUPLICATES BIGINT NOT NULL,
     DATEVAL TIMESTAMP
 );
 
 CREATE TABLE HASHSET_OF_LOCALE15
 (
     IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
-    ALLOW_DUPLICATES BIGINT NOT NULL,
     LOCALEVAL CHAR(20)
 );
 
 CREATE TABLE HASHSET_OF_LOCALE16
 (
     IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
-    ALLOW_DUPLICATES BIGINT NOT NULL,
     LOCALEVAL CHAR(20)
 );
 
 CREATE TABLE HASHSET_OF_BIG_DECIMAL18
 (
     IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
-    ALLOW_DUPLICATES BIGINT NOT NULL,
     BIG_DECIMALVAL DECIMAL(27,16)
 );
 
 CREATE TABLE HASHSET_OF_BIG_DECIMAL19
 (
     IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
-    ALLOW_DUPLICATES BIGINT NOT NULL,
     BIG_DECIMALVAL DECIMAL(27,16)
 );
 
 CREATE TABLE HASHSET_OF_BIG_INTEGER21
 (
     IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
-    ALLOW_DUPLICATES BIGINT NOT NULL,
     BIG_INTEGERVAL BIGINT
 );
 
 CREATE TABLE HASHSET_OF_BIG_INTEGER22
 (
     IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
-    ALLOW_DUPLICATES BIGINT NOT NULL,
     BIG_INTEGERVAL BIGINT
 );
 
 CREATE TABLE HASHSET_OF_BYTE24
 (
     IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
-    ALLOW_DUPLICATES BIGINT NOT NULL,
     BYTEVAL SMALLINT
 );
 
 CREATE TABLE HASHSET_OF_BYTE25
 (
     IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
-    ALLOW_DUPLICATES BIGINT NOT NULL,
     BYTEVAL SMALLINT
 );
 
 CREATE TABLE HASHSET_OF_DOUBLE27
 (
     IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
-    ALLOW_DUPLICATES BIGINT NOT NULL,
     DOUBLEVAL DOUBLE
 );
 
 CREATE TABLE HASHSET_OF_DOUBLE28
 (
     IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
-    ALLOW_DUPLICATES BIGINT NOT NULL,
     DOUBLEVAL DOUBLE
 );
 
 CREATE TABLE HASHSET_OF_FLOAT30
 (
     IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
-    ALLOW_DUPLICATES BIGINT NOT NULL,
     FLOATVAL FLOAT
 );
 
 CREATE TABLE HASHSET_OF_FLOAT31
 (
     IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
-    ALLOW_DUPLICATES BIGINT NOT NULL,
     FLOATVAL FLOAT
 );
 
 CREATE TABLE HASHSET_OF_INTEGER33
 (
     IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
-    ALLOW_DUPLICATES BIGINT NOT NULL,
     INTEGERVAL INTEGER
 );
 
 CREATE TABLE HASHSET_OF_INTEGER34
 (
     IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
-    ALLOW_DUPLICATES BIGINT NOT NULL,
     INTEGERVAL INTEGER
 );
 
 CREATE TABLE HASHSET_OF_LONG36
 (
     IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
-    ALLOW_DUPLICATES BIGINT NOT NULL,
     LONGVAL BIGINT
 );
 
 CREATE TABLE HASHSET_OF_LONG37
 (
     IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
-    ALLOW_DUPLICATES BIGINT NOT NULL,
     LONGVAL BIGINT
 );
 
 CREATE TABLE HASHSET_OF_SHORT39
 (
     IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
-    ALLOW_DUPLICATES BIGINT NOT NULL,
     SHORTVAL SMALLINT
 );
 
 CREATE TABLE HASHSET_OF_SHORT40
 (
     IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
-    ALLOW_DUPLICATES BIGINT NOT NULL,
     SHORTVAL SMALLINT
 );
 



Mime
View raw message