db-jdo-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From mcai...@apache.org
Subject svn commit: r227434 [3/3] - in /incubator/jdo/trunk/tck20/test: orm/datastoreidentity/org/apache/jdo/tck/pc/fieldtypes/ sql/derby/applicationidentity/ sql/derby/datastoreidentity/
Date Thu, 04 Aug 2005 16:50:29 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=227434&r1=227433&r2=227434&view=diff
==============================================================================
--- incubator/jdo/trunk/tck20/test/sql/derby/datastoreidentity/schema.sql (original)
+++ incubator/jdo/trunk/tck20/test/sql/derby/datastoreidentity/schema.sql Thu Aug  4 09:50:15 2005
@@ -470,21 +470,15 @@
 DROP TABLE MAP_OF_STRING_SIMPLE_INTERFACE8;
 DROP TABLE MAP_OF_STRING_OBJECT42;
 DROP TABLE MAP_OF_STRING_OBJECT43;
-DROP TABLE MAP_OF_STRING_OBJECT44;
 DROP TABLE MAP_OF_STRING_SIMPLE_CLASS45;
 DROP TABLE MAP_OF_STRING_SIMPLE_CLASS46;
-DROP TABLE MAP_OF_STRING_SIMPLE_CLASS47;
 DROP TABLE MAP_OF_STRING_SIMPLE_INTERFACE48;
 DROP TABLE MAP_OF_STRING_SIMPLE_INTERFACE49;
-DROP TABLE MAP_OF_STRING_SIMPLE_INTERFACE50;
 DROP TABLE MAP_OF_STRING_OBJECT84;
-DROP TABLE MAP_OF_STRING_OBJECT85;
 DROP TABLE MAP_OF_STRING_OBJECT86;
 DROP TABLE MAP_OF_STRING_SIMPLE_CLASS87;
-DROP TABLE MAP_OF_STRING_SIMPLE_CLASS88;
 DROP TABLE MAP_OF_STRING_SIMPLE_CLASS89;
 DROP TABLE MAP_OF_STRING_SIMPLE_INTERFACE90;
-DROP TABLE MAP_OF_STRING_SIMPLE_INTERFACE91;
 DROP TABLE MAP_OF_STRING_SIMPLE_INTERFACE92;
 DROP TABLE MAP_OF_STRING_STRING95;
 DROP TABLE MAP_OF_STRING_DATE98;
@@ -510,21 +504,15 @@
 DROP TABLE HASHMAP_STR_SIMPLE_INTERFACE8;
 DROP TABLE HASHMAP_STR_OBJECT42;
 DROP TABLE HASHMAP_STR_OBJECT43;
-DROP TABLE HASHMAP_STR_OBJECT44;
 DROP TABLE HASHMAP_STR_SIMPLE_CLASS45;
 DROP TABLE HASHMAP_STR_SIMPLE_CLASS46;
-DROP TABLE HASHMAP_STR_SIMPLE_CLASS47;
 DROP TABLE HASHMAP_STR_SIMPLE_INTERFACE48;
 DROP TABLE HASHMAP_STR_SIMPLE_INTERFACE49;
-DROP TABLE HASHMAP_STR_SIMPLE_INTERFACE50;
 DROP TABLE HASHMAP_STR_OBJECT84;
-DROP TABLE HASHMAP_STR_OBJECT85;
 DROP TABLE HASHMAP_STR_OBJECT86;
 DROP TABLE HASHMAP_STR_SIMPLE_CLASS87;
-DROP TABLE HASHMAP_STR_SIMPLE_CLASS88;
 DROP TABLE HASHMAP_STR_SIMPLE_CLASS89;
 DROP TABLE HASHMAP_STR_SIMPLE_INTERFACE90;
-DROP TABLE HASHMAP_STR_SIMPLE_INTERFACE91;
 DROP TABLE HASHMAP_STR_SIMPLE_INTERFACE92;
 DROP TABLE HASHMAP_STR_STRING95;
 DROP TABLE HASHMAP_STR_DATE98;
@@ -546,25 +534,20 @@
 DROP TABLE MAP_OF_OBJECT4_STRING;
 DROP TABLE MAP_OF_OBJECT5_STRING;
 DROP TABLE MAP_OF_OBJECT6_STRING;
-DROP TABLE MAP_OF_OBJECT7_STRING;
 DROP TABLE MAP_OF_OBJECT8_STRING;
 DROP TABLE MAP_OF_SIMPLE_CLASS9_STRING;
 DROP TABLE MAP_OF_SIMPLE_CLASS10_STRING;
 DROP TABLE MAP_OF_SIMPLE_CLASS11_STRING;
 DROP TABLE MAP_OF_SIMPLE_CLASS12_STRING;
 DROP TABLE MAP_OF_SIMPLE_CLASS13_STRING;
-DROP TABLE MAP_OF_SIMPLE_CLASS14_STRING;
 DROP TABLE MAP_OF_SIMPLE_CLASS15_STRING;
-DROP TABLE MAP_OF_SIMPLE_CLASS16_STRING;
 DROP TABLE MAP_OF_SIMPLE_CLASS17_STRING;
 DROP TABLE MAP_OF_SIMPLE_INTERFACE18_STRING;
 DROP TABLE MAP_OF_SIMPLE_INTERFACE19_STRING;
 DROP TABLE MAP_OF_SIMPLE_INTERFACE20_STRING;
 DROP TABLE MAP_OF_SIMPLE_INTERFACE21_STRING;
 DROP TABLE MAP_OF_SIMPLE_INTERFACE22_STRING;
-DROP TABLE MAP_OF_SIMPLE_INTERFACE23_STRING;
 DROP TABLE MAP_OF_SIMPLE_INTERFACE24_STRING;
-DROP TABLE MAP_OF_SIMPLE_INTERFACE25_STRING;
 DROP TABLE MAP_OF_SIMPLE_INTERFACE26_STRING;
 DROP TABLE MAP_OF_STRING35_STRING;
 DROP TABLE MAP_OF_DATE44_STRING;
@@ -589,21 +572,15 @@
 DROP TABLE HASHTBL_STR_SIMPLE_INTERFACE8;
 DROP TABLE HASHTBL_STR_OBJECT42;
 DROP TABLE HASHTBL_STR_OBJECT43;
-DROP TABLE HASHTBL_STR_OBJECT44;
 DROP TABLE HASHTBL_STR_SIMPLE_CLASS45;
 DROP TABLE HASHTBL_STR_SIMPLE_CLASS46;
-DROP TABLE HASHTBL_STR_SIMPLE_CLASS47;
 DROP TABLE HASHTBL_STR_SIMPLE_INTERFACE48;
 DROP TABLE HASHTBL_STR_SIMPLE_INTERFACE49;
-DROP TABLE HASHTBL_STR_SIMPLE_INTERFACE50;
 DROP TABLE HASHTBL_STR_OBJECT84;
-DROP TABLE HASHTBL_STR_OBJECT85;
 DROP TABLE HASHTBL_STR_OBJECT86;
 DROP TABLE HASHTBL_STR_SIMPLE_CLASS87;
-DROP TABLE HASHTBL_STR_SIMPLE_CLASS88;
 DROP TABLE HASHTBL_STR_SIMPLE_CLASS89;
 DROP TABLE HASHTBL_STR_SIMPLE_INTERFACE90;
-DROP TABLE HASHTBL_STR_SIMPLE_INTERFACE91;
 DROP TABLE HASHTBL_STR_SIMPLE_INTERFACE92;
 DROP TABLE HASHTBL_STR_STRING95;
 DROP TABLE HASHTBL_STR_DATE98;
@@ -629,21 +606,15 @@
 DROP TABLE TREEMAP_STR_SIMPLE_INTERFACE8;
 DROP TABLE TREEMAP_STR_OBJECT42;
 DROP TABLE TREEMAP_STR_OBJECT43;
-DROP TABLE TREEMAP_STR_OBJECT44;
 DROP TABLE TREEMAP_STR_SIMPLE_CLASS45;
 DROP TABLE TREEMAP_STR_SIMPLE_CLASS46;
-DROP TABLE TREEMAP_STR_SIMPLE_CLASS47;
 DROP TABLE TREEMAP_STR_SIMPLE_INTERFACE48;
 DROP TABLE TREEMAP_STR_SIMPLE_INTERFACE49;
-DROP TABLE TREEMAP_STR_SIMPLE_INTERFACE50;
 DROP TABLE TREEMAP_STR_OBJECT84;
-DROP TABLE TREEMAP_STR_OBJECT85;
 DROP TABLE TREEMAP_STR_OBJECT86;
 DROP TABLE TREEMAP_STR_SIMPLE_CLASS87;
-DROP TABLE TREEMAP_STR_SIMPLE_CLASS88;
 DROP TABLE TREEMAP_STR_SIMPLE_CLASS89;
 DROP TABLE TREEMAP_STR_SIMPLE_INTERFACE90;
-DROP TABLE TREEMAP_STR_SIMPLE_INTERFACE91;
 DROP TABLE TREEMAP_STR_SIMPLE_INTERFACE92;
 DROP TABLE TREEMAP_STR_STRING95;
 DROP TABLE TREEMAP_STR_DATE98;
@@ -663,27 +634,21 @@
 DROP TABLE HASHMAP_OBJECT2_STR;
 DROP TABLE HASHMAP_OBJECT3_STR;
 DROP TABLE HASHMAP_OBJECT4_STR;
-DROP TABLE HASHMAP_OBJECT5_STR;
 DROP TABLE HASHMAP_OBJECT6_STR;
-DROP TABLE HASHMAP_OBJECT7_STR;
 DROP TABLE HASHMAP_OBJECT8_STR;
 DROP TABLE HASHMAP_SIMPLE_CLASS9_STR;
 DROP TABLE HASHMAP_SIMPLE_CLASS10_STR;
 DROP TABLE HASHMAP_SIMPLE_CLASS11_STR;
 DROP TABLE HASHMAP_SIMPLE_CLASS12_STR;
 DROP TABLE HASHMAP_SIMPLE_CLASS13_STR;
-DROP TABLE HASHMAP_SIMPLE_CLASS14_STR;
 DROP TABLE HASHMAP_SIMPLE_CLASS15_STR;
-DROP TABLE HASHMAP_SIMPLE_CLASS16_STR;
 DROP TABLE HASHMAP_SIMPLE_CLASS17_STR;
 DROP TABLE HASHMAP_SIMPLE_INTERFACE18_STR;
 DROP TABLE HASHMAP_SIMPLE_INTERFACE19_STR;
 DROP TABLE HASHMAP_SIMPLE_INTERFACE20_STR;
 DROP TABLE HASHMAP_SIMPLE_INTERFACE21_STR;
 DROP TABLE HASHMAP_SIMPLE_INTERFACE22_STR;
-DROP TABLE HASHMAP_SIMPLE_INTERFACE23_STR;
 DROP TABLE HASHMAP_SIMPLE_INTERFACE24_STR;
-DROP TABLE HASHMAP_SIMPLE_INTERFACE25_STR;
 DROP TABLE HASHMAP_SIMPLE_INTERFACE26_STR;
 DROP TABLE HASHMAP_STRING35_STR;
 DROP TABLE HASHMAP_DATE44_STR;
@@ -704,16 +669,13 @@
 DROP TABLE HASHTBL_OBJECT4_STR;
 DROP TABLE HASHTBL_OBJECT5_STR;
 DROP TABLE HASHTBL_OBJECT6_STR;
-DROP TABLE HASHTBL_OBJECT7_STR;
 DROP TABLE HASHTBL_OBJECT8_STR;
 DROP TABLE HASHTBL_SIMPLE_CLASS9_STR;
 DROP TABLE HASHTBL_SIMPLE_CLASS10_STR;
 DROP TABLE HASHTBL_SIMPLE_CLASS11_STR;
 DROP TABLE HASHTBL_SIMPLE_CLASS12_STR;
 DROP TABLE HASHTBL_SIMPLE_CLASS13_STR;
-DROP TABLE HASHTBL_SIMPLE_CLASS14_STR;
 DROP TABLE HASHTBL_SIMPLE_CLASS15_STR;
-DROP TABLE HASHTBL_SIMPLE_CLASS16_STR;
 DROP TABLE HASHTBL_SIMPLE_CLASS17_STR;
 DROP TABLE HASHTBL_SIMPLE_INTERFACE18_STR;
 DROP TABLE HASHTBL_SIMPLE_INTERFACE19_STR;
@@ -722,7 +684,6 @@
 DROP TABLE HASHTBL_SIMPLE_INTERFACE22_STR;
 DROP TABLE HASHTBL_SIMPLE_INTERFACE23_STR;
 DROP TABLE HASHTBL_SIMPLE_INTERFACE24_STR;
-DROP TABLE HASHTBL_SIMPLE_INTERFACE25_STR;
 DROP TABLE HASHTBL_SIMPLE_INTERFACE26_STR;
 DROP TABLE HASHTBL_STRING35_STR;
 DROP TABLE HASHTBL_DATE44_STR;
@@ -741,27 +702,21 @@
 DROP TABLE TREEMAP_OBJECT2_STR;
 DROP TABLE TREEMAP_OBJECT3_STR;
 DROP TABLE TREEMAP_OBJECT4_STR;
-DROP TABLE TREEMAP_OBJECT5_STR;
 DROP TABLE TREEMAP_OBJECT6_STR;
-DROP TABLE TREEMAP_OBJECT7_STR;
 DROP TABLE TREEMAP_OBJECT8_STR;
 DROP TABLE TREEMAP_SIMPLE_CLASS9_STR;
 DROP TABLE TREEMAP_SIMPLE_CLASS10_STR;
 DROP TABLE TREEMAP_SIMPLE_CLASS11_STR;
 DROP TABLE TREEMAP_SIMPLE_CLASS12_STR;
 DROP TABLE TREEMAP_SIMPLE_CLASS13_STR;
-DROP TABLE TREEMAP_SIMPLE_CLASS14_STR;
 DROP TABLE TREEMAP_SIMPLE_CLASS15_STR;
-DROP TABLE TREEMAP_SIMPLE_CLASS16_STR;
 DROP TABLE TREEMAP_SIMPLE_CLASS17_STR;
 DROP TABLE TREEMAP_SIMPLE_INTERFACE18_STR;
 DROP TABLE TREEMAP_SIMPLE_INTERFACE19_STR;
 DROP TABLE TREEMAP_SIMPLE_INTERFACE20_STR;
 DROP TABLE TREEMAP_SIMPLE_INTERFACE21_STR;
 DROP TABLE TREEMAP_SIMPLE_INTERFACE22_STR;
-DROP TABLE TREEMAP_SIMPLE_INTERFACE23_STR;
 DROP TABLE TREEMAP_SIMPLE_INTERFACE24_STR;
-DROP TABLE TREEMAP_SIMPLE_INTERFACE25_STR;
 DROP TABLE TREEMAP_SIMPLE_INTERFACE26_STR;
 DROP TABLE TREEMAP_STRING35_STR;
 DROP TABLE TREEMAP_DATE44_STR;
@@ -1075,79 +1030,79 @@
 CREATE TABLE FIELDSOFCHARACTER
 (
     DATASTORE_IDENTITY INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY,
-    IDENTIFIER CHAR(1),
-    CHARACTER0 CHAR(1),
-    CHARACTER1 CHAR(1),
-    CHARACTER102 CHAR(1),
-    CHARACTER103 CHAR(1),
-    CHARACTER104 CHAR(1),
-    CHARACTER108 CHAR(1),
-    CHARACTER109 CHAR(1),
-    CHARACTER11 CHAR(1),
-    CHARACTER110 CHAR(1),
-    CHARACTER112 CHAR(1),
-    CHARACTER113 CHAR(1),
-    CHARACTER114 CHAR(1),
-    CHARACTER119 CHAR(1),
-    CHARACTER12 CHAR(1),
-    CHARACTER120 CHAR(1),
-    CHARACTER121 CHAR(1),
-    CHARACTER124 CHAR(1),
-    CHARACTER125 CHAR(1),
-    CHARACTER126 CHAR(1),
-    CHARACTER128 CHAR(1),
-    CHARACTER129 CHAR(1),
-    CHARACTER13 CHAR(1),
-    CHARACTER130 CHAR(1),
-    CHARACTER138 CHAR(1),
-    CHARACTER139 CHAR(1),
-    CHARACTER140 CHAR(1),
-    CHARACTER16 CHAR(1),
-    CHARACTER17 CHAR(1),
-    CHARACTER18 CHAR(1),
-    CHARACTER2 CHAR(1),
-    CHARACTER20 CHAR(1),
-    CHARACTER21 CHAR(1),
-    CHARACTER22 CHAR(1),
-    CHARACTER30 CHAR(1),
-    CHARACTER31 CHAR(1),
-    CHARACTER32 CHAR(1),
-    CHARACTER36 CHAR(1),
-    CHARACTER37 CHAR(1),
-    CHARACTER38 CHAR(1),
-    CHARACTER4 CHAR(1),
-    CHARACTER40 CHAR(1),
-    CHARACTER41 CHAR(1),
-    CHARACTER42 CHAR(1),
-    CHARACTER47 CHAR(1),
-    CHARACTER48 CHAR(1),
-    CHARACTER49 CHAR(1),
-    CHARACTER5 CHAR(1),
-    CHARACTER52 CHAR(1),
-    CHARACTER53 CHAR(1),
-    CHARACTER54 CHAR(1),
-    CHARACTER56 CHAR(1),
-    CHARACTER57 CHAR(1),
-    CHARACTER58 CHAR(1),
-    CHARACTER6 CHAR(1),
-    CHARACTER66 CHAR(1),
-    CHARACTER67 CHAR(1),
-    CHARACTER68 CHAR(1),
-    CHARACTER72 CHAR(1),
-    CHARACTER73 CHAR(1),
-    CHARACTER74 CHAR(1),
-    CHARACTER76 CHAR(1),
-    CHARACTER77 CHAR(1),
-    CHARACTER78 CHAR(1),
-    CHARACTER83 CHAR(1),
-    CHARACTER84 CHAR(1),
-    CHARACTER85 CHAR(1),
-    CHARACTER88 CHAR(1),
-    CHARACTER89 CHAR(1),
-    CHARACTER90 CHAR(1),
-    CHARACTER92 CHAR(1),
-    CHARACTER93 CHAR(1),
-    CHARACTER94 CHAR(1)
+    IDENTIFIER INTEGER,
+    CHARACTER0 INTEGER,
+    CHARACTER1 INTEGER,
+    CHARACTER102 INTEGER,
+    CHARACTER103 INTEGER,
+    CHARACTER104 INTEGER,
+    CHARACTER108 INTEGER,
+    CHARACTER109 INTEGER,
+    CHARACTER11 INTEGER,
+    CHARACTER110 INTEGER,
+    CHARACTER112 INTEGER,
+    CHARACTER113 INTEGER,
+    CHARACTER114 INTEGER,
+    CHARACTER119 INTEGER,
+    CHARACTER12 INTEGER,
+    CHARACTER120 INTEGER,
+    CHARACTER121 INTEGER,
+    CHARACTER124 INTEGER,
+    CHARACTER125 INTEGER,
+    CHARACTER126 INTEGER,
+    CHARACTER128 INTEGER,
+    CHARACTER129 INTEGER,
+    CHARACTER13 INTEGER,
+    CHARACTER130 INTEGER,
+    CHARACTER138 INTEGER,
+    CHARACTER139 INTEGER,
+    CHARACTER140 INTEGER,
+    CHARACTER16 INTEGER,
+    CHARACTER17 INTEGER,
+    CHARACTER18 INTEGER,
+    CHARACTER2 INTEGER,
+    CHARACTER20 INTEGER,
+    CHARACTER21 INTEGER,
+    CHARACTER22 INTEGER,
+    CHARACTER30 INTEGER,
+    CHARACTER31 INTEGER,
+    CHARACTER32 INTEGER,
+    CHARACTER36 INTEGER,
+    CHARACTER37 INTEGER,
+    CHARACTER38 INTEGER,
+    CHARACTER4 INTEGER,
+    CHARACTER40 INTEGER,
+    CHARACTER41 INTEGER,
+    CHARACTER42 INTEGER,
+    CHARACTER47 INTEGER,
+    CHARACTER48 INTEGER,
+    CHARACTER49 INTEGER,
+    CHARACTER5 INTEGER,
+    CHARACTER52 INTEGER,
+    CHARACTER53 INTEGER,
+    CHARACTER54 INTEGER,
+    CHARACTER56 INTEGER,
+    CHARACTER57 INTEGER,
+    CHARACTER58 INTEGER,
+    CHARACTER6 INTEGER,
+    CHARACTER66 INTEGER,
+    CHARACTER67 INTEGER,
+    CHARACTER68 INTEGER,
+    CHARACTER72 INTEGER,
+    CHARACTER73 INTEGER,
+    CHARACTER74 INTEGER,
+    CHARACTER76 INTEGER,
+    CHARACTER77 INTEGER,
+    CHARACTER78 INTEGER,
+    CHARACTER83 INTEGER,
+    CHARACTER84 INTEGER,
+    CHARACTER85 INTEGER,
+    CHARACTER88 INTEGER,
+    CHARACTER89 INTEGER,
+    CHARACTER90 INTEGER,
+    CHARACTER92 INTEGER,
+    CHARACTER93 INTEGER,
+    CHARACTER94 INTEGER
 );
 
 ALTER TABLE FIELDSOFCHARACTER ADD CONSTRAINT FIELDSOFCHAROV_PK PRIMARY KEY (DATASTORE_IDENTITY);
@@ -2974,7 +2929,6 @@
     STRINGVAL VARCHAR(1024)
 );
 
-
 CREATE TABLE COLLECTION_OF_DATE12
 (
     IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL,
@@ -3139,42 +3093,42 @@
 CREATE TABLE LIST_OF_SIMPLE_CLASS3
 (
     IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
-    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
+    SIMPCLSREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
     INDEX INTEGER NOT NULL
 );
 
 CREATE TABLE LIST_OF_SIMPLE_CLASS4
 (
     IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
-    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
+    SIMPCLSREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
     INDEX INTEGER NOT NULL
 );
 
 CREATE TABLE LIST_OF_SIMPLE_CLASS5
 (
     IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
-    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
+    SIMPCLSREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
     INDEX INTEGER NOT NULL
 );
 
 CREATE TABLE LIST_OF_SIMPLE_INTERFACE6
 (
     IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
-    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
+    SIMPINTREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
     INDEX INTEGER NOT NULL
 );
 
 CREATE TABLE LIST_OF_SIMPLE_INTERFACE7
 (
     IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
-    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
+    SIMPINTREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
     INDEX INTEGER NOT NULL
 );
 
 CREATE TABLE LIST_OF_SIMPLE_INTERFACE8
 (
     IDENTIFIER INTEGER REFERENCES LIST_COLLECTIONS NOT NULL,
-    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
+    SIMPINTREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
     INDEX INTEGER NOT NULL
 );
 
@@ -3613,42 +3567,42 @@
 CREATE TABLE LINKEDLIST_OF_SIMPLE_CLASS3
 (
     IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
-    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
+    SIMPCLSREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
     INDEX INTEGER NOT NULL
 );
 
 CREATE TABLE LINKEDLIST_OF_SIMPLE_CLASS4
 (
     IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
-    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
+    SIMPCLSREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
     INDEX INTEGER NOT NULL
 );
 
 CREATE TABLE LINKEDLIST_OF_SIMPLE_CLASS5
 (
     IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
-    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
+    SIMPCLSREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
     INDEX INTEGER NOT NULL
 );
 
 CREATE TABLE LINKEDLIST_OF_SIMPLE_INTERFACE6
 (
     IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
-    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
+    SIMPINTREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
     INDEX INTEGER NOT NULL
 );
 
 CREATE TABLE LINKEDLIST_OF_SIMPLE_INTERFACE7
 (
     IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
-    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
+    SIMPINTREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
     INDEX INTEGER NOT NULL
 );
 
 CREATE TABLE LINKEDLIST_OF_SIMPLE_INTERFACE8
 (
     IDENTIFIER INTEGER REFERENCES LINKEDLIST_COLLECTIONS NOT NULL,
-    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
+    SIMPINTREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
     INDEX INTEGER NOT NULL
 );
 
@@ -3850,42 +3804,42 @@
 CREATE TABLE VECTOR_OF_SIMPLE_CLASS3
 (
     IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
-    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
+    SIMPCLSREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
     INDEX INTEGER NOT NULL
 );
 
 CREATE TABLE VECTOR_OF_SIMPLE_CLASS4
 (
     IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
-    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
+    SIMPCLSREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
     INDEX INTEGER NOT NULL
 );
 
 CREATE TABLE VECTOR_OF_SIMPLE_CLASS5
 (
     IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
-    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
+    SIMPCLSREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
     INDEX INTEGER NOT NULL
 );
 
 CREATE TABLE VECTOR_OF_SIMPLE_INTERFACE6
 (
     IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
-    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
+    SIMPINTREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
     INDEX INTEGER NOT NULL
 );
 
 CREATE TABLE VECTOR_OF_SIMPLE_INTERFACE7
 (
     IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
-    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
+    SIMPINTREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
     INDEX INTEGER NOT NULL
 );
 
 CREATE TABLE VECTOR_OF_SIMPLE_INTERFACE8
 (
     IDENTIFIER INTEGER REFERENCES VECTOR_COLLECTIONS NOT NULL,
-    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
+    SIMPINTREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
     INDEX INTEGER NOT NULL
 );
 
@@ -4066,218 +4020,187 @@
 CREATE TABLE SET_OF_OBJECT0
 (
     IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
-    OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER
+    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,
-    INDEX INTEGER
+    OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE SET_OF_OBJECT2
 (
     IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
-    OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER
+    OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE SET_OF_SIMPLE_CLASS3
 (
     IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
-    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER
+    SIMPCLSREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE SET_OF_SIMPLE_CLASS4
 (
     IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
-    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER
+    SIMPCLSREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE SET_OF_SIMPLE_CLASS5
 (
     IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
-    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER
+    SIMPCLSREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE SET_OF_SIMPLE_INTERFACE6
 (
     IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
-    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER
+    SIMPINTREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE SET_OF_SIMPLE_INTERFACE7
 (
     IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
-    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER
+    SIMPINTREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE SET_OF_SIMPLE_INTERFACE8
 (
     IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
-    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER
+    SIMPINTREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE SET_OF_STRING9
 (
     IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
-    STRINGVAL VARCHAR(1024),
-    INDEX INTEGER
+    STRINGVAL VARCHAR(1024)
 );
 
 CREATE TABLE SET_OF_STRING11
 (
     IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
-    STRINGVAL VARCHAR(1024),
-    INDEX INTEGER
+    STRINGVAL VARCHAR(1024)
 );
 
 CREATE TABLE SET_OF_DATE12
 (
     IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
-    DATEVAL DATE,
-    INDEX INTEGER
+    DATEVAL DATE
 );
 
 CREATE TABLE SET_OF_DATE14
 (
     IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
-    DATEVAL DATE,
-    INDEX INTEGER
+    DATEVAL DATE
 );
 
 CREATE TABLE SET_OF_LOCALE15
 (
     IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
-    LOCALEVAL CHAR(20),
-    INDEX INTEGER
+    LOCALEVAL CHAR(20)
 );
 
 CREATE TABLE SET_OF_LOCALE17
 (
     IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
-    LOCALEVAL CHAR(20),
-    INDEX INTEGER
+    LOCALEVAL CHAR(20)
 );
 
 CREATE TABLE SET_OF_BIG_DECIMAL18
 (
     IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
-    BIG_DECIMALVAL DECIMAL(17,6),
-    INDEX INTEGER
+    BIG_DECIMALVAL DECIMAL(17,6)
 );
 
 CREATE TABLE SET_OF_BIG_DECIMAL20
 (
     IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
-    BIG_DECIMALVAL DECIMAL(17,6),
-    INDEX INTEGER
+    BIG_DECIMALVAL DECIMAL(17,6)
 );
 
 CREATE TABLE SET_OF_BIG_INTEGER21
 (
     IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
-    BIG_INTEGERVAL BIGINT,
-    INDEX INTEGER
+    BIG_INTEGERVAL BIGINT
 );
 
 CREATE TABLE SET_OF_BIG_INTEGER23
 (
     IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
-    BIG_INTEGERVAL BIGINT,
-    INDEX INTEGER
+    BIG_INTEGERVAL BIGINT
 );
 
 CREATE TABLE SET_OF_BYTE24
 (
     IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
-    BYTEVAL SMALLINT,
-    INDEX INTEGER
+    BYTEVAL SMALLINT
 );
 
 CREATE TABLE SET_OF_BYTE26
 (
     IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
-    BYTEVAL SMALLINT,
-    INDEX INTEGER
+    BYTEVAL SMALLINT
 );
 
 CREATE TABLE SET_OF_DOUBLE27
 (
     IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
-    DOUBLEVAL DOUBLE,
-    INDEX INTEGER
+    DOUBLEVAL DOUBLE
 );
 
 CREATE TABLE SET_OF_DOUBLE29
 (
     IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
-    DOUBLEVAL DOUBLE,
-    INDEX INTEGER
+    DOUBLEVAL DOUBLE
 );
 
 CREATE TABLE SET_OF_FLOAT30
 (
     IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
-    FLOATVAL FLOAT,
-    INDEX INTEGER
+    FLOATVAL FLOAT
 );
 
 CREATE TABLE SET_OF_FLOAT32
 (
     IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
-    FLOATVAL FLOAT,
-    INDEX INTEGER
+    FLOATVAL FLOAT
 );
 
 CREATE TABLE SET_OF_INTEGER33
 (
     IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
-    INTEGERVAL INTEGER,
-    INDEX INTEGER
+    INTEGERVAL INTEGER
 );
 
 CREATE TABLE SET_OF_INTEGER35
 (
     IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
-    INTEGERVAL INTEGER,
-    INDEX INTEGER
+    INTEGERVAL INTEGER
 );
 
 CREATE TABLE SET_OF_LONG36
 (
     IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
-    LONGVAL BIGINT,
-    INDEX INTEGER
+    LONGVAL BIGINT
 );
 
 CREATE TABLE SET_OF_LONG38
 (
     IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
-    LONGVAL BIGINT,
-    INDEX INTEGER
+    LONGVAL BIGINT
 );
 
 CREATE TABLE SET_OF_SHORT39
 (
     IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
-    SHORTVAL SMALLINT,
-    INDEX INTEGER
+    SHORTVAL SMALLINT
 );
 
 CREATE TABLE SET_OF_SHORT41
 (
     IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL,
-    SHORTVAL SMALLINT,
-    INDEX INTEGER
+    SHORTVAL SMALLINT
 );
 
 --HashSetCollections
@@ -4303,219 +4226,187 @@
 CREATE TABLE HASHSET_OF_OBJECT0
 (
     IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
-    OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER
+    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,
-    INDEX INTEGER
+    OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE HASHSET_OF_OBJECT2
 (
     IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
-    OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER
+    OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE HASHSET_OF_SIMPLE_CLASS3
 (
     IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
-    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER
+    SIMPCLSREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE HASHSET_OF_SIMPLE_CLASS4
 (
     IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
-    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER
+    SIMPCLSREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE HASHSET_OF_SIMPLE_CLASS5
 (
     IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
-    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER
+    SIMPCLSREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE HASHSET_OF_SIMPLE_INTERFACE6
 (
     IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
-    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER
+    SIMPINTREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE HASHSET_OF_SIMPLE_INTERFACE7
 (
     IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
-    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER
+    SIMPINTREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE HASHSET_OF_SIMPLE_INTERFACE8
 (
     IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
-    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER
+    SIMPINTREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE HASHSET_OF_STRING9
 (
     IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
-    STRINGVAL VARCHAR(1024),
-    INDEX INTEGER
+    STRINGVAL VARCHAR(1024)
 );
 
 CREATE TABLE HASHSET_OF_STRING11
 (
     IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
-    STRINGVAL VARCHAR(1024),
-    INDEX INTEGER
+    STRINGVAL VARCHAR(1024)
 );
 
 CREATE TABLE HASHSET_OF_DATE12
 (
     IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
-    DATEVAL DATE,
-    INDEX INTEGER
+    DATEVAL DATE
 );
 
 CREATE TABLE HASHSET_OF_DATE14
 (
     IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
-    DATEVAL DATE,
-    INDEX INTEGER
+    DATEVAL DATE
 );
 
 CREATE TABLE HASHSET_OF_LOCALE15
 (
     IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
-    LOCALEVAL CHAR(20),
-    INDEX INTEGER
+    LOCALEVAL CHAR(20)
 );
 
 CREATE TABLE HASHSET_OF_LOCALE17
 (
     IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
-    LOCALEVAL CHAR(20),
-    INDEX INTEGER
+    LOCALEVAL CHAR(20)
 );
 
 CREATE TABLE HASHSET_OF_BIG_DECIMAL18
 (
     IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
-    BIG_DECIMALVAL DECIMAL(17,6),
-    INDEX INTEGER
+    BIG_DECIMALVAL DECIMAL(17,6)
 );
 
-
 CREATE TABLE HASHSET_OF_BIG_DECIMAL20
 (
     IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
-    BIG_DECIMALVAL DECIMAL(17,6),
-    INDEX INTEGER
+    BIG_DECIMALVAL DECIMAL(17,6)
 );
 
 CREATE TABLE HASHSET_OF_BIG_INTEGER21
 (
     IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
-    BIG_INTEGERVAL BIGINT,
-    INDEX INTEGER
+    BIG_INTEGERVAL BIGINT
 );
 
 CREATE TABLE HASHSET_OF_BIG_INTEGER23
 (
     IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
-    BIG_INTEGERVAL BIGINT,
-    INDEX INTEGER
+    BIG_INTEGERVAL BIGINT
 );
 
 CREATE TABLE HASHSET_OF_BYTE24
 (
     IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
-    BYTEVAL SMALLINT,
-    INDEX INTEGER
+    BYTEVAL SMALLINT
 );
 
 CREATE TABLE HASHSET_OF_BYTE26
 (
     IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
-    BYTEVAL SMALLINT,
-    INDEX INTEGER
+    BYTEVAL SMALLINT
 );
 
 CREATE TABLE HASHSET_OF_DOUBLE27
 (
     IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
-    DOUBLEVAL DOUBLE,
-    INDEX INTEGER
+    DOUBLEVAL DOUBLE
 );
 
 CREATE TABLE HASHSET_OF_DOUBLE29
 (
     IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
-    DOUBLEVAL DOUBLE,
-    INDEX INTEGER
+    DOUBLEVAL DOUBLE
 );
 
 CREATE TABLE HASHSET_OF_FLOAT30
 (
     IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
-    FLOATVAL FLOAT,
-    INDEX INTEGER
+    FLOATVAL FLOAT
 );
 
 CREATE TABLE HASHSET_OF_FLOAT32
 (
     IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
-    FLOATVAL FLOAT,
-    INDEX INTEGER
+    FLOATVAL FLOAT
 );
 
 CREATE TABLE HASHSET_OF_INTEGER33
 (
     IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
-    INTEGERVAL INTEGER,
-    INDEX INTEGER
+    INTEGERVAL INTEGER
 );
 
 CREATE TABLE HASHSET_OF_INTEGER35
 (
     IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
-    INTEGERVAL INTEGER,
-    INDEX INTEGER
+    INTEGERVAL INTEGER
 );
 
 CREATE TABLE HASHSET_OF_LONG36
 (
     IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
-    LONGVAL BIGINT,
-    INDEX INTEGER
+    LONGVAL BIGINT
 );
 
 CREATE TABLE HASHSET_OF_LONG38
 (
     IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
-    LONGVAL BIGINT,
-    INDEX INTEGER
+    LONGVAL BIGINT
 );
 
 CREATE TABLE HASHSET_OF_SHORT39
 (
     IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
-    SHORTVAL SMALLINT,
-    INDEX INTEGER
+    SHORTVAL SMALLINT
 );
 
 CREATE TABLE HASHSET_OF_SHORT41
 (
     IDENTIFIER INTEGER REFERENCES HASHSET_COLLECTIONS NOT NULL,
-    SHORTVAL SMALLINT,
-    INDEX INTEGER
+    SHORTVAL SMALLINT
 );
 
 --TreeSetCollections
@@ -4561,42 +4452,42 @@
 CREATE TABLE TREESET_OF_SIMPLE_CLASS3
 (
     IDENTIFIER INTEGER REFERENCES TREESET_COLLECTIONS NOT NULL,
-    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
+    SIMPCLSREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
     INDEX INTEGER NOT NULL
 );
 
 CREATE TABLE TREESET_OF_SIMPLE_CLASS4
 (
     IDENTIFIER INTEGER REFERENCES TREESET_COLLECTIONS NOT NULL,
-    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
+    SIMPCLSREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
     INDEX INTEGER NOT NULL
 );
 
 CREATE TABLE TREESET_OF_SIMPLE_CLASS5
 (
     IDENTIFIER INTEGER REFERENCES TREESET_COLLECTIONS NOT NULL,
-    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
+    SIMPCLSREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
     INDEX INTEGER NOT NULL
 );
 
 CREATE TABLE TREESET_OF_SIMPLE_INTERFACE6
 (
     IDENTIFIER INTEGER REFERENCES TREESET_COLLECTIONS NOT NULL,
-    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
+    SIMPINTREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
     INDEX INTEGER NOT NULL
 );
 
 CREATE TABLE TREESET_OF_SIMPLE_INTERFACE7
 (
     IDENTIFIER INTEGER REFERENCES TREESET_COLLECTIONS NOT NULL,
-    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
+    SIMPINTREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
     INDEX INTEGER NOT NULL
 );
 
 CREATE TABLE TREESET_OF_SIMPLE_INTERFACE8
 (
     IDENTIFIER INTEGER REFERENCES TREESET_COLLECTIONS NOT NULL,
-    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
+    SIMPINTREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
     INDEX INTEGER NOT NULL
 );
 
@@ -4840,306 +4731,225 @@
 CREATE TABLE MAP_OF_STRING_OBJECT0
 (
     IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    KEYVAL VARCHAR(100) NOT NULL,
+    OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE MAP_OF_STRING_OBJECT1
 (
     IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    KEYVAL VARCHAR(100) NOT NULL,
+    OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE MAP_OF_STRING_OBJECT2
 (
     IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    KEYVAL VARCHAR(100) NOT NULL,
+    OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE MAP_OF_STRING_SIMPLE_CLASS3
 (
     IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    KEYVAL VARCHAR(100) NOT NULL,
+    SIMPCLSREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE MAP_OF_STRING_SIMPLE_CLASS4
 (
     IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    KEYVAL VARCHAR(100) NOT NULL,
+    SIMPCLSREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE MAP_OF_STRING_SIMPLE_CLASS5
 (
     IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    KEYVAL VARCHAR(100) NOT NULL,
+    SIMPCLSREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE MAP_OF_STRING_SIMPLE_INTERFACE6
 (
     IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    KEYVAL VARCHAR(100) NOT NULL,
+    SIMPINTREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE MAP_OF_STRING_SIMPLE_INTERFACE7
 (
     IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    KEYVAL VARCHAR(100) NOT NULL,
+    SIMPINTREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE MAP_OF_STRING_SIMPLE_INTERFACE8
 (
     IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    KEYVAL VARCHAR(100) NOT NULL,
+    SIMPINTREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE MAP_OF_STRING_OBJECT42
 (
     IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    KEYVAL VARCHAR(100) NOT NULL,
+    OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE MAP_OF_STRING_OBJECT43
 (
     IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
-);
-
-CREATE TABLE MAP_OF_STRING_OBJECT44
-(
-    IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    KEYVAL VARCHAR(100) NOT NULL,
+    OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE MAP_OF_STRING_SIMPLE_CLASS45
 (
     IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    KEYVAL VARCHAR(100) NOT NULL,
+    SIMPCLSREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE MAP_OF_STRING_SIMPLE_CLASS46
 (
     IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
-);
-
-CREATE TABLE MAP_OF_STRING_SIMPLE_CLASS47
-(
-    IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    KEYVAL VARCHAR(100) NOT NULL,
+    SIMPCLSREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE MAP_OF_STRING_SIMPLE_INTERFACE48
 (
     IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    KEYVAL VARCHAR(100) NOT NULL,
+    SIMPINTREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE MAP_OF_STRING_SIMPLE_INTERFACE49
 (
     IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
-);
-
-CREATE TABLE MAP_OF_STRING_SIMPLE_INTERFACE50
-(
-    IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    KEYVAL VARCHAR(100) NOT NULL,
+    SIMPINTREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
-
 CREATE TABLE MAP_OF_STRING_OBJECT84
 (
     IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
-);
-
-CREATE TABLE MAP_OF_STRING_OBJECT85
-(
-    IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    KEYVAL VARCHAR(100) NOT NULL,
+    OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE MAP_OF_STRING_OBJECT86
 (
     IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    KEYVAL VARCHAR(100) NOT NULL,
+    OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE MAP_OF_STRING_SIMPLE_CLASS87
 (
     IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
-);
-
-CREATE TABLE MAP_OF_STRING_SIMPLE_CLASS88
-(
-    IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    KEYVAL VARCHAR(100) NOT NULL,
+    SIMPCLSREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE MAP_OF_STRING_SIMPLE_CLASS89
 (
     IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    KEYVAL VARCHAR(100) NOT NULL,
+    SIMPCLSREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE MAP_OF_STRING_SIMPLE_INTERFACE90
 (
     IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
-);
-
-CREATE TABLE MAP_OF_STRING_SIMPLE_INTERFACE91
-(
-    IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    KEYVAL VARCHAR(100) NOT NULL,
+    SIMPINTREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE MAP_OF_STRING_SIMPLE_INTERFACE92
 (
     IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    KEYVAL VARCHAR(100) NOT NULL,
+    SIMPINTREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE MAP_OF_STRING_STRING95
 (
     IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    STRINGVAL VARCHAR(1024),
-    INDEX INTEGER NOT NULL
+    KEYVAL VARCHAR(100) NOT NULL,
+    STRINGVAL VARCHAR(1024)
 );
 
 CREATE TABLE MAP_OF_STRING_DATE98
 (
     IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    DATEVAL DATE,
-    INDEX INTEGER NOT NULL
+    KEYVAL VARCHAR(100) NOT NULL,
+    DATEVAL DATE
 );
 
 CREATE TABLE MAP_OF_STRING_LOCALE101
 (
     IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    LOCALEVAL CHAR(20),
-    INDEX INTEGER NOT NULL
+    KEYVAL VARCHAR(100) NOT NULL,
+    LOCALEVAL CHAR(20)
 );
 
 CREATE TABLE MAP_OF_STRING_BIG_DECIMAL104
 (
     IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    BIG_DECIMALVAL DECIMAL(17,6),
-    INDEX INTEGER NOT NULL
+    KEYVAL VARCHAR(100) NOT NULL,
+    BIG_DECIMALVAL DECIMAL(17,6)
 );
 
 CREATE TABLE MAP_OF_STRING_BIG_INTEGER107
 (
     IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    BIG_INTEGERVAL BIGINT,
-    INDEX INTEGER NOT NULL
+    KEYVAL VARCHAR(100) NOT NULL,
+    BIG_INTEGERVAL BIGINT
 );
 
 CREATE TABLE MAP_OF_STRING_BYTE110
 (
     IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    BYTEVAL SMALLINT,
-    INDEX INTEGER NOT NULL
+    KEYVAL VARCHAR(100) NOT NULL,
+    BYTEVAL SMALLINT
 );
 
 CREATE TABLE MAP_OF_STRING_DOUBLE113
 (
     IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    DOUBLEVAL DOUBLE,
-    INDEX INTEGER NOT NULL
+    KEYVAL VARCHAR(100) NOT NULL,
+    DOUBLEVAL DOUBLE
 );
 
 CREATE TABLE MAP_OF_STRING_FLOAT116
 (
     IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    FLOATVAL FLOAT,
-    INDEX INTEGER NOT NULL
+    KEYVAL VARCHAR(100) NOT NULL,
+    FLOATVAL FLOAT
 );
 
 CREATE TABLE MAP_OF_STRING_INTEGER119
 (
     IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    INTEGERVAL INTEGER,
-    INDEX INTEGER NOT NULL
+    KEYVAL VARCHAR(100) NOT NULL,
+    INTEGERVAL INTEGER
 );
 
 CREATE TABLE MAP_OF_STRING_LONG122
 (
     IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    LONGVAL BIGINT,
-    INDEX INTEGER NOT NULL
+    KEYVAL VARCHAR(100) NOT NULL,
+    LONGVAL BIGINT
 );
 
 CREATE TABLE MAP_OF_STRING_SHORT125
 (
     IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    SHORTVAL SMALLINT,
-    INDEX INTEGER NOT NULL
+    KEYVAL VARCHAR(100) NOT NULL,
+    SHORTVAL SMALLINT
 );
 
 --HashMapOfStringKeyCollections
@@ -5242,306 +5052,225 @@
 CREATE TABLE HASHMAP_STR_OBJECT0
 (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    KEYVAL VARCHAR(100) NOT NULL,
+    OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE HASHMAP_STR_OBJECT1
 (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    KEYVAL VARCHAR(100) NOT NULL,
+    OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE HASHMAP_STR_OBJECT2
 (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    KEYVAL VARCHAR(100) NOT NULL,
+    OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE HASHMAP_STR_SIMPLE_CLASS3
 (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    KEYVAL VARCHAR(100) NOT NULL,
+    SIMPCLSREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE HASHMAP_STR_SIMPLE_CLASS4
 (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    KEYVAL VARCHAR(100) NOT NULL,
+    SIMPCLSREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE HASHMAP_STR_SIMPLE_CLASS5
 (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    KEYVAL VARCHAR(100) NOT NULL,
+    SIMPCLSREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE HASHMAP_STR_SIMPLE_INTERFACE6
 (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    KEYVAL VARCHAR(100) NOT NULL,
+    SIMPINTREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE HASHMAP_STR_SIMPLE_INTERFACE7
 (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    KEYVAL VARCHAR(100) NOT NULL,
+    SIMPINTREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE HASHMAP_STR_SIMPLE_INTERFACE8
 (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    KEYVAL VARCHAR(100) NOT NULL,
+    SIMPINTREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE HASHMAP_STR_OBJECT42
 (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    KEYVAL VARCHAR(100) NOT NULL,
+    OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE HASHMAP_STR_OBJECT43
 (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
-);
-
-CREATE TABLE HASHMAP_STR_OBJECT44
-(
-    IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    KEYVAL VARCHAR(100) NOT NULL,
+    OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE HASHMAP_STR_SIMPLE_CLASS45
 (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    KEYVAL VARCHAR(100) NOT NULL,
+    SIMPCLSREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE HASHMAP_STR_SIMPLE_CLASS46
 (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
-);
-
-CREATE TABLE HASHMAP_STR_SIMPLE_CLASS47
-(
-    IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    KEYVAL VARCHAR(100) NOT NULL,
+    SIMPCLSREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE HASHMAP_STR_SIMPLE_INTERFACE48
 (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    KEYVAL VARCHAR(100) NOT NULL,
+    SIMPINTREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE HASHMAP_STR_SIMPLE_INTERFACE49
 (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
-);
-
-CREATE TABLE HASHMAP_STR_SIMPLE_INTERFACE50
-(
-    IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    KEYVAL VARCHAR(100) NOT NULL,
+    SIMPINTREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
-
 CREATE TABLE HASHMAP_STR_OBJECT84
 (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
-);
-
-CREATE TABLE HASHMAP_STR_OBJECT85
-(
-    IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    KEYVAL VARCHAR(100) NOT NULL,
+    OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE HASHMAP_STR_OBJECT86
 (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    KEYVAL VARCHAR(100) NOT NULL,
+    OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE HASHMAP_STR_SIMPLE_CLASS87
 (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
-);
-
-CREATE TABLE HASHMAP_STR_SIMPLE_CLASS88
-(
-    IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    KEYVAL VARCHAR(100) NOT NULL,
+    SIMPCLSREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE HASHMAP_STR_SIMPLE_CLASS89
 (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    KEYVAL VARCHAR(100) NOT NULL,
+    SIMPCLSREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE HASHMAP_STR_SIMPLE_INTERFACE90
 (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
-);
-
-CREATE TABLE HASHMAP_STR_SIMPLE_INTERFACE91
-(
-    IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    KEYVAL VARCHAR(100) NOT NULL,
+    SIMPINTREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE HASHMAP_STR_SIMPLE_INTERFACE92
 (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    KEYVAL VARCHAR(100) NOT NULL,
+    SIMPINTREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE HASHMAP_STR_STRING95
 (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    STRINGVAL VARCHAR(1024),
-    INDEX INTEGER NOT NULL
+    KEYVAL VARCHAR(100) NOT NULL,
+    STRINGVAL VARCHAR(1024)
 );
 
 CREATE TABLE HASHMAP_STR_DATE98
 (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    DATEVAL DATE,
-    INDEX INTEGER NOT NULL
+    KEYVAL VARCHAR(100) NOT NULL,
+    DATEVAL DATE
 );
 
 CREATE TABLE HASHMAP_STR_LOCALE101
 (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    LOCALEVAL CHAR(20),
-    INDEX INTEGER NOT NULL
+    KEYVAL VARCHAR(100) NOT NULL,
+    LOCALEVAL CHAR(20)
 );
 
 CREATE TABLE HASHMAP_STR_BIG_DECIMAL104
 (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    BIG_DECIMALVAL DECIMAL(17,6),
-    INDEX INTEGER NOT NULL
+    KEYVAL VARCHAR(100) NOT NULL,
+    BIG_DECIMALVAL DECIMAL(17,6)
 );
 
 CREATE TABLE HASHMAP_STR_BIG_INTEGER107
 (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    BIG_INTEGERVAL BIGINT,
-    INDEX INTEGER NOT NULL
+    KEYVAL VARCHAR(100) NOT NULL,
+    BIG_INTEGERVAL BIGINT
 );
 
 CREATE TABLE HASHMAP_STR_BYTE110
 (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    BYTEVAL SMALLINT,
-    INDEX INTEGER NOT NULL
+    KEYVAL VARCHAR(100) NOT NULL,
+    BYTEVAL SMALLINT
 );
 
 CREATE TABLE HASHMAP_STR_DOUBLE113
 (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    DOUBLEVAL DOUBLE,
-    INDEX INTEGER NOT NULL
+    KEYVAL VARCHAR(100) NOT NULL,
+    DOUBLEVAL DOUBLE
 );
 
 CREATE TABLE HASHMAP_STR_FLOAT116
 (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    FLOATVAL FLOAT,
-    INDEX INTEGER NOT NULL
+    KEYVAL VARCHAR(100) NOT NULL,
+    FLOATVAL FLOAT
 );
 
 CREATE TABLE HASHMAP_STR_INTEGER119
 (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    INTEGERVAL INTEGER,
-    INDEX INTEGER NOT NULL
+    KEYVAL VARCHAR(100) NOT NULL,
+    INTEGERVAL INTEGER
 );
 
 CREATE TABLE HASHMAP_STR_LONG122
 (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    LONGVAL BIGINT,
-    INDEX INTEGER NOT NULL
+    KEYVAL VARCHAR(100) NOT NULL,
+    LONGVAL BIGINT
 );
 
 CREATE TABLE HASHMAP_STR_SHORT125
 (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    SHORTVAL SMALLINT,
-    INDEX INTEGER NOT NULL
+    KEYVAL VARCHAR(100) NOT NULL,
+    SHORTVAL SMALLINT
 );
 
 --HashtableOfStringKeyCollections
@@ -5644,306 +5373,225 @@
 CREATE TABLE HASHTBL_STR_OBJECT0
 (
     IDENTIFIER INTEGER REFERENCES HASHTABLESTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    KEYVAL VARCHAR(100) NOT NULL,
+    OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE HASHTBL_STR_OBJECT1
 (
     IDENTIFIER INTEGER REFERENCES HASHTABLESTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    KEYVAL VARCHAR(100) NOT NULL,
+    OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE HASHTBL_STR_OBJECT2
 (
     IDENTIFIER INTEGER REFERENCES HASHTABLESTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    KEYVAL VARCHAR(100) NOT NULL,
+    OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE HASHTBL_STR_SIMPLE_CLASS3
 (
     IDENTIFIER INTEGER REFERENCES HASHTABLESTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    KEYVAL VARCHAR(100) NOT NULL,
+    SIMPCLSREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE HASHTBL_STR_SIMPLE_CLASS4
 (
     IDENTIFIER INTEGER REFERENCES HASHTABLESTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    KEYVAL VARCHAR(100) NOT NULL,
+    SIMPCLSREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE HASHTBL_STR_SIMPLE_CLASS5
 (
     IDENTIFIER INTEGER REFERENCES HASHTABLESTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    KEYVAL VARCHAR(100) NOT NULL,
+    SIMPCLSREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE HASHTBL_STR_SIMPLE_INTERFACE6
 (
     IDENTIFIER INTEGER REFERENCES HASHTABLESTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    KEYVAL VARCHAR(100) NOT NULL,
+    SIMPINTREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE HASHTBL_STR_SIMPLE_INTERFACE7
 (
     IDENTIFIER INTEGER REFERENCES HASHTABLESTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    KEYVAL VARCHAR(100) NOT NULL,
+    SIMPINTREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE HASHTBL_STR_SIMPLE_INTERFACE8
 (
     IDENTIFIER INTEGER REFERENCES HASHTABLESTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    KEYVAL VARCHAR(100) NOT NULL,
+    SIMPINTREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE HASHTBL_STR_OBJECT42
 (
     IDENTIFIER INTEGER REFERENCES HASHTABLESTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    KEYVAL VARCHAR(100) NOT NULL,
+    OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE HASHTBL_STR_OBJECT43
 (
     IDENTIFIER INTEGER REFERENCES HASHTABLESTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
-);
-
-CREATE TABLE HASHTBL_STR_OBJECT44
-(
-    IDENTIFIER INTEGER REFERENCES HASHTABLESTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    KEYVAL VARCHAR(100) NOT NULL,
+    OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE HASHTBL_STR_SIMPLE_CLASS45
 (
     IDENTIFIER INTEGER REFERENCES HASHTABLESTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    KEYVAL VARCHAR(100) NOT NULL,
+    SIMPCLSREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE HASHTBL_STR_SIMPLE_CLASS46
 (
     IDENTIFIER INTEGER REFERENCES HASHTABLESTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
-);
-
-CREATE TABLE HASHTBL_STR_SIMPLE_CLASS47
-(
-    IDENTIFIER INTEGER REFERENCES HASHTABLESTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    KEYVAL VARCHAR(100) NOT NULL,
+    SIMPCLSREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE HASHTBL_STR_SIMPLE_INTERFACE48
 (
     IDENTIFIER INTEGER REFERENCES HASHTABLESTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    KEYVAL VARCHAR(100) NOT NULL,
+    SIMPINTREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE HASHTBL_STR_SIMPLE_INTERFACE49
 (
     IDENTIFIER INTEGER REFERENCES HASHTABLESTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    KEYVAL VARCHAR(100) NOT NULL,
+    SIMPINTREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
-CREATE TABLE HASHTBL_STR_SIMPLE_INTERFACE50
-(
-    IDENTIFIER INTEGER REFERENCES HASHTABLESTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
-);
-
-
 CREATE TABLE HASHTBL_STR_OBJECT84
 (
     IDENTIFIER INTEGER REFERENCES HASHTABLESTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
-);
-
-CREATE TABLE HASHTBL_STR_OBJECT85
-(
-    IDENTIFIER INTEGER REFERENCES HASHTABLESTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    KEYVAL VARCHAR(100) NOT NULL,
+    OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE HASHTBL_STR_OBJECT86
 (
     IDENTIFIER INTEGER REFERENCES HASHTABLESTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    KEYVAL VARCHAR(100) NOT NULL,
+    OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE HASHTBL_STR_SIMPLE_CLASS87
 (
     IDENTIFIER INTEGER REFERENCES HASHTABLESTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
-);
-
-CREATE TABLE HASHTBL_STR_SIMPLE_CLASS88
-(
-    IDENTIFIER INTEGER REFERENCES HASHTABLESTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    KEYVAL VARCHAR(100) NOT NULL,
+    SIMPCLSREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE HASHTBL_STR_SIMPLE_CLASS89
 (
     IDENTIFIER INTEGER REFERENCES HASHTABLESTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    KEYVAL VARCHAR(100) NOT NULL,
+    SIMPCLSREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE HASHTBL_STR_SIMPLE_INTERFACE90
 (
     IDENTIFIER INTEGER REFERENCES HASHTABLESTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
-);
-
-CREATE TABLE HASHTBL_STR_SIMPLE_INTERFACE91
-(
-    IDENTIFIER INTEGER REFERENCES HASHTABLESTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    KEYVAL VARCHAR(100) NOT NULL,
+    SIMPINTREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE HASHTBL_STR_SIMPLE_INTERFACE92
 (
     IDENTIFIER INTEGER REFERENCES HASHTABLESTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    KEYVAL VARCHAR(100) NOT NULL,
+    SIMPINTREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE HASHTBL_STR_STRING95
 (
     IDENTIFIER INTEGER REFERENCES HASHTABLESTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    STRINGVAL VARCHAR(1024),
-    INDEX INTEGER NOT NULL
+    KEYVAL VARCHAR(100) NOT NULL,
+    STRINGVAL VARCHAR(1024)
 );
 
 CREATE TABLE HASHTBL_STR_DATE98
 (
     IDENTIFIER INTEGER REFERENCES HASHTABLESTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    DATEVAL DATE,
-    INDEX INTEGER NOT NULL
+    KEYVAL VARCHAR(100) NOT NULL,
+    DATEVAL DATE
 );
 
 CREATE TABLE HASHTBL_STR_LOCALE101
 (
     IDENTIFIER INTEGER REFERENCES HASHTABLESTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    LOCALEVAL CHAR(20),
-    INDEX INTEGER NOT NULL
+    KEYVAL VARCHAR(100) NOT NULL,
+    LOCALEVAL CHAR(20)
 );
 
 CREATE TABLE HASHTBL_STR_BIG_DECIMAL104
 (
     IDENTIFIER INTEGER REFERENCES HASHTABLESTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    BIG_DECIMALVAL DECIMAL(17,6),
-    INDEX INTEGER NOT NULL
+    KEYVAL VARCHAR(100) NOT NULL,
+    BIG_DECIMALVAL DECIMAL(17,6)
 );
 
 CREATE TABLE HASHTBL_STR_BIG_INTEGER107
 (
     IDENTIFIER INTEGER REFERENCES HASHTABLESTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    BIG_INTEGERVAL BIGINT,
-    INDEX INTEGER NOT NULL
+    KEYVAL VARCHAR(100) NOT NULL,
+    BIG_INTEGERVAL BIGINT
 );
 
 CREATE TABLE HASHTBL_STR_BYTE110
 (
     IDENTIFIER INTEGER REFERENCES HASHTABLESTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    BYTEVAL SMALLINT,
-    INDEX INTEGER NOT NULL
+    KEYVAL VARCHAR(100) NOT NULL,
+    BYTEVAL SMALLINT
 );
 
 CREATE TABLE HASHTBL_STR_DOUBLE113
 (
     IDENTIFIER INTEGER REFERENCES HASHTABLESTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    DOUBLEVAL DOUBLE,
-    INDEX INTEGER NOT NULL
+    KEYVAL VARCHAR(100) NOT NULL,
+    DOUBLEVAL DOUBLE
 );
 
 CREATE TABLE HASHTBL_STR_FLOAT116
 (
     IDENTIFIER INTEGER REFERENCES HASHTABLESTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    FLOATVAL FLOAT,
-    INDEX INTEGER NOT NULL
+    KEYVAL VARCHAR(100) NOT NULL,
+    FLOATVAL FLOAT
 );
 
 CREATE TABLE HASHTBL_STR_INTEGER119
 (
     IDENTIFIER INTEGER REFERENCES HASHTABLESTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    INTEGERVAL INTEGER,
-    INDEX INTEGER NOT NULL
+    KEYVAL VARCHAR(100) NOT NULL,
+    INTEGERVAL INTEGER
 );
 
 CREATE TABLE HASHTBL_STR_LONG122
 (
     IDENTIFIER INTEGER REFERENCES HASHTABLESTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    LONGVAL BIGINT,
-    INDEX INTEGER NOT NULL
+    KEYVAL VARCHAR(100) NOT NULL,
+    LONGVAL BIGINT
 );
 
 CREATE TABLE HASHTBL_STR_SHORT125
 (
     IDENTIFIER INTEGER REFERENCES HASHTABLESTRINGKEY_COLLECTIONS NOT NULL,
-    KEYVAL INTEGER NOT NULL,
-    SHORTVAL SMALLINT,
-    INDEX INTEGER NOT NULL
+    KEYVAL VARCHAR(100) NOT NULL,
+    SHORTVAL SMALLINT
 );
 
 --HashMapOfStringValueCollections
@@ -6036,261 +5684,188 @@
 
 CREATE TABLE HASHMAP_OBJECT0_STR (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGVALUE_COLLECTIONS NOT NULL,
-    VALUEVAL INTEGER NOT NULL,
-    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    VALUEVAL VARCHAR(100) NOT NULL,
+    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE HASHMAP_OBJECT1_STR (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGVALUE_COLLECTIONS NOT NULL,
-    VALUEVAL INTEGER NOT NULL,
-    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    VALUEVAL VARCHAR(100) NOT NULL,
+    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE HASHMAP_OBJECT2_STR (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGVALUE_COLLECTIONS NOT NULL,
-    VALUEVAL INTEGER NOT NULL,
-    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    VALUEVAL VARCHAR(100) NOT NULL,
+    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE HASHMAP_OBJECT3_STR (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGVALUE_COLLECTIONS NOT NULL,
-    VALUEVAL INTEGER NOT NULL,
-    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    VALUEVAL VARCHAR(100) NOT NULL,
+    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE HASHMAP_OBJECT4_STR (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGVALUE_COLLECTIONS NOT NULL,
-    VALUEVAL INTEGER NOT NULL,
-    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
-);
-
-CREATE TABLE HASHMAP_OBJECT5_STR (
-    IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGVALUE_COLLECTIONS NOT NULL,
-    VALUEVAL INTEGER NOT NULL,
-    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    VALUEVAL VARCHAR(100) NOT NULL,
+    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE HASHMAP_OBJECT6_STR (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGVALUE_COLLECTIONS NOT NULL,
-    VALUEVAL INTEGER NOT NULL,
-    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
-);
-
-CREATE TABLE HASHMAP_OBJECT7_STR (
-    IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGVALUE_COLLECTIONS NOT NULL,
-    VALUEVAL INTEGER NOT NULL,
-    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    VALUEVAL VARCHAR(100) NOT NULL,
+    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE HASHMAP_OBJECT8_STR (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGVALUE_COLLECTIONS NOT NULL,
-    VALUEVAL INTEGER NOT NULL,
-    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    VALUEVAL VARCHAR(100) NOT NULL,
+    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE HASHMAP_SIMPLE_CLASS9_STR (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGVALUE_COLLECTIONS NOT NULL,
-    VALUEVAL INTEGER NOT NULL,
-    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    VALUEVAL VARCHAR(100) NOT NULL,
+    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE HASHMAP_SIMPLE_CLASS10_STR (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGVALUE_COLLECTIONS NOT NULL,
-    VALUEVAL INTEGER NOT NULL,
-    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    VALUEVAL VARCHAR(100) NOT NULL,
+    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE HASHMAP_SIMPLE_CLASS11_STR (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGVALUE_COLLECTIONS NOT NULL,
-    VALUEVAL INTEGER NOT NULL,
-    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    VALUEVAL VARCHAR(100) NOT NULL,
+    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE HASHMAP_SIMPLE_CLASS12_STR (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGVALUE_COLLECTIONS NOT NULL,
-    VALUEVAL INTEGER NOT NULL,
-    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    VALUEVAL VARCHAR(100) NOT NULL,
+    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE HASHMAP_SIMPLE_CLASS13_STR (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGVALUE_COLLECTIONS NOT NULL,
-    VALUEVAL INTEGER NOT NULL,
-    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
-);
-
-CREATE TABLE HASHMAP_SIMPLE_CLASS14_STR (
-    IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGVALUE_COLLECTIONS NOT NULL,
-    VALUEVAL INTEGER NOT NULL,
-    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    VALUEVAL VARCHAR(100) NOT NULL,
+    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE HASHMAP_SIMPLE_CLASS15_STR (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGVALUE_COLLECTIONS NOT NULL,
-    VALUEVAL INTEGER NOT NULL,
-    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
-);
-
-CREATE TABLE HASHMAP_SIMPLE_CLASS16_STR (
-    IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGVALUE_COLLECTIONS NOT NULL,
-    VALUEVAL INTEGER NOT NULL,
-    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    VALUEVAL VARCHAR(100) NOT NULL,
+    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE HASHMAP_SIMPLE_CLASS17_STR (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGVALUE_COLLECTIONS NOT NULL,
-    VALUEVAL INTEGER NOT NULL,
-    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    VALUEVAL VARCHAR(100) NOT NULL,
+    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE HASHMAP_SIMPLE_INTERFACE18_STR (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGVALUE_COLLECTIONS NOT NULL,
-    VALUEVAL INTEGER NOT NULL,
-    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    VALUEVAL VARCHAR(100) NOT NULL,
+    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE HASHMAP_SIMPLE_INTERFACE19_STR (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGVALUE_COLLECTIONS NOT NULL,
-    VALUEVAL INTEGER NOT NULL,
-    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    VALUEVAL VARCHAR(100) NOT NULL,
+    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE HASHMAP_SIMPLE_INTERFACE20_STR (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGVALUE_COLLECTIONS NOT NULL,
-    VALUEVAL INTEGER NOT NULL,
-    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    VALUEVAL VARCHAR(100) NOT NULL,
+    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE HASHMAP_SIMPLE_INTERFACE21_STR (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGVALUE_COLLECTIONS NOT NULL,
-    VALUEVAL INTEGER NOT NULL,
-    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    VALUEVAL VARCHAR(100) NOT NULL,
+    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE HASHMAP_SIMPLE_INTERFACE22_STR (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGVALUE_COLLECTIONS NOT NULL,
-    VALUEVAL INTEGER NOT NULL,
-    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
-);
-
-CREATE TABLE HASHMAP_SIMPLE_INTERFACE23_STR (
-    IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGVALUE_COLLECTIONS NOT NULL,
-    VALUEVAL INTEGER NOT NULL,
-    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    VALUEVAL VARCHAR(100) NOT NULL,
+    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE HASHMAP_SIMPLE_INTERFACE24_STR (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGVALUE_COLLECTIONS NOT NULL,
-    VALUEVAL INTEGER NOT NULL,
-    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
-);
-
-CREATE TABLE HASHMAP_SIMPLE_INTERFACE25_STR (
-    IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGVALUE_COLLECTIONS NOT NULL,
-    VALUEVAL INTEGER NOT NULL,
-    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    VALUEVAL VARCHAR(100) NOT NULL,
+    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE HASHMAP_SIMPLE_INTERFACE26_STR (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGVALUE_COLLECTIONS NOT NULL,
-    VALUEVAL INTEGER NOT NULL,
-    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    VALUEVAL VARCHAR(100) NOT NULL,
+    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE HASHMAP_STRING35_STR (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGVALUE_COLLECTIONS NOT NULL,
-    VALUEVAL INTEGER NOT NULL,
-    KEYVAL VARCHAR(1024),
-    INDEX INTEGER NOT NULL
+    VALUEVAL VARCHAR(100) NOT NULL,
+    KEYVAL VARCHAR(1024)
 );
 
 CREATE TABLE HASHMAP_DATE44_STR (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGVALUE_COLLECTIONS NOT NULL,
-    VALUEVAL INTEGER NOT NULL,
-    KEYVAL DATE,
-    INDEX INTEGER NOT NULL
+    VALUEVAL VARCHAR(100) NOT NULL,
+    KEYVAL DATE
 );
 
 CREATE TABLE HASHMAP_BIG_DECIMAL53_STR (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGVALUE_COLLECTIONS NOT NULL,
-    VALUEVAL INTEGER NOT NULL,
-    KEYVAL DECIMAL(17,6),
-    INDEX INTEGER NOT NULL
+    VALUEVAL VARCHAR(100) NOT NULL,
+    KEYVAL DECIMAL(17,6)
 );
 
 CREATE TABLE HASHMAP_BIG_INTEGER62_STR (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGVALUE_COLLECTIONS NOT NULL,
-    VALUEVAL INTEGER NOT NULL,
-    KEYVAL BIGINT,
-    INDEX INTEGER NOT NULL
+    VALUEVAL VARCHAR(100) NOT NULL,
+    KEYVAL BIGINT
 );
 
 CREATE TABLE HASHMAP_BYTE71_STR (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGVALUE_COLLECTIONS NOT NULL,
-    VALUEVAL INTEGER NOT NULL,
-    KEYVAL SMALLINT,
-    INDEX INTEGER NOT NULL
+    VALUEVAL VARCHAR(100) NOT NULL,
+    KEYVAL SMALLINT
 );
 
 CREATE TABLE HASHMAP_DOUBLE80_STR (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGVALUE_COLLECTIONS NOT NULL,
-    VALUEVAL INTEGER NOT NULL,
-    KEYVAL DOUBLE,
-    INDEX INTEGER NOT NULL
+    VALUEVAL VARCHAR(100) NOT NULL,
+    KEYVAL DOUBLE
 );
 
 CREATE TABLE HASHMAP_FLOAT89_STR (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGVALUE_COLLECTIONS NOT NULL,
-    VALUEVAL INTEGER NOT NULL,
-    KEYVAL FLOAT,
-    INDEX INTEGER NOT NULL
+    VALUEVAL VARCHAR(100) NOT NULL,
+    KEYVAL FLOAT
 );
 
 CREATE TABLE HASHMAP_INTEGER98_STR (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGVALUE_COLLECTIONS NOT NULL,
-    VALUEVAL INTEGER NOT NULL,
-    KEYVAL INTEGER,
-    INDEX INTEGER NOT NULL
+    VALUEVAL VARCHAR(100) NOT NULL,
+    KEYVAL INTEGER
 );
 
 CREATE TABLE HASHMAP_LONG107_STR (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGVALUE_COLLECTIONS NOT NULL,
-    VALUEVAL INTEGER NOT NULL,
-    KEYVAL BIGINT,
-    INDEX INTEGER NOT NULL
+    VALUEVAL VARCHAR(100) NOT NULL,
+    KEYVAL BIGINT
 );
 
 CREATE TABLE HASHMAP_SHORT116_STR (
     IDENTIFIER INTEGER REFERENCES HASHMAPSTRINGVALUE_COLLECTIONS NOT NULL,
-    VALUEVAL INTEGER NOT NULL,
-    KEYVAL SMALLINT,
-    INDEX INTEGER NOT NULL
+    VALUEVAL VARCHAR(100) NOT NULL,
+    KEYVAL SMALLINT
 );
 
 --HashtableOfStringValueCollections
@@ -6383,261 +5958,200 @@
 
 CREATE TABLE HASHTBL_OBJECT0_STR (
     IDENTIFIER INTEGER REFERENCES HASHTBLSTRINGVALUE_COLLECTIONS NOT NULL,
-    VALUEVAL INTEGER NOT NULL,
-    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    VALUEVAL VARCHAR(100) NOT NULL,
+    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE HASHTBL_OBJECT1_STR (
     IDENTIFIER INTEGER REFERENCES HASHTBLSTRINGVALUE_COLLECTIONS NOT NULL,
-    VALUEVAL INTEGER NOT NULL,
-    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    VALUEVAL VARCHAR(100) NOT NULL,
+    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE HASHTBL_OBJECT2_STR (
     IDENTIFIER INTEGER REFERENCES HASHTBLSTRINGVALUE_COLLECTIONS NOT NULL,
-    VALUEVAL INTEGER NOT NULL,
-    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    VALUEVAL VARCHAR(100) NOT NULL,
+    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE HASHTBL_OBJECT3_STR (
     IDENTIFIER INTEGER REFERENCES HASHTBLSTRINGVALUE_COLLECTIONS NOT NULL,
-    VALUEVAL INTEGER NOT NULL,
-    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    VALUEVAL VARCHAR(100) NOT NULL,
+    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE HASHTBL_OBJECT4_STR (
     IDENTIFIER INTEGER REFERENCES HASHTBLSTRINGVALUE_COLLECTIONS NOT NULL,
-    VALUEVAL INTEGER NOT NULL,
-    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    VALUEVAL VARCHAR(100) NOT NULL,
+    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE HASHTBL_OBJECT5_STR (
     IDENTIFIER INTEGER REFERENCES HASHTBLSTRINGVALUE_COLLECTIONS NOT NULL,
-    VALUEVAL INTEGER NOT NULL,
-    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    VALUEVAL VARCHAR(100) NOT NULL,
+    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE HASHTBL_OBJECT6_STR (
     IDENTIFIER INTEGER REFERENCES HASHTBLSTRINGVALUE_COLLECTIONS NOT NULL,
-    VALUEVAL INTEGER NOT NULL,
-    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
-);
-
-CREATE TABLE HASHTBL_OBJECT7_STR (
-    IDENTIFIER INTEGER REFERENCES HASHTBLSTRINGVALUE_COLLECTIONS NOT NULL,
-    VALUEVAL INTEGER NOT NULL,
-    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    VALUEVAL VARCHAR(100) NOT NULL,
+    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE HASHTBL_OBJECT8_STR (
     IDENTIFIER INTEGER REFERENCES HASHTBLSTRINGVALUE_COLLECTIONS NOT NULL,
-    VALUEVAL INTEGER NOT NULL,
-    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    VALUEVAL VARCHAR(100) NOT NULL,
+    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE HASHTBL_SIMPLE_CLASS9_STR (
     IDENTIFIER INTEGER REFERENCES HASHTBLSTRINGVALUE_COLLECTIONS NOT NULL,
-    VALUEVAL INTEGER NOT NULL,
-    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    VALUEVAL VARCHAR(100) NOT NULL,
+    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE HASHTBL_SIMPLE_CLASS10_STR (
     IDENTIFIER INTEGER REFERENCES HASHTBLSTRINGVALUE_COLLECTIONS NOT NULL,
-    VALUEVAL INTEGER NOT NULL,
-    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    VALUEVAL VARCHAR(100) NOT NULL,
+    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE HASHTBL_SIMPLE_CLASS11_STR (
     IDENTIFIER INTEGER REFERENCES HASHTBLSTRINGVALUE_COLLECTIONS NOT NULL,
-    VALUEVAL INTEGER NOT NULL,
-    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    VALUEVAL VARCHAR(100) NOT NULL,
+    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE HASHTBL_SIMPLE_CLASS12_STR (
     IDENTIFIER INTEGER REFERENCES HASHTBLSTRINGVALUE_COLLECTIONS NOT NULL,
-    VALUEVAL INTEGER NOT NULL,
-    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    VALUEVAL VARCHAR(100) NOT NULL,
+    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE HASHTBL_SIMPLE_CLASS13_STR (
     IDENTIFIER INTEGER REFERENCES HASHTBLSTRINGVALUE_COLLECTIONS NOT NULL,
-    VALUEVAL INTEGER NOT NULL,
-    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
-);
-
-CREATE TABLE HASHTBL_SIMPLE_CLASS14_STR (
-    IDENTIFIER INTEGER REFERENCES HASHTBLSTRINGVALUE_COLLECTIONS NOT NULL,
-    VALUEVAL INTEGER NOT NULL,
-    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    VALUEVAL VARCHAR(100) NOT NULL,
+    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE HASHTBL_SIMPLE_CLASS15_STR (
     IDENTIFIER INTEGER REFERENCES HASHTBLSTRINGVALUE_COLLECTIONS NOT NULL,
-    VALUEVAL INTEGER NOT NULL,
-    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
-);
-
-CREATE TABLE HASHTBL_SIMPLE_CLASS16_STR (
-    IDENTIFIER INTEGER REFERENCES HASHTBLSTRINGVALUE_COLLECTIONS NOT NULL,
-    VALUEVAL INTEGER NOT NULL,
-    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    VALUEVAL VARCHAR(100) NOT NULL,
+    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE HASHTBL_SIMPLE_CLASS17_STR (
     IDENTIFIER INTEGER REFERENCES HASHTBLSTRINGVALUE_COLLECTIONS NOT NULL,
-    VALUEVAL INTEGER NOT NULL,
-    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    VALUEVAL VARCHAR(100) NOT NULL,
+    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE HASHTBL_SIMPLE_INTERFACE18_STR (
     IDENTIFIER INTEGER REFERENCES HASHTBLSTRINGVALUE_COLLECTIONS NOT NULL,
-    VALUEVAL INTEGER NOT NULL,
-    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    VALUEVAL VARCHAR(100) NOT NULL,
+    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE HASHTBL_SIMPLE_INTERFACE19_STR (
     IDENTIFIER INTEGER REFERENCES HASHTBLSTRINGVALUE_COLLECTIONS NOT NULL,
-    VALUEVAL INTEGER NOT NULL,
-    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    VALUEVAL VARCHAR(100) NOT NULL,
+    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE HASHTBL_SIMPLE_INTERFACE20_STR (
     IDENTIFIER INTEGER REFERENCES HASHTBLSTRINGVALUE_COLLECTIONS NOT NULL,
-    VALUEVAL INTEGER NOT NULL,
-    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    VALUEVAL VARCHAR(100) NOT NULL,
+    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE HASHTBL_SIMPLE_INTERFACE21_STR (
     IDENTIFIER INTEGER REFERENCES HASHTBLSTRINGVALUE_COLLECTIONS NOT NULL,
-    VALUEVAL INTEGER NOT NULL,
-    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    VALUEVAL VARCHAR(100) NOT NULL,
+    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE HASHTBL_SIMPLE_INTERFACE22_STR (
     IDENTIFIER INTEGER REFERENCES HASHTBLSTRINGVALUE_COLLECTIONS NOT NULL,
-    VALUEVAL INTEGER NOT NULL,
-    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    VALUEVAL VARCHAR(100) NOT NULL,
+    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE HASHTBL_SIMPLE_INTERFACE23_STR (
     IDENTIFIER INTEGER REFERENCES HASHTBLSTRINGVALUE_COLLECTIONS NOT NULL,
-    VALUEVAL INTEGER NOT NULL,
-    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    VALUEVAL VARCHAR(100) NOT NULL,
+    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE HASHTBL_SIMPLE_INTERFACE24_STR (
     IDENTIFIER INTEGER REFERENCES HASHTBLSTRINGVALUE_COLLECTIONS NOT NULL,
-    VALUEVAL INTEGER NOT NULL,
-    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
-);
-
-CREATE TABLE HASHTBL_SIMPLE_INTERFACE25_STR (
-    IDENTIFIER INTEGER REFERENCES HASHTBLSTRINGVALUE_COLLECTIONS NOT NULL,
-    VALUEVAL INTEGER NOT NULL,
-    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    VALUEVAL VARCHAR(100) NOT NULL,
+    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE HASHTBL_SIMPLE_INTERFACE26_STR (
     IDENTIFIER INTEGER REFERENCES HASHTBLSTRINGVALUE_COLLECTIONS NOT NULL,
-    VALUEVAL INTEGER NOT NULL,
-    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
+    VALUEVAL VARCHAR(100) NOT NULL,
+    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
 );
 
 CREATE TABLE HASHTBL_STRING35_STR (
     IDENTIFIER INTEGER REFERENCES HASHTBLSTRINGVALUE_COLLECTIONS NOT NULL,
-    VALUEVAL INTEGER NOT NULL,
-    KEYVAL VARCHAR(1024),
-    INDEX INTEGER NOT NULL
+    VALUEVAL VARCHAR(100) NOT NULL,
+    KEYVAL VARCHAR(1024)
 );
 
 CREATE TABLE HASHTBL_DATE44_STR (
     IDENTIFIER INTEGER REFERENCES HASHTBLSTRINGVALUE_COLLECTIONS NOT NULL,
-    VALUEVAL INTEGER NOT NULL,
-    KEYVAL DATE,
-    INDEX INTEGER NOT NULL
+    VALUEVAL VARCHAR(100) NOT NULL,
+    KEYVAL DATE
 );
 
 CREATE TABLE HASHTBL_BIG_DECIMAL53_STR (
     IDENTIFIER INTEGER REFERENCES HASHTBLSTRINGVALUE_COLLECTIONS NOT NULL,
-    VALUEVAL INTEGER NOT NULL,
-    KEYVAL DECIMAL(17,6),
-    INDEX INTEGER NOT NULL
+    VALUEVAL VARCHAR(100) NOT NULL,
+    KEYVAL DECIMAL(17,6)
 );
 
 CREATE TABLE HASHTBL_BIG_INTEGER62_STR (
     IDENTIFIER INTEGER REFERENCES HASHTBLSTRINGVALUE_COLLECTIONS NOT NULL,
-    VALUEVAL INTEGER NOT NULL,
-    KEYVAL BIGINT,
-    INDEX INTEGER NOT NULL
+    VALUEVAL VARCHAR(100) NOT NULL,
+    KEYVAL BIGINT
 );
 
 CREATE TABLE HASHTBL_BYTE71_STR (
     IDENTIFIER INTEGER REFERENCES HASHTBLSTRINGVALUE_COLLECTIONS NOT NULL,
-    VALUEVAL INTEGER NOT NULL,
-    KEYVAL SMALLINT,
-    INDEX INTEGER NOT NULL
+    VALUEVAL VARCHAR(100) NOT NULL,
+    KEYVAL SMALLINT
 );
 
 CREATE TABLE HASHTBL_DOUBLE80_STR (
     IDENTIFIER INTEGER REFERENCES HASHTBLSTRINGVALUE_COLLECTIONS NOT NULL,
-    VALUEVAL INTEGER NOT NULL,
-    KEYVAL DOUBLE,
-    INDEX INTEGER NOT NULL
+    VALUEVAL VARCHAR(100) NOT NULL,
+    KEYVAL DOUBLE
 );
 
 CREATE TABLE HASHTBL_FLOAT89_STR (
     IDENTIFIER INTEGER REFERENCES HASHTBLSTRINGVALUE_COLLECTIONS NOT NULL,
-    VALUEVAL INTEGER NOT NULL,
-    KEYVAL FLOAT,
-    INDEX INTEGER NOT NULL
+    VALUEVAL VARCHAR(100) NOT NULL,
+    KEYVAL FLOAT
 );
 
 CREATE TABLE HASHTBL_INTEGER98_STR (
     IDENTIFIER INTEGER REFERENCES HASHTBLSTRINGVALUE_COLLECTIONS NOT NULL,
-    VALUEVAL INTEGER NOT NULL,
-    KEYVAL INTEGER,
-    INDEX INTEGER NOT NULL
+    VALUEVAL VARCHAR(100) NOT NULL,
+    KEYVAL INTEGER
 );
 
 CREATE TABLE HASHTBL_LONG107_STR (
     IDENTIFIER INTEGER REFERENCES HASHTBLSTRINGVALUE_COLLECTIONS NOT NULL,
-    VALUEVAL INTEGER NOT NULL,
-    KEYVAL BIGINT,
-    INDEX INTEGER NOT NULL
+    VALUEVAL VARCHAR(100) NOT NULL,
+    KEYVAL BIGINT
 );
 
 CREATE TABLE HASHTBL_SHORT116_STR (
     IDENTIFIER INTEGER REFERENCES HASHTBLSTRINGVALUE_COLLECTIONS NOT NULL,
-    VALUEVAL INTEGER NOT NULL,
-    KEYVAL SMALLINT,
-    INDEX INTEGER NOT NULL
+    VALUEVAL VARCHAR(100) NOT NULL,
+    KEYVAL SMALLINT
 );
 
 --TreeMapOfStringValueCollections
@@ -6730,260 +6244,218 @@
 
 CREATE TABLE TREEMAP_OBJECT0_STR (
     IDENTIFIER INTEGER REFERENCES TREEMAPSTRINGVALUE_COLLECTIONS NOT NULL,
-    VALUEVAL INTEGER NOT NULL,
+    VALUEVAL VARCHAR(100) NOT NULL,
     KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
     INDEX INTEGER NOT NULL
 );
 
 CREATE TABLE TREEMAP_OBJECT1_STR (
     IDENTIFIER INTEGER REFERENCES TREEMAPSTRINGVALUE_COLLECTIONS NOT NULL,
-    VALUEVAL INTEGER NOT NULL,
+    VALUEVAL VARCHAR(100) NOT NULL,
     KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
     INDEX INTEGER NOT NULL
 );
 
 CREATE TABLE TREEMAP_OBJECT2_STR (
     IDENTIFIER INTEGER REFERENCES TREEMAPSTRINGVALUE_COLLECTIONS NOT NULL,
-    VALUEVAL INTEGER NOT NULL,
+    VALUEVAL VARCHAR(100) NOT NULL,
     KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
     INDEX INTEGER NOT NULL
 );
 
 CREATE TABLE TREEMAP_OBJECT3_STR (
     IDENTIFIER INTEGER REFERENCES TREEMAPSTRINGVALUE_COLLECTIONS NOT NULL,
-    VALUEVAL INTEGER NOT NULL,
+    VALUEVAL VARCHAR(100) NOT NULL,
     KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
     INDEX INTEGER NOT NULL
 );
 
 CREATE TABLE TREEMAP_OBJECT4_STR (
     IDENTIFIER INTEGER REFERENCES TREEMAPSTRINGVALUE_COLLECTIONS NOT NULL,
-    VALUEVAL INTEGER NOT NULL,
-    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
-);
-
-CREATE TABLE TREEMAP_OBJECT5_STR (
-    IDENTIFIER INTEGER REFERENCES TREEMAPSTRINGVALUE_COLLECTIONS NOT NULL,
-    VALUEVAL INTEGER NOT NULL,
+    VALUEVAL VARCHAR(100) NOT NULL,
     KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
     INDEX INTEGER NOT NULL
 );
 
 CREATE TABLE TREEMAP_OBJECT6_STR (
     IDENTIFIER INTEGER REFERENCES TREEMAPSTRINGVALUE_COLLECTIONS NOT NULL,
-    VALUEVAL INTEGER NOT NULL,
-    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
-    INDEX INTEGER NOT NULL
-);
-
-CREATE TABLE TREEMAP_OBJECT7_STR (
-    IDENTIFIER INTEGER REFERENCES TREEMAPSTRINGVALUE_COLLECTIONS NOT NULL,
-    VALUEVAL INTEGER NOT NULL,
+    VALUEVAL VARCHAR(100) NOT NULL,
     KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
     INDEX INTEGER NOT NULL
 );
 
 CREATE TABLE TREEMAP_OBJECT8_STR (
     IDENTIFIER INTEGER REFERENCES TREEMAPSTRINGVALUE_COLLECTIONS NOT NULL,
-    VALUEVAL INTEGER NOT NULL,
+    VALUEVAL VARCHAR(100) NOT NULL,
     KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
     INDEX INTEGER NOT NULL
 );
 
 CREATE TABLE TREEMAP_SIMPLE_CLASS9_STR (
     IDENTIFIER INTEGER REFERENCES TREEMAPSTRINGVALUE_COLLECTIONS NOT NULL,
-    VALUEVAL INTEGER NOT NULL,
-    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
+    VALUEVAL VARCHAR(100) NOT NULL,
+    SIMPCLSREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
     INDEX INTEGER NOT NULL
 );
 
 CREATE TABLE TREEMAP_SIMPLE_CLASS10_STR (
     IDENTIFIER INTEGER REFERENCES TREEMAPSTRINGVALUE_COLLECTIONS NOT NULL,
-    VALUEVAL INTEGER NOT NULL,
-    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
+    VALUEVAL VARCHAR(100) NOT NULL,
+    SIMPCLSREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
     INDEX INTEGER NOT NULL
 );
 
 CREATE TABLE TREEMAP_SIMPLE_CLASS11_STR (
     IDENTIFIER INTEGER REFERENCES TREEMAPSTRINGVALUE_COLLECTIONS NOT NULL,
-    VALUEVAL INTEGER NOT NULL,
-    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
+    VALUEVAL VARCHAR(100) NOT NULL,
+    SIMPCLSREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
     INDEX INTEGER NOT NULL
 );
 
 CREATE TABLE TREEMAP_SIMPLE_CLASS12_STR (
     IDENTIFIER INTEGER REFERENCES TREEMAPSTRINGVALUE_COLLECTIONS NOT NULL,
-    VALUEVAL INTEGER NOT NULL,
-    KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL,
+    VALUEVAL VARCHAR(100) NOT NULL,

[... 888 lines stripped ...]


Mime
View raw message