db-jdo-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From mcai...@apache.org
Subject svn commit: r312732 [4/5] - in /incubator/jdo/trunk/tck20/test: java/org/apache/jdo/tck/models/fieldtypes/ java/org/apache/jdo/tck/pc/fieldtypes/ jdo/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/ jdo/datastoreidentity/org/apache/jdo/tck/pc/fiel...
Date Mon, 10 Oct 2005 20:35:15 GMT
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=312732&r1=312731&r2=312732&view=diff
==============================================================================
--- incubator/jdo/trunk/tck20/test/sql/derby/applicationidentity/schema.sql (original)
+++ incubator/jdo/trunk/tck20/test/sql/derby/applicationidentity/schema.sql Mon Oct 10 13:35:04
2005
@@ -2808,7 +2808,7 @@
 CREATE TABLE ARRAY_OF_BIG_DECIMAL13
 (
     IDENTIFIER INTEGER REFERENCES ARRAY_COLLECTIONS NOT NULL,
-    BIG_DECIMALVAL DECIMAL(17,6)
+    BIG_DECIMALVAL DECIMAL(27,16)
 );
 
 CREATE TABLE ARRAY_OF_BIG_INTEGER15
@@ -2988,14 +2988,14 @@
 (
     IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL,
     ALLOW_DUPLICATES BIGINT NOT NULL,
-    BIG_DECIMALVAL DECIMAL(17,6)
+    BIG_DECIMALVAL DECIMAL(27,16)
 );
 
 CREATE TABLE COLLECTION_OF_BIG_DECIMAL19
 (
     IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL,
     ALLOW_DUPLICATES BIGINT NOT NULL,
-    BIG_DECIMALVAL DECIMAL(17,6)
+    BIG_DECIMALVAL DECIMAL(27,16)
 );
 
 CREATE TABLE COLLECTION_OF_BIG_INTEGER21
@@ -3101,235 +3101,242 @@
 CREATE TABLE LIST_COLLECTIONS
 (
     IDENTIFIER INTEGER NOT NULL,
-	LIST_OF_STRING10 LONG VARCHAR FOR BIT DATA,
-	LIST_OF_DATE13 LONG VARCHAR FOR BIT DATA,
-	LIST_OF_LOCALE16 LONG VARCHAR FOR BIT DATA,
-	LIST_OF_BIG_DECIMAL19 LONG VARCHAR FOR BIT DATA,
-	LIST_OF_BIG_INTEGER22 LONG VARCHAR FOR BIT DATA,
-	LIST_OF_BYTE25 LONG VARCHAR FOR BIT DATA,
-	LIST_OF_DOUBLE28 LONG VARCHAR FOR BIT DATA,
-	LIST_OF_FLOAT31 LONG VARCHAR FOR BIT DATA,
-	LIST_OF_INTEGER34 LONG VARCHAR FOR BIT DATA,
-	LIST_OF_LONG37 LONG VARCHAR FOR BIT DATA,
-	LIST_OF_SHORT40 LONG VARCHAR FOR BIT DATA,
+    LIST_OF_STRING11 LONG VARCHAR FOR BIT DATA,
+    LIST_OF_DATE14 LONG VARCHAR FOR BIT DATA,
+    LIST_OF_LOCALE17 LONG VARCHAR FOR BIT DATA,
+    LIST_OF_BIG_DECIMAL20 LONG VARCHAR FOR BIT DATA,
+    LIST_OF_BIG_INTEGER23 LONG VARCHAR FOR BIT DATA,
+    LIST_OF_BYTE26 LONG VARCHAR FOR BIT DATA,
+    LIST_OF_DOUBLE29 LONG VARCHAR FOR BIT DATA,
+    LIST_OF_FLOAT32 LONG VARCHAR FOR BIT DATA,
+    LIST_OF_INTEGER35 LONG VARCHAR FOR BIT DATA,
+    LIST_OF_LONG38 LONG VARCHAR FOR BIT DATA,
+    LIST_OF_SHORT41 LONG VARCHAR FOR BIT DATA,
+    LIST_OF_SIMPLE_CLASS42 LONG VARCHAR FOR BIT DATA,
     CONSTRAINT LC_PK PRIMARY KEY (IDENTIFIER)
 );
 
 CREATE TABLE LIST_OF_OBJECT0
 (
     IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
-    OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+    OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE LIST_OF_OBJECT1
 (
     IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
-    OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+    ID BIGINT NOT NULL,
+    INTVAL INTEGER NOT NULL,
+    STRINGVAL VARCHAR(128) NOT NULL
 );
 
 CREATE TABLE LIST_OF_OBJECT2
 (
     IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
-    OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+	COLLVAL LONG VARCHAR FOR BIT DATA
 );
 
 CREATE TABLE LIST_OF_SIMPLE_CLASS3
 (
     IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
-    SIMPCLSREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+    SIMPCLSREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE LIST_OF_SIMPLE_CLASS4
 (
     IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
-    SIMPCLSREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+    ID BIGINT NOT NULL,
+    INTVAL INTEGER NOT NULL,
+    STRINGVAL VARCHAR(128) NOT NULL
 );
 
 CREATE TABLE LIST_OF_SIMPLE_CLASS5
 (
     IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
-    SIMPCLSREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+	COLLVAL LONG VARCHAR FOR BIT DATA
 );
 
 CREATE TABLE LIST_OF_SIMPLE_INTERFACE6
 (
     IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
-    SIMPINTREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+    SIMPINTREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE LIST_OF_SIMPLE_INTERFACE7
 (
     IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
-    SIMPINTREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+    ID BIGINT NOT NULL,
+    INTVAL INTEGER NOT NULL,
+    STRINGVAL VARCHAR(128) NOT NULL
 );
 
 CREATE TABLE LIST_OF_SIMPLE_INTERFACE8
 (
     IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
-    SIMPINTREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+	COLLVAL LONG VARCHAR FOR BIT DATA
 );
 
 CREATE TABLE LIST_OF_STRING9
 (
     IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
-    STRINGVAL VARCHAR(1024),
-    INDEX INTEGER NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+    STRINGVAL VARCHAR(1024)
 );
 
-CREATE TABLE LIST_OF_STRING11
+CREATE TABLE LIST_OF_STRING10
 (
     IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
-    STRINGVAL VARCHAR(1024),
-    INDEX INTEGER NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+    STRINGVAL VARCHAR(1024)
 );
 
 CREATE TABLE LIST_OF_DATE12
 (
     IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
-    DATEVAL TIMESTAMP,
-    INDEX INTEGER NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+    DATEVAL TIMESTAMP
 );
 
-CREATE TABLE LIST_OF_DATE14
+CREATE TABLE LIST_OF_DATE13
 (
     IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
-    DATEVAL TIMESTAMP,
-    INDEX INTEGER NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+    DATEVAL TIMESTAMP
 );
 
 CREATE TABLE LIST_OF_LOCALE15
 (
     IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
-    LOCALEVAL CHAR(20),
-    INDEX INTEGER NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+    LOCALEVAL CHAR(20)
 );
 
-CREATE TABLE LIST_OF_LOCALE17
+CREATE TABLE LIST_OF_LOCALE16
 (
     IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
-    LOCALEVAL CHAR(20),
-    INDEX INTEGER NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+    LOCALEVAL CHAR(20)
 );
 
 CREATE TABLE LIST_OF_BIG_DECIMAL18
 (
     IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
-    BIG_DECIMALVAL DECIMAL(17,6),
-    INDEX INTEGER NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+    BIG_DECIMALVAL DECIMAL(27,16)
 );
 
-CREATE TABLE LIST_OF_BIG_DECIMAL20
+CREATE TABLE LIST_OF_BIG_DECIMAL19
 (
     IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
-    BIG_DECIMALVAL DECIMAL(17,6),
-    INDEX INTEGER NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+    BIG_DECIMALVAL DECIMAL(27,16)
 );
 
 CREATE TABLE LIST_OF_BIG_INTEGER21
 (
     IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
-    BIG_INTEGERVAL BIGINT,
-    INDEX INTEGER NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+    BIG_INTEGERVAL BIGINT
 );
 
-CREATE TABLE LIST_OF_BIG_INTEGER23
+CREATE TABLE LIST_OF_BIG_INTEGER22
 (
     IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
-    BIG_INTEGERVAL BIGINT,
-    INDEX INTEGER NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+    BIG_INTEGERVAL BIGINT
 );
 
 CREATE TABLE LIST_OF_BYTE24
 (
     IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
-    BYTEVAL SMALLINT,
-    INDEX INTEGER NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+    BYTEVAL SMALLINT
 );
 
-CREATE TABLE LIST_OF_BYTE26
+CREATE TABLE LIST_OF_BYTE25
 (
     IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
-    BYTEVAL SMALLINT,
-    INDEX INTEGER NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+    BYTEVAL SMALLINT
 );
 
 CREATE TABLE LIST_OF_DOUBLE27
 (
     IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
-    DOUBLEVAL DOUBLE,
-    INDEX INTEGER NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+    DOUBLEVAL DOUBLE
 );
 
-CREATE TABLE LIST_OF_DOUBLE29
+CREATE TABLE LIST_OF_DOUBLE28
 (
     IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
-    DOUBLEVAL DOUBLE,
-    INDEX INTEGER NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+    DOUBLEVAL DOUBLE
 );
 
 CREATE TABLE LIST_OF_FLOAT30
 (
     IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
-    FLOATVAL FLOAT,
-    INDEX INTEGER NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+    FLOATVAL FLOAT
 );
 
-CREATE TABLE LIST_OF_FLOAT32
+CREATE TABLE LIST_OF_FLOAT31
 (
     IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
-    FLOATVAL FLOAT,
-    INDEX INTEGER NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+    FLOATVAL FLOAT
 );
 
 CREATE TABLE LIST_OF_INTEGER33
 (
     IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
-    INTEGERVAL INTEGER,
-    INDEX INTEGER NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+    INTEGERVAL INTEGER
 );
 
-CREATE TABLE LIST_OF_INTEGER35
+CREATE TABLE LIST_OF_INTEGER34
 (
     IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
-    INTEGERVAL INTEGER,
-    INDEX INTEGER NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+    INTEGERVAL INTEGER
 );
 
 CREATE TABLE LIST_OF_LONG36
 (
     IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
-    LONGVAL BIGINT,
-    INDEX INTEGER NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+    LONGVAL BIGINT
 );
 
-CREATE TABLE LIST_OF_LONG38
+CREATE TABLE LIST_OF_LONG37
 (
     IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
-    LONGVAL BIGINT,
-    INDEX INTEGER NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+    LONGVAL BIGINT
 );
 
 CREATE TABLE LIST_OF_SHORT39
 (
     IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
-    SHORTVAL SMALLINT,
-    INDEX INTEGER NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+    SHORTVAL SMALLINT
 );
 
-CREATE TABLE LIST_OF_SHORT41
+CREATE TABLE LIST_OF_SHORT40
 (
     IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
-    SHORTVAL SMALLINT,
-    INDEX INTEGER NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+    SHORTVAL SMALLINT
 );
 
 --ArrayListCollections
@@ -3459,14 +3466,14 @@
 CREATE TABLE ARRAYLIST_OF_BIG_DECIMAL18
 (
     IDENTIFIER INTEGER REFERENCES ARRAYLIST_COLLECTIONS NOT NULL,
-    BIG_DECIMALVAL DECIMAL(17,6),
+    BIG_DECIMALVAL DECIMAL(27,16),
     INDEX INTEGER NOT NULL
 );
 
 CREATE TABLE ARRAYLIST_OF_BIG_DECIMAL20
 (
     IDENTIFIER INTEGER REFERENCES ARRAYLIST_COLLECTIONS NOT NULL,
-    BIG_DECIMALVAL DECIMAL(17,6),
+    BIG_DECIMALVAL DECIMAL(27,16),
     INDEX INTEGER NOT NULL
 );
 
@@ -3573,235 +3580,242 @@
 CREATE TABLE LINKEDLIST_COLLECTIONS
 (
     IDENTIFIER INTEGER NOT NULL,
-	LINKEDLIST_OF_STRING10 LONG VARCHAR FOR BIT DATA,
-	LINKEDLIST_OF_DATE13 LONG VARCHAR FOR BIT DATA,
-	LINKEDLIST_OF_LOCALE16 LONG VARCHAR FOR BIT DATA,
-	LINKEDLIST_OF_BIG_DECIMAL19 LONG VARCHAR FOR BIT DATA,
-	LINKEDLIST_OF_BIG_INTEGER22 LONG VARCHAR FOR BIT DATA,
-	LINKEDLIST_OF_BYTE25 LONG VARCHAR FOR BIT DATA,
-	LINKEDLIST_OF_DOUBLE28 LONG VARCHAR FOR BIT DATA,
-	LINKEDLIST_OF_FLOAT31 LONG VARCHAR FOR BIT DATA,
-	LINKEDLIST_OF_INTEGER34 LONG VARCHAR FOR BIT DATA,
-	LINKEDLIST_OF_LONG37 LONG VARCHAR FOR BIT DATA,
-	LINKEDLIST_OF_SHORT40 LONG VARCHAR FOR BIT DATA,
+    LINKEDLIST_OF_STRING11 LONG VARCHAR FOR BIT DATA,
+    LINKEDLIST_OF_DATE14 LONG VARCHAR FOR BIT DATA,
+    LINKEDLIST_OF_LOCALE17 LONG VARCHAR FOR BIT DATA,
+    LINKEDLIST_OF_BIG_DECIMAL20 LONG VARCHAR FOR BIT DATA,
+    LINKEDLIST_OF_BIG_INTEGER23 LONG VARCHAR FOR BIT DATA,
+    LINKEDLIST_OF_BYTE26 LONG VARCHAR FOR BIT DATA,
+    LINKEDLIST_OF_DOUBLE29 LONG VARCHAR FOR BIT DATA,
+    LINKEDLIST_OF_FLOAT32 LONG VARCHAR FOR BIT DATA,
+    LINKEDLIST_OF_INTEGER35 LONG VARCHAR FOR BIT DATA,
+    LINKEDLIST_OF_LONG38 LONG VARCHAR FOR BIT DATA,
+    LINKEDLIST_OF_SHORT41 LONG VARCHAR FOR BIT DATA,
+    LINKEDLIST_OF_SIMPLE_CLASS42 LONG VARCHAR FOR BIT DATA,
     CONSTRAINT LLC_PK PRIMARY KEY (IDENTIFIER)
 );
 
 CREATE TABLE LINKEDLIST_OF_OBJECT0
 (
     IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
-    OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+    OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE LINKEDLIST_OF_OBJECT1
 (
     IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
-    OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+    ID BIGINT NOT NULL,
+    INTVAL INTEGER NOT NULL,
+    STRINGVAL VARCHAR(128) NOT NULL
 );
 
 CREATE TABLE LINKEDLIST_OF_OBJECT2
 (
     IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
-    OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+	COLLVAL LONG VARCHAR FOR BIT DATA
 );
 
 CREATE TABLE LINKEDLIST_OF_SIMPLE_CLASS3
 (
     IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
-    SIMPCLSREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+    SIMPCLSREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE LINKEDLIST_OF_SIMPLE_CLASS4
 (
     IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
-    SIMPCLSREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+    ID BIGINT NOT NULL,
+    INTVAL INTEGER NOT NULL,
+    STRINGVAL VARCHAR(128) NOT NULL
 );
 
 CREATE TABLE LINKEDLIST_OF_SIMPLE_CLASS5
 (
     IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
-    SIMPCLSREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+	COLLVAL LONG VARCHAR FOR BIT DATA
 );
 
 CREATE TABLE LINKEDLIST_OF_SIMPLE_INTERFACE6
 (
     IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
-    SIMPINTREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+    SIMPINTREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE LINKEDLIST_OF_SIMPLE_INTERFACE7
 (
     IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
-    SIMPINTREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+    ID BIGINT NOT NULL,
+    INTVAL INTEGER NOT NULL,
+    STRINGVAL VARCHAR(128) NOT NULL
 );
 
 CREATE TABLE LINKEDLIST_OF_SIMPLE_INTERFACE8
 (
     IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
-    SIMPINTREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+	COLLVAL LONG VARCHAR FOR BIT DATA
 );
 
 CREATE TABLE LINKEDLIST_OF_STRING9
 (
     IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
-    STRINGVAL VARCHAR(1024),
-    INDEX INTEGER NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+    STRINGVAL VARCHAR(1024)
 );
 
-CREATE TABLE LINKEDLIST_OF_STRING11
+CREATE TABLE LINKEDLIST_OF_STRING10
 (
     IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
-    STRINGVAL VARCHAR(1024),
-    INDEX INTEGER NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+    STRINGVAL VARCHAR(1024)
 );
 
 CREATE TABLE LINKEDLIST_OF_DATE12
 (
     IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
-    DATEVAL TIMESTAMP,
-    INDEX INTEGER NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+    DATEVAL TIMESTAMP
 );
 
-CREATE TABLE LINKEDLIST_OF_DATE14
+CREATE TABLE LINKEDLIST_OF_DATE13
 (
     IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
-    DATEVAL TIMESTAMP,
-    INDEX INTEGER NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+    DATEVAL TIMESTAMP
 );
 
 CREATE TABLE LINKEDLIST_OF_LOCALE15
 (
     IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
-    LOCALEVAL CHAR(20),
-    INDEX INTEGER NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+    LOCALEVAL CHAR(20)
 );
 
-CREATE TABLE LINKEDLIST_OF_LOCALE17
+CREATE TABLE LINKEDLIST_OF_LOCALE16
 (
     IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
-    LOCALEVAL CHAR(20),
-    INDEX INTEGER NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+    LOCALEVAL CHAR(20)
 );
 
 CREATE TABLE LINKEDLIST_OF_BIG_DECIMAL18
 (
     IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
-    BIG_DECIMALVAL DECIMAL(17,6),
-    INDEX INTEGER NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+    BIG_DECIMALVAL DECIMAL(27,16)
 );
 
-CREATE TABLE LINKEDLIST_OF_BIG_DECIMAL20
+CREATE TABLE LINKEDLIST_OF_BIG_DECIMAL19
 (
     IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
-    BIG_DECIMALVAL DECIMAL(17,6),
-    INDEX INTEGER NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+    BIG_DECIMALVAL DECIMAL(27,16)
 );
 
 CREATE TABLE LINKEDLIST_OF_BIG_INTEGER21
 (
     IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
-    BIG_INTEGERVAL BIGINT,
-    INDEX INTEGER NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+    BIG_INTEGERVAL BIGINT
 );
 
-CREATE TABLE LINKEDLIST_OF_BIG_INTEGER23
+CREATE TABLE LINKEDLIST_OF_BIG_INTEGER22
 (
     IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
-    BIG_INTEGERVAL BIGINT,
-    INDEX INTEGER NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+    BIG_INTEGERVAL BIGINT
 );
 
 CREATE TABLE LINKEDLIST_OF_BYTE24
 (
     IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
-    BYTEVAL SMALLINT,
-    INDEX INTEGER NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+    BYTEVAL SMALLINT
 );
 
-CREATE TABLE LINKEDLIST_OF_BYTE26
+CREATE TABLE LINKEDLIST_OF_BYTE25
 (
     IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
-    BYTEVAL SMALLINT,
-    INDEX INTEGER NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+    BYTEVAL SMALLINT
 );
 
 CREATE TABLE LINKEDLIST_OF_DOUBLE27
 (
     IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
-    DOUBLEVAL DOUBLE,
-    INDEX INTEGER NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+    DOUBLEVAL DOUBLE
 );
 
-CREATE TABLE LINKEDLIST_OF_DOUBLE29
+CREATE TABLE LINKEDLIST_OF_DOUBLE28
 (
     IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
-    DOUBLEVAL DOUBLE,
-    INDEX INTEGER NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+    DOUBLEVAL DOUBLE
 );
 
 CREATE TABLE LINKEDLIST_OF_FLOAT30
 (
     IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
-    FLOATVAL FLOAT,
-    INDEX INTEGER NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+    FLOATVAL FLOAT
 );
 
-CREATE TABLE LINKEDLIST_OF_FLOAT32
+CREATE TABLE LINKEDLIST_OF_FLOAT31
 (
     IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
-    FLOATVAL FLOAT,
-    INDEX INTEGER NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+    FLOATVAL FLOAT
 );
 
 CREATE TABLE LINKEDLIST_OF_INTEGER33
 (
     IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
-    INTEGERVAL INTEGER,
-    INDEX INTEGER NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+    INTEGERVAL INTEGER
 );
 
-CREATE TABLE LINKEDLIST_OF_INTEGER35
+CREATE TABLE LINKEDLIST_OF_INTEGER34
 (
     IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
-    INTEGERVAL INTEGER,
-    INDEX INTEGER NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+    INTEGERVAL INTEGER
 );
 
 CREATE TABLE LINKEDLIST_OF_LONG36
 (
     IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
-    LONGVAL BIGINT,
-    INDEX INTEGER NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+    LONGVAL BIGINT
 );
 
-CREATE TABLE LINKEDLIST_OF_LONG38
+CREATE TABLE LINKEDLIST_OF_LONG37
 (
     IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
-    LONGVAL BIGINT,
-    INDEX INTEGER NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+    LONGVAL BIGINT
 );
 
 CREATE TABLE LINKEDLIST_OF_SHORT39
 (
     IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
-    SHORTVAL SMALLINT,
-    INDEX INTEGER NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+    SHORTVAL SMALLINT
 );
 
-CREATE TABLE LINKEDLIST_OF_SHORT41
+CREATE TABLE LINKEDLIST_OF_SHORT40
 (
     IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
-    SHORTVAL SMALLINT,
-    INDEX INTEGER NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+    SHORTVAL SMALLINT
 );
 
 --VectorCollections
@@ -3809,235 +3823,242 @@
 CREATE TABLE VECTOR_COLLECTIONS
 (
     IDENTIFIER INTEGER NOT NULL,
-	VECTOR_OF_STRING10 LONG VARCHAR FOR BIT DATA,
-	VECTOR_OF_DATE13 LONG VARCHAR FOR BIT DATA,
-	VECTOR_OF_LOCALE16 LONG VARCHAR FOR BIT DATA,
-	VECTOR_OF_BIG_DECIMAL19 LONG VARCHAR FOR BIT DATA,
-	VECTOR_OF_BIG_INTEGER22 LONG VARCHAR FOR BIT DATA,
-	VECTOR_OF_BYTE25 LONG VARCHAR FOR BIT DATA,
-	VECTOR_OF_DOUBLE28 LONG VARCHAR FOR BIT DATA,
-	VECTOR_OF_FLOAT31 LONG VARCHAR FOR BIT DATA,
-	VECTOR_OF_INTEGER34 LONG VARCHAR FOR BIT DATA,
-	VECTOR_OF_LONG37 LONG VARCHAR FOR BIT DATA,
-	VECTOR_OF_SHORT40 LONG VARCHAR FOR BIT DATA,
+	VECTOR_OF_STRING11 LONG VARCHAR FOR BIT DATA,
+	VECTOR_OF_DATE14 LONG VARCHAR FOR BIT DATA,
+	VECTOR_OF_LOCALE17 LONG VARCHAR FOR BIT DATA,
+	VECTOR_OF_BIG_DECIMAL20 LONG VARCHAR FOR BIT DATA,
+	VECTOR_OF_BIG_INTEGER23 LONG VARCHAR FOR BIT DATA,
+	VECTOR_OF_BYTE26 LONG VARCHAR FOR BIT DATA,
+	VECTOR_OF_DOUBLE29 LONG VARCHAR FOR BIT DATA,
+	VECTOR_OF_FLOAT32 LONG VARCHAR FOR BIT DATA,
+	VECTOR_OF_INTEGER35 LONG VARCHAR FOR BIT DATA,
+	VECTOR_OF_LONG38 LONG VARCHAR FOR BIT DATA,
+	VECTOR_OF_SHORT41 LONG VARCHAR FOR BIT DATA,
+    VECTOR_OF_SIMPLE_CLASS42 LONG VARCHAR FOR BIT DATA,
     CONSTRAINT VC_PK PRIMARY KEY (IDENTIFIER)
 );
 
 CREATE TABLE VECTOR_OF_OBJECT0
 (
     IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
-    OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+    OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE VECTOR_OF_OBJECT1
 (
     IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
-    OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+    ID BIGINT NOT NULL,
+    INTVAL INTEGER NOT NULL,
+    STRINGVAL VARCHAR(128) NOT NULL
 );
 
 CREATE TABLE VECTOR_OF_OBJECT2
 (
     IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
-    OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+	COLLVAL LONG VARCHAR FOR BIT DATA
 );
 
 CREATE TABLE VECTOR_OF_SIMPLE_CLASS3
 (
     IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
-    SIMPCLSREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+    SIMPCLSREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE VECTOR_OF_SIMPLE_CLASS4
 (
     IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
-    SIMPCLSREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+    ID BIGINT NOT NULL,
+    INTVAL INTEGER NOT NULL,
+    STRINGVAL VARCHAR(128) NOT NULL
 );
 
 CREATE TABLE VECTOR_OF_SIMPLE_CLASS5
 (
     IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
-    SIMPCLSREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+	COLLVAL LONG VARCHAR FOR BIT DATA
 );
 
 CREATE TABLE VECTOR_OF_SIMPLE_INTERFACE6
 (
     IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
-    SIMPINTREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+    SIMPINTREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE VECTOR_OF_SIMPLE_INTERFACE7
 (
     IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
-    SIMPINTREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+    ID BIGINT NOT NULL,
+    INTVAL INTEGER NOT NULL,
+    STRINGVAL VARCHAR(128) NOT NULL
 );
 
 CREATE TABLE VECTOR_OF_SIMPLE_INTERFACE8
 (
     IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
-    SIMPINTREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+	COLLVAL LONG VARCHAR FOR BIT DATA
 );
 
 CREATE TABLE VECTOR_OF_STRING9
 (
     IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
-    STRINGVAL VARCHAR(1024),
-    INDEX INTEGER NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+    STRINGVAL VARCHAR(1024)
 );
 
-CREATE TABLE VECTOR_OF_STRING11
+CREATE TABLE VECTOR_OF_STRING10
 (
     IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
-    STRINGVAL VARCHAR(1024),
-    INDEX INTEGER NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+    STRINGVAL VARCHAR(1024)
 );
 
 CREATE TABLE VECTOR_OF_DATE12
 (
     IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
-    DATEVAL TIMESTAMP,
-    INDEX INTEGER NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+    DATEVAL TIMESTAMP
 );
 
-CREATE TABLE VECTOR_OF_DATE14
+CREATE TABLE VECTOR_OF_DATE13
 (
     IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
-    DATEVAL TIMESTAMP,
-    INDEX INTEGER NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+    DATEVAL TIMESTAMP
 );
 
 CREATE TABLE VECTOR_OF_LOCALE15
 (
     IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
-    LOCALEVAL CHAR(20),
-    INDEX INTEGER NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+    LOCALEVAL CHAR(20)
 );
 
-CREATE TABLE VECTOR_OF_LOCALE17
+CREATE TABLE VECTOR_OF_LOCALE16
 (
     IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
-    LOCALEVAL CHAR(20),
-    INDEX INTEGER NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+    LOCALEVAL CHAR(20)
 );
 
 CREATE TABLE VECTOR_OF_BIG_DECIMAL18
 (
     IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
-    BIG_DECIMALVAL DECIMAL(17,6),
-    INDEX INTEGER NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+    BIG_DECIMALVAL DECIMAL(27,16)
 );
 
-CREATE TABLE VECTOR_OF_BIG_DECIMAL20
+CREATE TABLE VECTOR_OF_BIG_DECIMAL19
 (
     IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
-    BIG_DECIMALVAL DECIMAL(17,6),
-    INDEX INTEGER NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+    BIG_DECIMALVAL DECIMAL(27,16)
 );
 
 CREATE TABLE VECTOR_OF_BIG_INTEGER21
 (
     IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
-    BIG_INTEGERVAL BIGINT,
-    INDEX INTEGER NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+    BIG_INTEGERVAL BIGINT
 );
 
-CREATE TABLE VECTOR_OF_BIG_INTEGER23
+CREATE TABLE VECTOR_OF_BIG_INTEGER22
 (
     IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
-    BIG_INTEGERVAL BIGINT,
-    INDEX INTEGER NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+    BIG_INTEGERVAL BIGINT
 );
 
 CREATE TABLE VECTOR_OF_BYTE24
 (
     IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
-    BYTEVAL SMALLINT,
-    INDEX INTEGER NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+    BYTEVAL SMALLINT
 );
 
-CREATE TABLE VECTOR_OF_BYTE26
+CREATE TABLE VECTOR_OF_BYTE25
 (
     IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
-    BYTEVAL SMALLINT,
-    INDEX INTEGER NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+    BYTEVAL SMALLINT
 );
 
 CREATE TABLE VECTOR_OF_DOUBLE27
 (
     IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
-    DOUBLEVAL DOUBLE,
-    INDEX INTEGER NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+    DOUBLEVAL DOUBLE
 );
 
-CREATE TABLE VECTOR_OF_DOUBLE29
+CREATE TABLE VECTOR_OF_DOUBLE28
 (
     IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
-    DOUBLEVAL DOUBLE,
-    INDEX INTEGER NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+    DOUBLEVAL DOUBLE
 );
 
 CREATE TABLE VECTOR_OF_FLOAT30
 (
     IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
-    FLOATVAL FLOAT,
-    INDEX INTEGER NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+    FLOATVAL FLOAT
 );
 
-CREATE TABLE VECTOR_OF_FLOAT32
+CREATE TABLE VECTOR_OF_FLOAT31
 (
     IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
-    FLOATVAL FLOAT,
-    INDEX INTEGER NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+    FLOATVAL FLOAT
 );
 
 CREATE TABLE VECTOR_OF_INTEGER33
 (
     IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
-    INTEGERVAL INTEGER,
-    INDEX INTEGER NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+    INTEGERVAL INTEGER
 );
 
-CREATE TABLE VECTOR_OF_INTEGER35
+CREATE TABLE VECTOR_OF_INTEGER34
 (
     IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
-    INTEGERVAL INTEGER,
-    INDEX INTEGER NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+    INTEGERVAL INTEGER
 );
 
 CREATE TABLE VECTOR_OF_LONG36
 (
     IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
-    LONGVAL BIGINT,
-    INDEX INTEGER NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+    LONGVAL BIGINT
 );
 
-CREATE TABLE VECTOR_OF_LONG38
+CREATE TABLE VECTOR_OF_LONG37
 (
     IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
-    LONGVAL BIGINT,
-    INDEX INTEGER NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+    LONGVAL BIGINT
 );
 
 CREATE TABLE VECTOR_OF_SHORT39
 (
     IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
-    SHORTVAL SMALLINT,
-    INDEX INTEGER NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+    SHORTVAL SMALLINT
 );
 
-CREATE TABLE VECTOR_OF_SHORT41
+CREATE TABLE VECTOR_OF_SHORT40
 (
     IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
-    SHORTVAL SMALLINT,
-    INDEX INTEGER NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+    SHORTVAL SMALLINT
 );
 
 --SetCollections
@@ -4045,203 +4066,241 @@
 CREATE TABLE SET_COLLECTIONS
 (
     IDENTIFIER INTEGER NOT NULL,
-	SET_OF_STRING10 LONG VARCHAR FOR BIT DATA,
-	SET_OF_DATE13 LONG VARCHAR FOR BIT DATA,
-	SET_OF_LOCALE16 LONG VARCHAR FOR BIT DATA,
-	SET_OF_BIG_DECIMAL19 LONG VARCHAR FOR BIT DATA,
-	SET_OF_BIG_INTEGER22 LONG VARCHAR FOR BIT DATA,
-	SET_OF_BYTE25 LONG VARCHAR FOR BIT DATA,
-	SET_OF_DOUBLE28 LONG VARCHAR FOR BIT DATA,
-	SET_OF_FLOAT31 LONG VARCHAR FOR BIT DATA,
-	SET_OF_INTEGER34 LONG VARCHAR FOR BIT DATA,
-	SET_OF_LONG37 LONG VARCHAR FOR BIT DATA,
-	SET_OF_SHORT40 LONG VARCHAR FOR BIT DATA,
+    SET_OF_STRING11 LONG VARCHAR FOR BIT DATA,
+    SET_OF_DATE14 LONG VARCHAR FOR BIT DATA,
+    SET_OF_LOCALE17 LONG VARCHAR FOR BIT DATA,
+    SET_OF_BIG_DECIMAL20 LONG VARCHAR FOR BIT DATA,
+    SET_OF_BIG_INTEGER23 LONG VARCHAR FOR BIT DATA,
+    SET_OF_BYTE26 LONG VARCHAR FOR BIT DATA,
+    SET_OF_DOUBLE29 LONG VARCHAR FOR BIT DATA,
+    SET_OF_FLOAT32 LONG VARCHAR FOR BIT DATA,
+    SET_OF_INTEGER35 LONG VARCHAR FOR BIT DATA,
+    SET_OF_LONG38 LONG VARCHAR FOR BIT DATA,
+    SET_OF_SHORT41 LONG VARCHAR FOR BIT DATA,
+    SET_OF_SIMPLE_CLASS42 LONG VARCHAR FOR BIT DATA,
     CONSTRAINT SC_PK PRIMARY KEY (IDENTIFIER)
 );
 
 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,
-    OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+    ID BIGINT NOT NULL,
+    INTVAL INTEGER NOT NULL,
+    STRINGVAL VARCHAR(128) NOT NULL
 );
 
 CREATE TABLE SET_OF_OBJECT2
 (
     IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
-    OBJREF BIGINT REFERENCES SIMPLE_CLASS 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,
-    SIMPCLSREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+    ID BIGINT NOT NULL,
+    INTVAL INTEGER NOT NULL,
+    STRINGVAL VARCHAR(128) NOT NULL
 );
 
 CREATE TABLE SET_OF_SIMPLE_CLASS5
 (
     IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
-    SIMPCLSREF BIGINT REFERENCES SIMPLE_CLASS 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,
-    SIMPINTREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+    ID BIGINT NOT NULL,
+    INTVAL INTEGER NOT NULL,
+    STRINGVAL VARCHAR(128) NOT NULL
 );
 
 CREATE TABLE SET_OF_SIMPLE_INTERFACE8
 (
     IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
-    SIMPINTREF BIGINT REFERENCES SIMPLE_CLASS 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_STRING11
+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_DATE14
+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_LOCALE17
+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,
-    BIG_DECIMALVAL DECIMAL(17,6)
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+    BIG_DECIMALVAL DECIMAL(27,16)
 );
 
-CREATE TABLE SET_OF_BIG_DECIMAL20
+CREATE TABLE SET_OF_BIG_DECIMAL19
 (
     IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
-    BIG_DECIMALVAL DECIMAL(17,6)
+    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_INTEGER23
+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_BYTE26
+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_DOUBLE29
+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_FLOAT32
+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_INTEGER35
+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_LONG38
+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_SHORT41
+CREATE TABLE SET_OF_SHORT40
 (
     IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
+    ALLOW_DUPLICATES BIGINT NOT NULL,
     SHORTVAL SMALLINT
 );
 
@@ -4250,203 +4309,241 @@
 CREATE TABLE HASHSET_COLLECTIONS
 (
     IDENTIFIER INTEGER NOT NULL,
-	HASHSET_OF_STRING10 LONG VARCHAR FOR BIT DATA,
-	HASHSET_OF_DATE13 LONG VARCHAR FOR BIT DATA,
-	HASHSET_OF_LOCALE16 LONG VARCHAR FOR BIT DATA,
-	HASHSET_OF_BIG_DECIMAL19 LONG VARCHAR FOR BIT DATA,
-	HASHSET_OF_BIG_INTEGER22 LONG VARCHAR FOR BIT DATA,
-	HASHSET_OF_BYTE25 LONG VARCHAR FOR BIT DATA,
-	HASHSET_OF_DOUBLE28 LONG VARCHAR FOR BIT DATA,
-	HASHSET_OF_FLOAT31 LONG VARCHAR FOR BIT DATA,
-	HASHSET_OF_INTEGER34 LONG VARCHAR FOR BIT DATA,
-	HASHSET_OF_LONG37 LONG VARCHAR FOR BIT DATA,
-	HASHSET_OF_SHORT40 LONG VARCHAR FOR BIT DATA,
+    HASHSET_OF_STRING11 LONG VARCHAR FOR BIT DATA,
+    HASHSET_OF_DATE14 LONG VARCHAR FOR BIT DATA,
+    HASHSET_OF_LOCALE17 LONG VARCHAR FOR BIT DATA,
+    HASHSET_OF_BIG_DECIMAL20 LONG VARCHAR FOR BIT DATA,
+    HASHSET_OF_BIG_INTEGER23 LONG VARCHAR FOR BIT DATA,
+    HASHSET_OF_BYTE26 LONG VARCHAR FOR BIT DATA,
+    HASHSET_OF_DOUBLE29 LONG VARCHAR FOR BIT DATA,
+    HASHSET_OF_FLOAT32 LONG VARCHAR FOR BIT DATA,
+    HASHSET_OF_INTEGER35 LONG VARCHAR FOR BIT DATA,
+    HASHSET_OF_LONG38 LONG VARCHAR FOR BIT DATA,
+    HASHSET_OF_SHORT41 LONG VARCHAR FOR BIT DATA,
+    HASHSET_OF_SIMPLE_CLASS42 LONG VARCHAR FOR BIT DATA,
     CONSTRAINT HSC_PK PRIMARY KEY (IDENTIFIER)
 );
 
 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,
-    OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+    ID BIGINT NOT NULL,
+    INTVAL INTEGER NOT NULL,
+    STRINGVAL VARCHAR(128) NOT NULL
 );
 
 CREATE TABLE HASHSET_OF_OBJECT2
 (
     IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
-    OBJREF BIGINT REFERENCES SIMPLE_CLASS 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,
-    SIMPCLSREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+    ID BIGINT NOT NULL,
+    INTVAL INTEGER NOT NULL,
+    STRINGVAL VARCHAR(128) NOT NULL
 );
 
 CREATE TABLE HASHSET_OF_SIMPLE_CLASS5
 (
     IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
-    SIMPCLSREF BIGINT REFERENCES SIMPLE_CLASS 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,
-    SIMPINTREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+    ID BIGINT NOT NULL,
+    INTVAL INTEGER NOT NULL,
+    STRINGVAL VARCHAR(128) NOT NULL
 );
 
 CREATE TABLE HASHSET_OF_SIMPLE_INTERFACE8
 (
     IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
-    SIMPINTREF BIGINT REFERENCES SIMPLE_CLASS 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_STRING11
+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_DATE14
+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_LOCALE17
+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,
-    BIG_DECIMALVAL DECIMAL(17,6)
+    ALLOW_DUPLICATES BIGINT NOT NULL,
+    BIG_DECIMALVAL DECIMAL(27,16)
 );
 
-CREATE TABLE HASHSET_OF_BIG_DECIMAL20
+CREATE TABLE HASHSET_OF_BIG_DECIMAL19
 (
     IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
-    BIG_DECIMALVAL DECIMAL(17,6)
+    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_INTEGER23
+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_BYTE26
+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_DOUBLE29
+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_FLOAT32
+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_INTEGER35
+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_LONG38
+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_SHORT41
+CREATE TABLE HASHSET_OF_SHORT40
 (
     IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
+    ALLOW_DUPLICATES BIGINT NOT NULL,
     SHORTVAL SMALLINT
 );
 
@@ -4562,14 +4659,14 @@
 CREATE TABLE TREESET_OF_BIG_DECIMAL15
 (
     IDENTIFIER INTEGER REFERENCES TREESET_COLLECTIONS NOT NULL,
-    BIG_DECIMALVAL DECIMAL(17,6),
+    BIG_DECIMALVAL DECIMAL(27,16),
     INDEX INTEGER NOT NULL
 );
 
 CREATE TABLE TREESET_OF_BIG_DECIMAL17
 (
     IDENTIFIER INTEGER REFERENCES TREESET_COLLECTIONS NOT NULL,
-    BIG_DECIMALVAL DECIMAL(17,6),
+    BIG_DECIMALVAL DECIMAL(27,16),
     INDEX INTEGER NOT NULL
 );
 
@@ -4939,7 +5036,7 @@
 (
     IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    BIG_DECIMALVAL DECIMAL(17,6)
+    BIG_DECIMALVAL DECIMAL(27,16)
 );
 
 CREATE TABLE MAP_OF_STRING_BIG_INTEGER107
@@ -5259,7 +5356,7 @@
 (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    BIG_DECIMALVAL DECIMAL(17,6)
+    BIG_DECIMALVAL DECIMAL(27,16)
 );
 
 CREATE TABLE HASHMAP_STR_BIG_INTEGER107
@@ -5579,7 +5676,7 @@
 (
     IDENTIFIER INTEGER REFERENCES HASHTABLESTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    BIG_DECIMALVAL DECIMAL(17,6)
+    BIG_DECIMALVAL DECIMAL(27,16)
 );
 
 CREATE TABLE HASHTBL_STR_BIG_INTEGER107
@@ -5859,7 +5956,7 @@
 CREATE TABLE HASHMAP_BIG_DECIMAL53_STR (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGVALUE_COLLECTIONS NOT NULL,
     VALUEVAL VARCHAR(100) NOT NULL,
-    KEYVAL DECIMAL(17,6)
+    KEYVAL DECIMAL(27,16)
 );
 
 CREATE TABLE HASHMAP_BIG_INTEGER62_STR (
@@ -6144,7 +6241,7 @@
 CREATE TABLE HASHTBL_BIG_DECIMAL53_STR (
     IDENTIFIER INTEGER REFERENCES HASHTBLSTRINGVALUE_COLLECTIONS NOT NULL,
     VALUEVAL VARCHAR(100) NOT NULL,
-    KEYVAL DECIMAL(17,6)
+    KEYVAL DECIMAL(27,16)
 );
 
 CREATE TABLE HASHTBL_BIG_INTEGER62_STR (
@@ -6440,7 +6537,7 @@
 CREATE TABLE TREEMAP_BIG_DECIMAL53_STR (
     IDENTIFIER INTEGER REFERENCES TREEMAPSTRINGVALUE_COLLECTIONS NOT NULL,
     VALUEVAL VARCHAR(100) NOT NULL,
-    BIG_DECIMALVAL DECIMAL(17,6),
+    BIG_DECIMALVAL DECIMAL(27,16),
     INDEX INTEGER NOT NULL
 );
 
@@ -6727,7 +6824,7 @@
 CREATE TABLE MAP_OF_BIG_DECIMAL53_STRING (
     IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL,
     VALUEVAL VARCHAR(100) NOT NULL,
-    KEYVAL DECIMAL(17,6)
+    KEYVAL DECIMAL(27,16)
 );
 
 CREATE TABLE MAP_OF_BIG_INTEGER62_STRING (
@@ -7064,7 +7161,7 @@
 (
     IDENTIFIER INTEGER REFERENCES TREEMAPSTRINGKEY_COLLECTIONS NOT NULL,
     KEYVAL VARCHAR(100) NOT NULL,
-    BIG_DECIMALVAL DECIMAL(17,6),
+    BIG_DECIMALVAL DECIMAL(27,16),
     INDEX INTEGER NOT NULL
 );
 



Mime
View raw message