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 [5/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/datastoreidentity/schema.sql
URL: http://svn.apache.org/viewcvs/incubator/jdo/trunk/tck20/test/sql/derby/datastoreidentity/schema.sql?rev=312732&r1=312731&r2=312732&view=diff
==============================================================================
--- incubator/jdo/trunk/tck20/test/sql/derby/datastoreidentity/schema.sql (original)
+++ incubator/jdo/trunk/tck20/test/sql/derby/datastoreidentity/schema.sql Mon Oct 10 13:35:04 2005
@@ -808,78 +808,78 @@
 (
     DATASTORE_IDENTITY INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY,
     IDENTIFIER INTEGER,
-    BIG_DECIMAL0 DECIMAL(17,6),
-    BIG_DECIMAL1 DECIMAL(17,6),
-    BIG_DECIMAL102 DECIMAL(17,6),
-    BIG_DECIMAL103 DECIMAL(17,6),
-    BIG_DECIMAL104 DECIMAL(17,6),
-    BIG_DECIMAL108 DECIMAL(17,6),
-    BIG_DECIMAL109 DECIMAL(17,6),
-    BIG_DECIMAL11 DECIMAL(17,6),
-    BIG_DECIMAL110 DECIMAL(17,6),
-    BIG_DECIMAL112 DECIMAL(17,6),
-    BIG_DECIMAL113 DECIMAL(17,6),
-    BIG_DECIMAL114 DECIMAL(17,6),
-    BIG_DECIMAL119 DECIMAL(17,6),
-    BIG_DECIMAL12 DECIMAL(17,6),
-    BIG_DECIMAL120 DECIMAL(17,6),
-    BIG_DECIMAL121 DECIMAL(17,6),
-    BIG_DECIMAL124 DECIMAL(17,6),
-    BIG_DECIMAL125 DECIMAL(17,6),
-    BIG_DECIMAL126 DECIMAL(17,6),
-    BIG_DECIMAL128 DECIMAL(17,6),
-    BIG_DECIMAL129 DECIMAL(17,6),
-    BIG_DECIMAL13 DECIMAL(17,6),
-    BIG_DECIMAL130 DECIMAL(17,6),
-    BIG_DECIMAL138 DECIMAL(17,6),
-    BIG_DECIMAL139 DECIMAL(17,6),
-    BIG_DECIMAL140 DECIMAL(17,6),
-    BIG_DECIMAL16 DECIMAL(17,6),
-    BIG_DECIMAL17 DECIMAL(17,6),
-    BIG_DECIMAL18 DECIMAL(17,6),
-    BIG_DECIMAL2 DECIMAL(17,6),
-    BIG_DECIMAL20 DECIMAL(17,6),
-    BIG_DECIMAL21 DECIMAL(17,6),
-    BIG_DECIMAL22 DECIMAL(17,6),
-    BIG_DECIMAL30 DECIMAL(17,6),
-    BIG_DECIMAL31 DECIMAL(17,6),
-    BIG_DECIMAL32 DECIMAL(17,6),
-    BIG_DECIMAL36 DECIMAL(17,6),
-    BIG_DECIMAL37 DECIMAL(17,6),
-    BIG_DECIMAL38 DECIMAL(17,6),
-    BIG_DECIMAL4 DECIMAL(17,6),
-    BIG_DECIMAL40 DECIMAL(17,6),
-    BIG_DECIMAL41 DECIMAL(17,6),
-    BIG_DECIMAL42 DECIMAL(17,6),
-    BIG_DECIMAL47 DECIMAL(17,6),
-    BIG_DECIMAL48 DECIMAL(17,6),
-    BIG_DECIMAL49 DECIMAL(17,6),
-    BIG_DECIMAL5 DECIMAL(17,6),
-    BIG_DECIMAL52 DECIMAL(17,6),
-    BIG_DECIMAL53 DECIMAL(17,6),
-    BIG_DECIMAL54 DECIMAL(17,6),
-    BIG_DECIMAL56 DECIMAL(17,6),
-    BIG_DECIMAL57 DECIMAL(17,6),
-    BIG_DECIMAL58 DECIMAL(17,6),
-    BIG_DECIMAL6 DECIMAL(17,6),
-    BIG_DECIMAL66 DECIMAL(17,6),
-    BIG_DECIMAL67 DECIMAL(17,6),
-    BIG_DECIMAL68 DECIMAL(17,6),
-    BIG_DECIMAL72 DECIMAL(17,6),
-    BIG_DECIMAL73 DECIMAL(17,6),
-    BIG_DECIMAL74 DECIMAL(17,6),
-    BIG_DECIMAL76 DECIMAL(17,6),
-    BIG_DECIMAL77 DECIMAL(17,6),
-    BIG_DECIMAL78 DECIMAL(17,6),
-    BIG_DECIMAL83 DECIMAL(17,6),
-    BIG_DECIMAL84 DECIMAL(17,6),
-    BIG_DECIMAL85 DECIMAL(17,6),
-    BIG_DECIMAL88 DECIMAL(17,6),
-    BIG_DECIMAL89 DECIMAL(17,6),
-    BIG_DECIMAL90 DECIMAL(17,6),
-    BIG_DECIMAL92 DECIMAL(17,6),
-    BIG_DECIMAL93 DECIMAL(17,6),
-    BIG_DECIMAL94 DECIMAL(17,6)
+    BIG_DECIMAL0 DECIMAL(27,16),
+    BIG_DECIMAL1 DECIMAL(27,16),
+    BIG_DECIMAL102 DECIMAL(27,16),
+    BIG_DECIMAL103 DECIMAL(27,16),
+    BIG_DECIMAL104 DECIMAL(27,16),
+    BIG_DECIMAL108 DECIMAL(27,16),
+    BIG_DECIMAL109 DECIMAL(27,16),
+    BIG_DECIMAL11 DECIMAL(27,16),
+    BIG_DECIMAL110 DECIMAL(27,16),
+    BIG_DECIMAL112 DECIMAL(27,16),
+    BIG_DECIMAL113 DECIMAL(27,16),
+    BIG_DECIMAL114 DECIMAL(27,16),
+    BIG_DECIMAL119 DECIMAL(27,16),
+    BIG_DECIMAL12 DECIMAL(27,16),
+    BIG_DECIMAL120 DECIMAL(27,16),
+    BIG_DECIMAL121 DECIMAL(27,16),
+    BIG_DECIMAL124 DECIMAL(27,16),
+    BIG_DECIMAL125 DECIMAL(27,16),
+    BIG_DECIMAL126 DECIMAL(27,16),
+    BIG_DECIMAL128 DECIMAL(27,16),
+    BIG_DECIMAL129 DECIMAL(27,16),
+    BIG_DECIMAL13 DECIMAL(27,16),
+    BIG_DECIMAL130 DECIMAL(27,16),
+    BIG_DECIMAL138 DECIMAL(27,16),
+    BIG_DECIMAL139 DECIMAL(27,16),
+    BIG_DECIMAL140 DECIMAL(27,16),
+    BIG_DECIMAL16 DECIMAL(27,16),
+    BIG_DECIMAL17 DECIMAL(27,16),
+    BIG_DECIMAL18 DECIMAL(27,16),
+    BIG_DECIMAL2 DECIMAL(27,16),
+    BIG_DECIMAL20 DECIMAL(27,16),
+    BIG_DECIMAL21 DECIMAL(27,16),
+    BIG_DECIMAL22 DECIMAL(27,16),
+    BIG_DECIMAL30 DECIMAL(27,16),
+    BIG_DECIMAL31 DECIMAL(27,16),
+    BIG_DECIMAL32 DECIMAL(27,16),
+    BIG_DECIMAL36 DECIMAL(27,16),
+    BIG_DECIMAL37 DECIMAL(27,16),
+    BIG_DECIMAL38 DECIMAL(27,16),
+    BIG_DECIMAL4 DECIMAL(27,16),
+    BIG_DECIMAL40 DECIMAL(27,16),
+    BIG_DECIMAL41 DECIMAL(27,16),
+    BIG_DECIMAL42 DECIMAL(27,16),
+    BIG_DECIMAL47 DECIMAL(27,16),
+    BIG_DECIMAL48 DECIMAL(27,16),
+    BIG_DECIMAL49 DECIMAL(27,16),
+    BIG_DECIMAL5 DECIMAL(27,16),
+    BIG_DECIMAL52 DECIMAL(27,16),
+    BIG_DECIMAL53 DECIMAL(27,16),
+    BIG_DECIMAL54 DECIMAL(27,16),
+    BIG_DECIMAL56 DECIMAL(27,16),
+    BIG_DECIMAL57 DECIMAL(27,16),
+    BIG_DECIMAL58 DECIMAL(27,16),
+    BIG_DECIMAL6 DECIMAL(27,16),
+    BIG_DECIMAL66 DECIMAL(27,16),
+    BIG_DECIMAL67 DECIMAL(27,16),
+    BIG_DECIMAL68 DECIMAL(27,16),
+    BIG_DECIMAL72 DECIMAL(27,16),
+    BIG_DECIMAL73 DECIMAL(27,16),
+    BIG_DECIMAL74 DECIMAL(27,16),
+    BIG_DECIMAL76 DECIMAL(27,16),
+    BIG_DECIMAL77 DECIMAL(27,16),
+    BIG_DECIMAL78 DECIMAL(27,16),
+    BIG_DECIMAL83 DECIMAL(27,16),
+    BIG_DECIMAL84 DECIMAL(27,16),
+    BIG_DECIMAL85 DECIMAL(27,16),
+    BIG_DECIMAL88 DECIMAL(27,16),
+    BIG_DECIMAL89 DECIMAL(27,16),
+    BIG_DECIMAL90 DECIMAL(27,16),
+    BIG_DECIMAL92 DECIMAL(27,16),
+    BIG_DECIMAL93 DECIMAL(27,16),
+    BIG_DECIMAL94 DECIMAL(27,16)
 );
 
 ALTER TABLE FIELDSOFBIGDECIMAL ADD CONSTRAINT FIELDSOFBIGDPP_PK PRIMARY KEY (DATASTORE_IDENTITY);
@@ -2791,7 +2791,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
@@ -2972,14 +2972,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
@@ -3086,235 +3086,242 @@
 (
     DATASTORE_IDENTITY INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY,
     IDENTIFIER INTEGER,
-	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 (DATASTORE_IDENTITY)
 );
 
 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
@@ -3445,14 +3452,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
 );
 
@@ -3560,235 +3567,242 @@
 (
     DATASTORE_IDENTITY INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY,
     IDENTIFIER INTEGER,
-	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 (DATASTORE_IDENTITY)
 );
 
 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
@@ -3797,235 +3811,242 @@
 (
     DATASTORE_IDENTITY INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY,
     IDENTIFIER INTEGER,
-	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 (DATASTORE_IDENTITY)
 );
 
 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
@@ -4034,203 +4055,241 @@
 (
     DATASTORE_IDENTITY INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY,
     IDENTIFIER INTEGER,
-	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 (DATASTORE_IDENTITY)
 );
 
 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
 );
 
@@ -4240,203 +4299,241 @@
 (
     DATASTORE_IDENTITY INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY,
     IDENTIFIER INTEGER,
-	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 (DATASTORE_IDENTITY)
 );
 
 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
 );
 
@@ -4553,14 +4650,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
 );
 
@@ -4931,7 +5028,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
@@ -5252,7 +5349,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
@@ -5573,7 +5670,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
@@ -5854,7 +5951,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 (
@@ -6140,7 +6237,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 (
@@ -6437,7 +6534,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
 );
 
@@ -6725,7 +6822,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 (
@@ -7063,7 +7160,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