db-jdo-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From mcai...@apache.org
Subject svn commit: r193203 [2/5] - in /incubator/jdo/trunk/tck20: ./ test/conf/ test/java/org/apache/jdo/tck/ test/java/org/apache/jdo/tck/util/ test/sql/derby/ test/sql/derby/applicationidentity/ test/sql/derby/datastoreidentity/ test/testdata/applicationide...
Date Thu, 23 Jun 2005 19:16:36 GMT
Added: incubator/jdo/trunk/tck20/test/sql/derby/applicationidentity/schema.sql
URL: http://svn.apache.org/viewcvs/incubator/jdo/trunk/tck20/test/sql/derby/applicationidentity/schema.sql?rev=193203&view=auto
==============================================================================
--- incubator/jdo/trunk/tck20/test/sql/derby/applicationidentity/schema.sql (added)
+++ incubator/jdo/trunk/tck20/test/sql/derby/applicationidentity/schema.sql Thu Jun 23 12:16:32 2005
@@ -0,0 +1,7091 @@
+-- SchemaType: application identity
+
+connect 'jdbc:derby:jdotckdb;create=true' user 'tckuser' password 'tckuser';
+
+CREATE SCHEMA applicationidentity0;
+SET SCHEMA applicationidentity0;
+
+-------------------------
+-- mylib
+-------------------------
+
+DROP TABLE PCRect;
+DROP TABLE PCPoint;
+DROP TABLE PCPoint2;
+DROP TABLE PrimitiveTypes;
+
+CREATE TABLE PCPoint (
+    ID BIGINT NOT NULL,
+    X INTEGER NOT NULL,
+    Y INTEGER,
+    CONSTRAINT PCPNT_CONST PRIMARY KEY (ID)
+);
+
+CREATE TABLE PCPoint2 (
+    ID BIGINT NOT NULL,
+    X INTEGER NOT NULL,
+    Y INTEGER,
+    CONSTRAINT PCPNT2_CONST PRIMARY KEY (ID)
+);
+
+CREATE TABLE PCRect (
+    ID BIGINT NOT NULL,
+    UPPER_LEFT BIGINT REFERENCES PCPoint NOT NULL,
+    LOWER_RIGHT BIGINT REFERENCES PCPoint NOT NULL,
+    CONSTRAINT PCRCT_CONST PRIMARY KEY (ID)
+);
+
+CREATE TABLE PrimitiveTypes (
+    ID BIGINT NOT NULL,
+    booleanNotNull CHAR(1) NOT NULL CHECK (booleanNotNull IN ('Y','N')),
+    booleanNull CHAR(1) CHECK (booleanNull IN ('Y','N')),
+    byteNotNull SMALLINT NOT NULL,
+    byteNull SMALLINT,
+    shortNotNull SMALLINT NOT NULL,
+    shortNull SMALLINT,
+    intNotNull INTEGER NOT NULL,
+    intNull INTEGER,
+    longNotNull INTEGER NOT NULL,
+    longNull INTEGER,
+    floatNotNull FLOAT NOT NULL,
+    floatNull FLOAT,
+    doubleNotNull FLOAT NOT NULL,
+    doubleNull FLOAT,
+    charNotNull CHAR NOT NULL,
+    charNull CHAR,
+    dateNull DATE,
+    stringNull VARCHAR (256),
+    bigDecimal DECIMAL,
+    bigInteger INTEGER,
+    PrimitiveTypes INTEGER,
+    CONSTRAINT PT_CONST PRIMARY KEY (ID)
+);
+
+-------------------------
+-- company
+-------------------------
+
+ALTER TABLE departments DROP CONSTRAINT EMP_MO_FK;
+DROP TABLE insuranceplans;
+DROP TABLE project_reviewer;
+DROP TABLE project_member;
+DROP TABLE employee_phoneno_type;
+DROP TABLE persons;
+DROP TABLE projects;
+DROP TABLE departments;
+DROP TABLE companies;
+
+CREATE TABLE companies (
+    ID INTEGER NOT NULL,
+    NAME VARCHAR(32) NOT NULL,
+    FOUNDEDDATE VARCHAR(32) NOT NULL,
+    STREET VARCHAR(64),
+    CITY VARCHAR(64),
+    STATE CHAR(2),
+    ZIPCODE CHAR(5),
+    COUNTRY VARCHAR(64),
+    CONSTRAINT COMPS_PK PRIMARY KEY (ID)
+);
+
+CREATE TABLE departments (
+    ID INTEGER NOT NULL,
+    NAME VARCHAR(32) NOT NULL,
+    EMP_OF_THE_MONTH INTEGER,
+    COMPANYID INTEGER REFERENCES companies,
+    CONSTRAINT DEPTS_PK PRIMARY KEY (ID)
+);
+
+CREATE TABLE persons (
+    PERSONID INTEGER NOT NULL,
+    FIRSTNAME VARCHAR(32) NOT NULL,
+    LASTNAME VARCHAR(32) NOT NULL,
+    MIDDLENAME VARCHAR(32),
+    BIRTHDATE VARCHAR(32) NOT NULL,
+    STREET VARCHAR(64),
+    CITY VARCHAR(64),
+    STATE CHAR(2),
+    ZIPCODE CHAR(5),
+    COUNTRY VARCHAR(64),
+    HIREDATE VARCHAR(32),
+    WEEKLYHOURS FLOAT,
+    DEPARTMENT INTEGER REFERENCES departments,
+    FUNDINGDEPT INTEGER REFERENCES departments,
+    MANAGER INTEGER REFERENCES persons,
+    MENTOR INTEGER REFERENCES persons,
+    HRADVISOR INTEGER REFERENCES persons,
+    SALARY FLOAT,
+    WAGE FLOAT,
+    DISCRIMINATOR varchar(64) NOT NULL,
+    CONSTRAINT EMPS_PK PRIMARY KEY (PERSONID)
+);
+
+CREATE TABLE insuranceplans (
+    INSID INTEGER NOT NULL,
+    CARRIER VARCHAR(64) NOT NULL,
+    LIFETIME_ORTHO_BENEFIT DECIMAL,
+    PLANTYPE VARCHAR(8),
+    DISCRIMINATOR varchar(64) NOT NULL,
+    EMPLOYEE INTEGER REFERENCES persons,
+    CONSTRAINT INS_PK PRIMARY KEY (INSID)
+);
+
+CREATE TABLE projects (
+    PROJID INTEGER NOT NULL,
+    NAME VARCHAR(32) NOT NULL,
+    BUDGET DECIMAL(11,2) NOT NULL,
+    CONSTRAINT PROJS_PK PRIMARY KEY (PROJID)
+);
+
+CREATE TABLE project_reviewer (
+    PROJID INTEGER REFERENCES projects NOT NULL,
+    REVIEWER INTEGER REFERENCES persons NOT NULL
+);
+
+CREATE TABLE project_member (
+    PROJID INTEGER REFERENCES projects NOT NULL,
+    MEMBER INTEGER REFERENCES persons NOT NULL
+);
+
+CREATE TABLE employee_phoneno_type (
+    EMPID INTEGER REFERENCES persons NOT NULL,
+    PHONENO VARCHAR(16) NOT NULL,
+    TYPE VARCHAR(16) NOT NULL
+);
+
+ALTER TABLE departments 
+    ADD CONSTRAINT EMP_MO_FK FOREIGN KEY
+        (EMP_OF_THE_MONTH) REFERENCES persons(PERSONID)
+;
+
+-------------------------
+--fieldtypes
+-------------------------
+
+DROP TABLE ARRAY_COLLECTIONS;
+
+DROP TABLE ARRAYLIST_OF_OBJECT0;
+DROP TABLE ARRAYLIST_OF_OBJECT1;
+DROP TABLE ARRAYLIST_OF_OBJECT2;
+DROP TABLE ARRAYLIST_OF_SIMPLE_CLASS3;
+DROP TABLE ARRAYLIST_OF_SIMPLE_CLASS4;
+DROP TABLE ARRAYLIST_OF_SIMPLE_CLASS5;
+DROP TABLE ARRAYLIST_OF_SIMPLE_INTERFACE6;
+DROP TABLE ARRAYLIST_OF_SIMPLE_INTERFACE7;
+DROP TABLE ARRAYLIST_OF_SIMPLE_INTERFACE8;
+DROP TABLE ARRAYLIST_OF_STRING11;
+DROP TABLE ARRAYLIST_OF_DATE14;
+DROP TABLE ARRAYLIST_OF_LOCALE17;
+DROP TABLE ARRAYLIST_OF_BIG_DECIMAL20;
+DROP TABLE ARRAYLIST_OF_BIG_INTEGER23;
+DROP TABLE ARRAYLIST_OF_BYTE26;
+DROP TABLE ARRAYLIST_OF_DOUBLE29;
+DROP TABLE ARRAYLIST_OF_FLOAT32;
+DROP TABLE ARRAYLIST_OF_INTEGER35;
+DROP TABLE ARRAYLIST_OF_LONG38;
+DROP TABLE ARRAYLIST_OF_SHORT41;
+DROP TABLE ARRAYLIST_COLLECTIONS;
+
+DROP TABLE COLLECTION_OF_OBJECT0;
+DROP TABLE COLLECTION_OF_OBJECT1;
+DROP TABLE COLLECTION_OF_OBJECT2;
+DROP TABLE COLLECTION_OF_SIMPLE_CLASS3;
+DROP TABLE COLLECTION_OF_SIMPLE_CLASS4;
+DROP TABLE COLLECTION_OF_SIMPLE_CLASS5;
+DROP TABLE COLLECTION_OF_SIMPLE_INTERFACE6;
+DROP TABLE COLLECTION_OF_SIMPLE_INTERFACE7;
+DROP TABLE COLLECTION_OF_SIMPLE_INTERFACE8;
+DROP TABLE COLLECTION_OF_STRING11;
+DROP TABLE COLLECTION_OF_DATE14;
+DROP TABLE COLLECTION_OF_LOCALE17;
+DROP TABLE COLLECTION_OF_BIG_DECIMAL20;
+DROP TABLE COLLECTION_OF_BIG_INTEGER23;
+DROP TABLE COLLECTION_OF_BYTE26;
+DROP TABLE COLLECTION_OF_DOUBLE29;
+DROP TABLE COLLECTION_OF_FLOAT32;
+DROP TABLE COLLECTION_OF_INTEGER35;
+DROP TABLE COLLECTION_OF_LONG38;
+DROP TABLE COLLECTION_OF_SHORT41;
+DROP TABLE COLLECTION_COLLECTIONS;
+
+DROP TABLE LIST_OF_OBJECT0;
+DROP TABLE LIST_OF_OBJECT1;
+DROP TABLE LIST_OF_OBJECT2;
+DROP TABLE LIST_OF_SIMPLE_CLASS3;
+DROP TABLE LIST_OF_SIMPLE_CLASS4;
+DROP TABLE LIST_OF_SIMPLE_CLASS5;
+DROP TABLE LIST_OF_SIMPLE_INTERFACE6;
+DROP TABLE LIST_OF_SIMPLE_INTERFACE7;
+DROP TABLE LIST_OF_SIMPLE_INTERFACE8;
+DROP TABLE LIST_OF_STRING11;
+DROP TABLE LIST_OF_DATE14;
+DROP TABLE LIST_OF_LOCALE17;
+DROP TABLE LIST_OF_BIG_DECIMAL20;
+DROP TABLE LIST_OF_BIG_INTEGER23;
+DROP TABLE LIST_OF_BYTE26;
+DROP TABLE LIST_OF_DOUBLE29;
+DROP TABLE LIST_OF_FLOAT32;
+DROP TABLE LIST_OF_INTEGER35;
+DROP TABLE LIST_OF_LONG38;
+DROP TABLE LIST_OF_SHORT41;
+DROP TABLE LIST_COLLECTIONS;
+
+DROP TABLE LINKEDLIST_OF_OBJECT0;
+DROP TABLE LINKEDLIST_OF_OBJECT1;
+DROP TABLE LINKEDLIST_OF_OBJECT2;
+DROP TABLE LINKEDLIST_OF_SIMPLE_CLASS3;
+DROP TABLE LINKEDLIST_OF_SIMPLE_CLASS4;
+DROP TABLE LINKEDLIST_OF_SIMPLE_CLASS5;
+DROP TABLE LINKEDLIST_OF_SIMPLE_INTERFACE6;
+DROP TABLE LINKEDLIST_OF_SIMPLE_INTERFACE7;
+DROP TABLE LINKEDLIST_OF_SIMPLE_INTERFACE8;
+DROP TABLE LINKEDLIST_OF_STRING11;
+DROP TABLE LINKEDLIST_OF_DATE14;
+DROP TABLE LINKEDLIST_OF_LOCALE17;
+DROP TABLE LINKEDLIST_OF_BIG_DECIMAL20;
+DROP TABLE LINKEDLIST_OF_BIG_INTEGER23;
+DROP TABLE LINKEDLIST_OF_BYTE26;
+DROP TABLE LINKEDLIST_OF_DOUBLE29;
+DROP TABLE LINKEDLIST_OF_FLOAT32;
+DROP TABLE LINKEDLIST_OF_INTEGER35;
+DROP TABLE LINKEDLIST_OF_LONG38;
+DROP TABLE LINKEDLIST_OF_SHORT41;
+DROP TABLE LINKEDLIST_COLLECTIONS;
+
+DROP TABLE VECTOR_OF_OBJECT0;
+DROP TABLE VECTOR_OF_OBJECT1;
+DROP TABLE VECTOR_OF_OBJECT2;
+DROP TABLE VECTOR_OF_SIMPLE_CLASS3;
+DROP TABLE VECTOR_OF_SIMPLE_CLASS4;
+DROP TABLE VECTOR_OF_SIMPLE_CLASS5;
+DROP TABLE VECTOR_OF_SIMPLE_INTERFACE6;
+DROP TABLE VECTOR_OF_SIMPLE_INTERFACE7;
+DROP TABLE VECTOR_OF_SIMPLE_INTERFACE8;
+DROP TABLE VECTOR_OF_STRING11;
+DROP TABLE VECTOR_OF_DATE14;
+DROP TABLE VECTOR_OF_LOCALE17;
+DROP TABLE VECTOR_OF_BIG_DECIMAL20;
+DROP TABLE VECTOR_OF_BIG_INTEGER23;
+DROP TABLE VECTOR_OF_BYTE26;
+DROP TABLE VECTOR_OF_DOUBLE29;
+DROP TABLE VECTOR_OF_FLOAT32;
+DROP TABLE VECTOR_OF_INTEGER35;
+DROP TABLE VECTOR_OF_LONG38;
+DROP TABLE VECTOR_OF_SHORT41;
+DROP TABLE VECTOR_COLLECTIONS;
+
+DROP TABLE SET_OF_OBJECT0;
+DROP TABLE SET_OF_OBJECT1;
+DROP TABLE SET_OF_OBJECT2;
+DROP TABLE SET_OF_SIMPLE_CLASS3;
+DROP TABLE SET_OF_SIMPLE_CLASS4;
+DROP TABLE SET_OF_SIMPLE_CLASS5;
+DROP TABLE SET_OF_SIMPLE_INTERFACE6;
+DROP TABLE SET_OF_SIMPLE_INTERFACE7;
+DROP TABLE SET_OF_SIMPLE_INTERFACE8;
+DROP TABLE SET_OF_STRING11;
+DROP TABLE SET_OF_DATE14;
+DROP TABLE SET_OF_LOCALE17;
+DROP TABLE SET_OF_BIG_DECIMAL20;
+DROP TABLE SET_OF_BIG_INTEGER23;
+DROP TABLE SET_OF_BYTE26;
+DROP TABLE SET_OF_DOUBLE29;
+DROP TABLE SET_OF_FLOAT32;
+DROP TABLE SET_OF_INTEGER35;
+DROP TABLE SET_OF_LONG38;
+DROP TABLE SET_OF_SHORT41;
+DROP TABLE SET_COLLECTIONS;
+
+DROP TABLE HASHSET_OF_OBJECT0;
+DROP TABLE HASHSET_OF_OBJECT1;
+DROP TABLE HASHSET_OF_OBJECT2;
+DROP TABLE HASHSET_OF_SIMPLE_CLASS3;
+DROP TABLE HASHSET_OF_SIMPLE_CLASS4;
+DROP TABLE HASHSET_OF_SIMPLE_CLASS5;
+DROP TABLE HASHSET_OF_SIMPLE_INTERFACE6;
+DROP TABLE HASHSET_OF_SIMPLE_INTERFACE7;
+DROP TABLE HASHSET_OF_SIMPLE_INTERFACE8;
+DROP TABLE HASHSET_OF_STRING11;
+DROP TABLE HASHSET_OF_DATE14;
+DROP TABLE HASHSET_OF_LOCALE17;
+DROP TABLE HASHSET_OF_BIG_DECIMAL20;
+DROP TABLE HASHSET_OF_BIG_INTEGER23;
+DROP TABLE HASHSET_OF_BYTE26;
+DROP TABLE HASHSET_OF_DOUBLE29;
+DROP TABLE HASHSET_OF_FLOAT32;
+DROP TABLE HASHSET_OF_INTEGER35;
+DROP TABLE HASHSET_OF_LONG38;
+DROP TABLE HASHSET_OF_SHORT41;
+DROP TABLE HASHSET_COLLECTIONS;
+
+DROP TABLE TREESET_OF_OBJECT0;
+DROP TABLE TREESET_OF_OBJECT1;
+DROP TABLE TREESET_OF_OBJECT2;
+DROP TABLE TREESET_OF_SIMPLE_CLASS3;
+DROP TABLE TREESET_OF_SIMPLE_CLASS4;
+DROP TABLE TREESET_OF_SIMPLE_CLASS5;
+DROP TABLE TREESET_OF_SIMPLE_INTERFACE6;
+DROP TABLE TREESET_OF_SIMPLE_INTERFACE7;
+DROP TABLE TREESET_OF_SIMPLE_INTERFACE8;
+DROP TABLE TREESET_OF_STRING11;
+DROP TABLE TREESET_OF_DATE14;
+DROP TABLE TREESET_OF_BIG_DECIMAL17;
+DROP TABLE TREESET_OF_BIG_INTEGER20;
+DROP TABLE TREESET_OF_BYTE23;
+DROP TABLE TREESET_OF_DOUBLE26;
+DROP TABLE TREESET_OF_FLOAT29;
+DROP TABLE TREESET_OF_INTEGER32;
+DROP TABLE TREESET_OF_LONG35;
+DROP TABLE TREESET_OF_SHORT38;
+DROP TABLE TREESET_COLLECTIONS;
+
+DROP TABLE MAP_OF_STRING_OBJECT0;
+DROP TABLE MAP_OF_STRING_OBJECT1;
+DROP TABLE MAP_OF_STRING_OBJECT2;
+DROP TABLE MAP_OF_STRING_SIMPLE_CLASS3;
+DROP TABLE MAP_OF_STRING_SIMPLE_CLASS4;
+DROP TABLE MAP_OF_STRING_SIMPLE_CLASS5;
+DROP TABLE MAP_OF_STRING_SIMPLE_INTERFACE6;
+DROP TABLE MAP_OF_STRING_SIMPLE_INTERFACE7;
+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;
+DROP TABLE MAP_OF_STRING_LOCALE101;
+DROP TABLE MAP_OF_STRING_BIG_DECIMAL104;
+DROP TABLE MAP_OF_STRING_BIG_INTEGER107;
+DROP TABLE MAP_OF_STRING_BYTE110;
+DROP TABLE MAP_OF_STRING_DOUBLE113;
+DROP TABLE MAP_OF_STRING_FLOAT116;
+DROP TABLE MAP_OF_STRING_INTEGER119;
+DROP TABLE MAP_OF_STRING_LONG122;
+DROP TABLE MAP_OF_STRING_SHORT125;
+DROP TABLE MAPSTRINGKEY_COLLECTIONS;
+
+DROP TABLE HASHMAP_STR_OBJECT0;
+DROP TABLE HASHMAP_STR_OBJECT1;
+DROP TABLE HASHMAP_STR_OBJECT2;
+DROP TABLE HASHMAP_STR_SIMPLE_CLASS3;
+DROP TABLE HASHMAP_STR_SIMPLE_CLASS4;
+DROP TABLE HASHMAP_STR_SIMPLE_CLASS5;
+DROP TABLE HASHMAP_STR_SIMPLE_INTERFACE6;
+DROP TABLE HASHMAP_STR_SIMPLE_INTERFACE7;
+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;
+DROP TABLE HASHMAP_STR_LOCALE101;
+DROP TABLE HASHMAP_STR_BIG_DECIMAL104;
+DROP TABLE HASHMAP_STR_BIG_INTEGER107;
+DROP TABLE HASHMAP_STR_BYTE110;
+DROP TABLE HASHMAP_STR_DOUBLE113;
+DROP TABLE HASHMAP_STR_FLOAT116;
+DROP TABLE HASHMAP_STR_INTEGER119;
+DROP TABLE HASHMAP_STR_LONG122;
+DROP TABLE HASHMAP_STR_SHORT125;
+DROP TABLE HASHMAPSTRINGKEY_COLLECTIONS;
+
+DROP TABLE MAP_OF_OBJECT0_STRING;
+DROP TABLE MAP_OF_OBJECT1_STRING;
+DROP TABLE MAP_OF_OBJECT2_STRING;
+DROP TABLE MAP_OF_OBJECT3_STRING;
+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;
+DROP TABLE MAP_OF_BIG_DECIMAL53_STRING;
+DROP TABLE MAP_OF_BIG_INTEGER62_STRING;
+DROP TABLE MAP_OF_BYTE71_STRING;
+DROP TABLE MAP_OF_DOUBLE80_STRING;
+DROP TABLE MAP_OF_FLOAT89_STRING;
+DROP TABLE MAP_OF_INTEGER98_STRING;
+DROP TABLE MAP_OF_LONG107_STRING;
+DROP TABLE MAP_OF_SHORT116_STRING;
+DROP TABLE MAPSTRINGVALUE_COLLECTIONS;
+
+DROP TABLE HASHTBL_STR_OBJECT0;
+DROP TABLE HASHTBL_STR_OBJECT1;
+DROP TABLE HASHTBL_STR_OBJECT2;
+DROP TABLE HASHTBL_STR_SIMPLE_CLASS3;
+DROP TABLE HASHTBL_STR_SIMPLE_CLASS4;
+DROP TABLE HASHTBL_STR_SIMPLE_CLASS5;
+DROP TABLE HASHTBL_STR_SIMPLE_INTERFACE6;
+DROP TABLE HASHTBL_STR_SIMPLE_INTERFACE7;
+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;
+DROP TABLE HASHTBL_STR_LOCALE101;
+DROP TABLE HASHTBL_STR_BIG_DECIMAL104;
+DROP TABLE HASHTBL_STR_BIG_INTEGER107;
+DROP TABLE HASHTBL_STR_BYTE110;
+DROP TABLE HASHTBL_STR_DOUBLE113;
+DROP TABLE HASHTBL_STR_FLOAT116;
+DROP TABLE HASHTBL_STR_INTEGER119;
+DROP TABLE HASHTBL_STR_LONG122;
+DROP TABLE HASHTBL_STR_SHORT125;
+DROP TABLE HASHTABLESTRINGKEY_COLLECTIONS;
+
+DROP TABLE TREEMAP_STR_OBJECT0;
+DROP TABLE TREEMAP_STR_OBJECT1;
+DROP TABLE TREEMAP_STR_OBJECT2;
+DROP TABLE TREEMAP_STR_SIMPLE_CLASS3;
+DROP TABLE TREEMAP_STR_SIMPLE_CLASS4;
+DROP TABLE TREEMAP_STR_SIMPLE_CLASS5;
+DROP TABLE TREEMAP_STR_SIMPLE_INTERFACE6;
+DROP TABLE TREEMAP_STR_SIMPLE_INTERFACE7;
+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;
+DROP TABLE TREEMAP_STR_LOCALE101;
+DROP TABLE TREEMAP_STR_BIG_DECIMAL104;
+DROP TABLE TREEMAP_STR_BIG_INTEGER107;
+DROP TABLE TREEMAP_STR_BYTE110;
+DROP TABLE TREEMAP_STR_DOUBLE113;
+DROP TABLE TREEMAP_STR_FLOAT116;
+DROP TABLE TREEMAP_STR_INTEGER119;
+DROP TABLE TREEMAP_STR_LONG122;
+DROP TABLE TREEMAP_STR_SHORT125;
+DROP TABLE TREEMAPSTRINGKEY_COLLECTIONS;
+
+DROP TABLE HASHMAP_OBJECT0_STR;
+DROP TABLE HASHMAP_OBJECT1_STR;
+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;
+DROP TABLE HASHMAP_BIG_DECIMAL53_STR;
+DROP TABLE HASHMAP_BIG_INTEGER62_STR;
+DROP TABLE HASHMAP_BYTE71_STR;
+DROP TABLE HASHMAP_DOUBLE80_STR;
+DROP TABLE HASHMAP_FLOAT89_STR;
+DROP TABLE HASHMAP_INTEGER98_STR;
+DROP TABLE HASHMAP_LONG107_STR;
+DROP TABLE HASHMAP_SHORT116_STR;
+DROP TABLE HASHMAPSTRINGVALUE_COLLECTIONS;
+
+DROP TABLE HASHTBL_OBJECT0_STR;
+DROP TABLE HASHTBL_OBJECT1_STR;
+DROP TABLE HASHTBL_OBJECT2_STR;
+DROP TABLE HASHTBL_OBJECT3_STR;
+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;
+DROP TABLE HASHTBL_SIMPLE_INTERFACE20_STR;
+DROP TABLE HASHTBL_SIMPLE_INTERFACE21_STR;
+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;
+DROP TABLE HASHTBL_BIG_DECIMAL53_STR;
+DROP TABLE HASHTBL_BIG_INTEGER62_STR;
+DROP TABLE HASHTBL_BYTE71_STR;
+DROP TABLE HASHTBL_DOUBLE80_STR;
+DROP TABLE HASHTBL_FLOAT89_STR;
+DROP TABLE HASHTBL_INTEGER98_STR;
+DROP TABLE HASHTBL_LONG107_STR;
+DROP TABLE HASHTBL_SHORT116_STR;
+DROP TABLE HASHTBLSTRINGVALUE_COLLECTIONS;
+
+DROP TABLE TREEMAP_OBJECT0_STR;
+DROP TABLE TREEMAP_OBJECT1_STR;
+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;
+DROP TABLE TREEMAP_BIG_DECIMAL53_STR;
+DROP TABLE TREEMAP_BIG_INTEGER62_STR;
+DROP TABLE TREEMAP_BYTE71_STR;
+DROP TABLE TREEMAP_DOUBLE80_STR;
+DROP TABLE TREEMAP_FLOAT89_STR;
+DROP TABLE TREEMAP_INTEGER98_STR;
+DROP TABLE TREEMAP_LONG107_STR;
+DROP TABLE TREEMAP_SHORT116_STR;
+DROP TABLE TREEMAPSTRINGVALUE_COLLECTIONS;
+
+DROP TABLE FIELDSOFSIMPLECLASS;
+DROP TABLE ALLTYPES;
+DROP TABLE FIELDSOFBYTE;
+DROP TABLE FIELDSOFBIGDECIMAL;
+DROP TABLE FIELDSOFBIGINTEGER;
+DROP TABLE FIELDSOFBOOLEAN;
+DROP TABLE FIELDSOFCHARACTER;
+DROP TABLE FIELDSOFDATE;
+DROP TABLE FIELDSOFDOUBLE;
+DROP TABLE FIELDSOFFLOAT;
+DROP TABLE FIELDSOFINTEGER;
+DROP TABLE FIELDSOFLOCALE;
+DROP TABLE FIELDSOFLONG;
+DROP TABLE FIELDSOFOBJECT;
+DROP TABLE FIELDSOFSIMPLEINTERFACE;
+DROP TABLE FIELDSOFPRIMITIVEBOOLEAN;
+DROP TABLE FIELDSOFPRIMITIVEBYTE;
+DROP TABLE FIELDSOFPRIMITIVECHAR;
+DROP TABLE FIELDSOFPRIMITIVEDOUBLE;
+DROP TABLE FIELDSOFPRIMITIVEFLOAT;
+DROP TABLE FIELDSOFPRIMITIVEINT;
+DROP TABLE FIELDSOFPRIMITIVELONG;
+DROP TABLE FIELDSOFPRIMITIVESHORT;
+DROP TABLE FIELDSOFSHORT;
+DROP TABLE FIELDSOFSTRING;
+
+DROP TABLE SIMPLE_CLASS;
+
+CREATE TABLE ALLTYPES
+(
+    ID INTEGER NOT NULL,
+    PRIMITIVEBOOLEAN CHAR(1) CHECK (PRIMITIVEBOOLEAN IN ('Y','N')),
+    PRIMITIVEBYTE SMALLINT,
+    PRIMITIVECHAR INTEGER,
+    PRIMITIVEDOUBLE DOUBLE,
+    PRIMITIVEFLOAT FLOAT,
+    PRIMITIVEINT INTEGER,
+    PRIMITIVELONG BIGINT,
+    PRIMITIVESHORT SMALLINT,
+    BOOLEANVAL CHAR(1) CHECK (BOOLEANVAL IN ('Y','N')),
+    BYTEVAL SMALLINT,
+    CHARACTERVAL CHAR(1),
+    DOUBLEVAL DOUBLE,
+    FLOATVAL FLOAT,
+    INTEGERVAL INTEGER,
+    LONGVAL BIGINT,
+    SHORTVAL SMALLINT,
+    STRINGVAL VARCHAR(255),
+    LOCALEVAL CHAR(20),
+    DATEVAL DATE,
+    BIGDECIMALVAL DECIMAL(25,10),
+    BIGINTEGERVAL BIGINT
+);
+
+ALTER TABLE ALLTYPES ADD CONSTRAINT ALLTYPES_PK PRIMARY KEY (ID);
+
+CREATE TABLE FIELDSOFBIGDECIMAL
+(
+    IDENTIFIER INTEGER NOT NULL,
+    BIG_DECIMAL0 DECIMAL(11,4),
+    BIG_DECIMAL1 DECIMAL(11,4),
+    BIG_DECIMAL102 DECIMAL(11,4),
+    BIG_DECIMAL103 DECIMAL(11,4),
+    BIG_DECIMAL104 DECIMAL(11,4),
+    BIG_DECIMAL108 DECIMAL(11,4),
+    BIG_DECIMAL109 DECIMAL(11,4),
+    BIG_DECIMAL11 DECIMAL(11,4),
+    BIG_DECIMAL110 DECIMAL(11,4),
+    BIG_DECIMAL112 DECIMAL(11,4),
+    BIG_DECIMAL113 DECIMAL(11,4),
+    BIG_DECIMAL114 DECIMAL(11,4),
+    BIG_DECIMAL119 DECIMAL(11,4),
+    BIG_DECIMAL12 DECIMAL(11,4),
+    BIG_DECIMAL120 DECIMAL(11,4),
+    BIG_DECIMAL121 DECIMAL(11,4),
+    BIG_DECIMAL124 DECIMAL(11,4),
+    BIG_DECIMAL125 DECIMAL(11,4),
+    BIG_DECIMAL126 DECIMAL(11,4),
+    BIG_DECIMAL128 DECIMAL(11,4),
+    BIG_DECIMAL129 DECIMAL(11,4),
+    BIG_DECIMAL13 DECIMAL(11,4),
+    BIG_DECIMAL130 DECIMAL(11,4),
+    BIG_DECIMAL138 DECIMAL(11,4),
+    BIG_DECIMAL139 DECIMAL(11,4),
+    BIG_DECIMAL140 DECIMAL(11,4),
+    BIG_DECIMAL16 DECIMAL(11,4),
+    BIG_DECIMAL17 DECIMAL(11,4),
+    BIG_DECIMAL18 DECIMAL(11,4),
+    BIG_DECIMAL2 DECIMAL(11,4),
+    BIG_DECIMAL20 DECIMAL(11,4),
+    BIG_DECIMAL21 DECIMAL(11,4),
+    BIG_DECIMAL22 DECIMAL(11,4),
+    BIG_DECIMAL30 DECIMAL(11,4),
+    BIG_DECIMAL31 DECIMAL(11,4),
+    BIG_DECIMAL32 DECIMAL(11,4),
+    BIG_DECIMAL36 DECIMAL(11,4),
+    BIG_DECIMAL37 DECIMAL(11,4),
+    BIG_DECIMAL38 DECIMAL(11,4),
+    BIG_DECIMAL4 DECIMAL(11,4),
+    BIG_DECIMAL40 DECIMAL(11,4),
+    BIG_DECIMAL41 DECIMAL(11,4),
+    BIG_DECIMAL42 DECIMAL(11,4),
+    BIG_DECIMAL47 DECIMAL(11,4),
+    BIG_DECIMAL48 DECIMAL(11,4),
+    BIG_DECIMAL49 DECIMAL(11,4),
+    BIG_DECIMAL5 DECIMAL(11,4),
+    BIG_DECIMAL52 DECIMAL(11,4),
+    BIG_DECIMAL53 DECIMAL(11,4),
+    BIG_DECIMAL54 DECIMAL(11,4),
+    BIG_DECIMAL56 DECIMAL(11,4),
+    BIG_DECIMAL57 DECIMAL(11,4),
+    BIG_DECIMAL58 DECIMAL(11,4),
+    BIG_DECIMAL6 DECIMAL(11,4),
+    BIG_DECIMAL66 DECIMAL(11,4),
+    BIG_DECIMAL67 DECIMAL(11,4),
+    BIG_DECIMAL68 DECIMAL(11,4),
+    BIG_DECIMAL72 DECIMAL(11,4),
+    BIG_DECIMAL73 DECIMAL(11,4),
+    BIG_DECIMAL74 DECIMAL(11,4),
+    BIG_DECIMAL76 DECIMAL(11,4),
+    BIG_DECIMAL77 DECIMAL(11,4),
+    BIG_DECIMAL78 DECIMAL(11,4),
+    BIG_DECIMAL83 DECIMAL(11,4),
+    BIG_DECIMAL84 DECIMAL(11,4),
+    BIG_DECIMAL85 DECIMAL(11,4),
+    BIG_DECIMAL88 DECIMAL(11,4),
+    BIG_DECIMAL89 DECIMAL(11,4),
+    BIG_DECIMAL90 DECIMAL(11,4),
+    BIG_DECIMAL92 DECIMAL(11,4),
+    BIG_DECIMAL93 DECIMAL(11,4),
+    BIG_DECIMAL94 DECIMAL(11,4)
+);
+
+ALTER TABLE FIELDSOFBIGDECIMAL ADD CONSTRAINT FIELDSOFBIGDPP_PK PRIMARY KEY (IDENTIFIER);
+
+CREATE TABLE FIELDSOFBIGINTEGER
+(
+    IDENTIFIER INTEGER NOT NULL,
+    BIG_INTEGER0 BIGINT,
+    BIG_INTEGER1 BIGINT,
+    BIG_INTEGER102 BIGINT,
+    BIG_INTEGER103 BIGINT,
+    BIG_INTEGER104 BIGINT,
+    BIG_INTEGER108 BIGINT,
+    BIG_INTEGER109 BIGINT,
+    BIG_INTEGER11 BIGINT,
+    BIG_INTEGER110 BIGINT,
+    BIG_INTEGER112 BIGINT,
+    BIG_INTEGER113 BIGINT,
+    BIG_INTEGER114 BIGINT,
+    BIG_INTEGER119 BIGINT,
+    BIG_INTEGER12 BIGINT,
+    BIG_INTEGER120 BIGINT,
+    BIG_INTEGER121 BIGINT,
+    BIG_INTEGER124 BIGINT,
+    BIG_INTEGER125 BIGINT,
+    BIG_INTEGER126 BIGINT,
+    BIG_INTEGER128 BIGINT,
+    BIG_INTEGER129 BIGINT,
+    BIG_INTEGER13 BIGINT,
+    BIG_INTEGER130 BIGINT,
+    BIG_INTEGER138 BIGINT,
+    BIG_INTEGER139 BIGINT,
+    BIG_INTEGER140 BIGINT,
+    BIG_INTEGER16 BIGINT,
+    BIG_INTEGER17 BIGINT,
+    BIG_INTEGER18 BIGINT,
+    BIG_INTEGER2 BIGINT,
+    BIG_INTEGER20 BIGINT,
+    BIG_INTEGER21 BIGINT,
+    BIG_INTEGER22 BIGINT,
+    BIG_INTEGER30 BIGINT,
+    BIG_INTEGER31 BIGINT,
+    BIG_INTEGER32 BIGINT,
+    BIG_INTEGER36 BIGINT,
+    BIG_INTEGER37 BIGINT,
+    BIG_INTEGER38 BIGINT,
+    BIG_INTEGER4 BIGINT,
+    BIG_INTEGER40 BIGINT,
+    BIG_INTEGER41 BIGINT,
+    BIG_INTEGER42 BIGINT,
+    BIG_INTEGER47 BIGINT,
+    BIG_INTEGER48 BIGINT,
+    BIG_INTEGER49 BIGINT,
+    BIG_INTEGER5 BIGINT,
+    BIG_INTEGER52 BIGINT,
+    BIG_INTEGER53 BIGINT,
+    BIG_INTEGER54 BIGINT,
+    BIG_INTEGER56 BIGINT,
+    BIG_INTEGER57 BIGINT,
+    BIG_INTEGER58 BIGINT,
+    BIG_INTEGER6 BIGINT,
+    BIG_INTEGER66 BIGINT,
+    BIG_INTEGER67 BIGINT,
+    BIG_INTEGER68 BIGINT,
+    BIG_INTEGER72 BIGINT,
+    BIG_INTEGER73 BIGINT,
+    BIG_INTEGER74 BIGINT,
+    BIG_INTEGER76 BIGINT,
+    BIG_INTEGER77 BIGINT,
+    BIG_INTEGER78 BIGINT,
+    BIG_INTEGER83 BIGINT,
+    BIG_INTEGER84 BIGINT,
+    BIG_INTEGER85 BIGINT,
+    BIG_INTEGER88 BIGINT,
+    BIG_INTEGER89 BIGINT,
+    BIG_INTEGER90 BIGINT,
+    BIG_INTEGER92 BIGINT,
+    BIG_INTEGER93 BIGINT,
+    BIG_INTEGER94 BIGINT
+);
+
+ALTER TABLE FIELDSOFBIGINTEGER ADD CONSTRAINT FIELDSOFBIGI2S_PK PRIMARY KEY (IDENTIFIER);
+
+CREATE TABLE FIELDSOFBOOLEAN
+(
+    IDENTIFIER INTEGER NOT NULL,
+    BOOLEAN0 CHAR(1) CHECK (BOOLEAN0 IN ('Y','N') OR BOOLEAN0 IS NULL),
+    BOOLEAN1 CHAR(1) CHECK (BOOLEAN1 IN ('Y','N') OR BOOLEAN1 IS NULL),
+    BOOLEAN102 CHAR(1) CHECK (BOOLEAN102 IN ('Y','N') OR BOOLEAN102 IS NULL),
+    BOOLEAN103 CHAR(1) CHECK (BOOLEAN103 IN ('Y','N') OR BOOLEAN103 IS NULL),
+    BOOLEAN104 CHAR(1) CHECK (BOOLEAN104 IN ('Y','N') OR BOOLEAN104 IS NULL),
+    BOOLEAN108 CHAR(1) CHECK (BOOLEAN108 IN ('Y','N') OR BOOLEAN108 IS NULL),
+    BOOLEAN109 CHAR(1) CHECK (BOOLEAN109 IN ('Y','N') OR BOOLEAN109 IS NULL),
+    BOOLEAN11 CHAR(1) CHECK (BOOLEAN11 IN ('Y','N') OR BOOLEAN11 IS NULL),
+    BOOLEAN110 CHAR(1) CHECK (BOOLEAN110 IN ('Y','N') OR BOOLEAN110 IS NULL),
+    BOOLEAN112 CHAR(1) CHECK (BOOLEAN112 IN ('Y','N') OR BOOLEAN112 IS NULL),
+    BOOLEAN113 CHAR(1) CHECK (BOOLEAN113 IN ('Y','N') OR BOOLEAN113 IS NULL),
+    BOOLEAN114 CHAR(1) CHECK (BOOLEAN114 IN ('Y','N') OR BOOLEAN114 IS NULL),
+    BOOLEAN119 CHAR(1) CHECK (BOOLEAN119 IN ('Y','N') OR BOOLEAN119 IS NULL),
+    BOOLEAN12 CHAR(1) CHECK (BOOLEAN12 IN ('Y','N') OR BOOLEAN12 IS NULL),
+    BOOLEAN120 CHAR(1) CHECK (BOOLEAN120 IN ('Y','N') OR BOOLEAN120 IS NULL),
+    BOOLEAN121 CHAR(1) CHECK (BOOLEAN121 IN ('Y','N') OR BOOLEAN121 IS NULL),
+    BOOLEAN124 CHAR(1) CHECK (BOOLEAN124 IN ('Y','N') OR BOOLEAN124 IS NULL),
+    BOOLEAN125 CHAR(1) CHECK (BOOLEAN125 IN ('Y','N') OR BOOLEAN125 IS NULL),
+    BOOLEAN126 CHAR(1) CHECK (BOOLEAN126 IN ('Y','N') OR BOOLEAN126 IS NULL),
+    BOOLEAN128 CHAR(1) CHECK (BOOLEAN128 IN ('Y','N') OR BOOLEAN128 IS NULL),
+    BOOLEAN129 CHAR(1) CHECK (BOOLEAN129 IN ('Y','N') OR BOOLEAN129 IS NULL),
+    BOOLEAN13 CHAR(1) CHECK (BOOLEAN13 IN ('Y','N') OR BOOLEAN13 IS NULL),
+    BOOLEAN130 CHAR(1) CHECK (BOOLEAN130 IN ('Y','N') OR BOOLEAN130 IS NULL),
+    BOOLEAN138 CHAR(1) CHECK (BOOLEAN138 IN ('Y','N') OR BOOLEAN138 IS NULL),
+    BOOLEAN139 CHAR(1) CHECK (BOOLEAN139 IN ('Y','N') OR BOOLEAN139 IS NULL),
+    BOOLEAN140 CHAR(1) CHECK (BOOLEAN140 IN ('Y','N') OR BOOLEAN140 IS NULL),
+    BOOLEAN16 CHAR(1) CHECK (BOOLEAN16 IN ('Y','N') OR BOOLEAN16 IS NULL),
+    BOOLEAN17 CHAR(1) CHECK (BOOLEAN17 IN ('Y','N') OR BOOLEAN17 IS NULL),
+    BOOLEAN18 CHAR(1) CHECK (BOOLEAN18 IN ('Y','N') OR BOOLEAN18 IS NULL),
+    BOOLEAN2 CHAR(1) CHECK (BOOLEAN2 IN ('Y','N') OR BOOLEAN2 IS NULL),
+    BOOLEAN20 CHAR(1) CHECK (BOOLEAN20 IN ('Y','N') OR BOOLEAN20 IS NULL),
+    BOOLEAN21 CHAR(1) CHECK (BOOLEAN21 IN ('Y','N') OR BOOLEAN21 IS NULL),
+    BOOLEAN22 CHAR(1) CHECK (BOOLEAN22 IN ('Y','N') OR BOOLEAN22 IS NULL),
+    BOOLEAN30 CHAR(1) CHECK (BOOLEAN30 IN ('Y','N') OR BOOLEAN30 IS NULL),
+    BOOLEAN31 CHAR(1) CHECK (BOOLEAN31 IN ('Y','N') OR BOOLEAN31 IS NULL),
+    BOOLEAN32 CHAR(1) CHECK (BOOLEAN32 IN ('Y','N') OR BOOLEAN32 IS NULL),
+    BOOLEAN36 CHAR(1) CHECK (BOOLEAN36 IN ('Y','N') OR BOOLEAN36 IS NULL),
+    BOOLEAN37 CHAR(1) CHECK (BOOLEAN37 IN ('Y','N') OR BOOLEAN37 IS NULL),
+    BOOLEAN38 CHAR(1) CHECK (BOOLEAN38 IN ('Y','N') OR BOOLEAN38 IS NULL),
+    BOOLEAN4 CHAR(1) CHECK (BOOLEAN4 IN ('Y','N') OR BOOLEAN4 IS NULL),
+    BOOLEAN40 CHAR(1) CHECK (BOOLEAN40 IN ('Y','N') OR BOOLEAN40 IS NULL),
+    BOOLEAN41 CHAR(1) CHECK (BOOLEAN41 IN ('Y','N') OR BOOLEAN41 IS NULL),
+    BOOLEAN42 CHAR(1) CHECK (BOOLEAN42 IN ('Y','N') OR BOOLEAN42 IS NULL),
+    BOOLEAN47 CHAR(1) CHECK (BOOLEAN47 IN ('Y','N') OR BOOLEAN47 IS NULL),
+    BOOLEAN48 CHAR(1) CHECK (BOOLEAN48 IN ('Y','N') OR BOOLEAN48 IS NULL),
+    BOOLEAN49 CHAR(1) CHECK (BOOLEAN49 IN ('Y','N') OR BOOLEAN49 IS NULL),
+    BOOLEAN5 CHAR(1) CHECK (BOOLEAN5 IN ('Y','N') OR BOOLEAN5 IS NULL),
+    BOOLEAN52 CHAR(1) CHECK (BOOLEAN52 IN ('Y','N') OR BOOLEAN52 IS NULL),
+    BOOLEAN53 CHAR(1) CHECK (BOOLEAN53 IN ('Y','N') OR BOOLEAN53 IS NULL),
+    BOOLEAN54 CHAR(1) CHECK (BOOLEAN54 IN ('Y','N') OR BOOLEAN54 IS NULL),
+    BOOLEAN56 CHAR(1) CHECK (BOOLEAN56 IN ('Y','N') OR BOOLEAN56 IS NULL),
+    BOOLEAN57 CHAR(1) CHECK (BOOLEAN57 IN ('Y','N') OR BOOLEAN57 IS NULL),
+    BOOLEAN58 CHAR(1) CHECK (BOOLEAN58 IN ('Y','N') OR BOOLEAN58 IS NULL),
+    BOOLEAN6 CHAR(1) CHECK (BOOLEAN6 IN ('Y','N') OR BOOLEAN6 IS NULL),
+    BOOLEAN66 CHAR(1) CHECK (BOOLEAN66 IN ('Y','N') OR BOOLEAN66 IS NULL),
+    BOOLEAN67 CHAR(1) CHECK (BOOLEAN67 IN ('Y','N') OR BOOLEAN67 IS NULL),
+    BOOLEAN68 CHAR(1) CHECK (BOOLEAN68 IN ('Y','N') OR BOOLEAN68 IS NULL),
+    BOOLEAN72 CHAR(1) CHECK (BOOLEAN72 IN ('Y','N') OR BOOLEAN72 IS NULL),
+    BOOLEAN73 CHAR(1) CHECK (BOOLEAN73 IN ('Y','N') OR BOOLEAN73 IS NULL),
+    BOOLEAN74 CHAR(1) CHECK (BOOLEAN74 IN ('Y','N') OR BOOLEAN74 IS NULL),
+    BOOLEAN76 CHAR(1) CHECK (BOOLEAN76 IN ('Y','N') OR BOOLEAN76 IS NULL),
+    BOOLEAN77 CHAR(1) CHECK (BOOLEAN77 IN ('Y','N') OR BOOLEAN77 IS NULL),
+    BOOLEAN78 CHAR(1) CHECK (BOOLEAN78 IN ('Y','N') OR BOOLEAN78 IS NULL),
+    BOOLEAN83 CHAR(1) CHECK (BOOLEAN83 IN ('Y','N') OR BOOLEAN83 IS NULL),
+    BOOLEAN84 CHAR(1) CHECK (BOOLEAN84 IN ('Y','N') OR BOOLEAN84 IS NULL),
+    BOOLEAN85 CHAR(1) CHECK (BOOLEAN85 IN ('Y','N') OR BOOLEAN85 IS NULL),
+    BOOLEAN88 CHAR(1) CHECK (BOOLEAN88 IN ('Y','N') OR BOOLEAN88 IS NULL),
+    BOOLEAN89 CHAR(1) CHECK (BOOLEAN89 IN ('Y','N') OR BOOLEAN89 IS NULL),
+    BOOLEAN90 CHAR(1) CHECK (BOOLEAN90 IN ('Y','N') OR BOOLEAN90 IS NULL),
+    BOOLEAN92 CHAR(1) CHECK (BOOLEAN92 IN ('Y','N') OR BOOLEAN92 IS NULL),
+    BOOLEAN93 CHAR(1) CHECK (BOOLEAN93 IN ('Y','N') OR BOOLEAN93 IS NULL),
+    BOOLEAN94 CHAR(1) CHECK (BOOLEAN94 IN ('Y','N') OR BOOLEAN94 IS NULL)
+);
+
+ALTER TABLE FIELDSOFBOOLEAN ADD CONSTRAINT FIELDSOFBOOLS2_PK PRIMARY KEY (IDENTIFIER);
+
+CREATE TABLE FIELDSOFCHARACTER
+(
+    IDENTIFIER INTEGER NOT NULL,
+    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 (IDENTIFIER);
+
+CREATE TABLE FIELDSOFDATE
+(
+    IDENTIFIER INTEGER NOT NULL,
+    DATE0 TIMESTAMP,
+    DATE1 TIMESTAMP,
+    DATE102 TIMESTAMP,
+    DATE103 TIMESTAMP,
+    DATE104 TIMESTAMP,
+    DATE108 TIMESTAMP,
+    DATE109 TIMESTAMP,
+    DATE11 TIMESTAMP,
+    DATE110 TIMESTAMP,
+    DATE112 TIMESTAMP,
+    DATE113 TIMESTAMP,
+    DATE114 TIMESTAMP,
+    DATE119 TIMESTAMP,
+    DATE12 TIMESTAMP,
+    DATE120 TIMESTAMP,
+    DATE121 TIMESTAMP,
+    DATE124 TIMESTAMP,
+    DATE125 TIMESTAMP,
+    DATE126 TIMESTAMP,
+    DATE128 TIMESTAMP,
+    DATE129 TIMESTAMP,
+    DATE13 TIMESTAMP,
+    DATE130 TIMESTAMP,
+    DATE138 TIMESTAMP,
+    DATE139 TIMESTAMP,
+    DATE140 TIMESTAMP,
+    DATE16 TIMESTAMP,
+    DATE17 TIMESTAMP,
+    DATE18 TIMESTAMP,
+    DATE2 TIMESTAMP,
+    DATE20 TIMESTAMP,
+    DATE21 TIMESTAMP,
+    DATE22 TIMESTAMP,
+    DATE30 TIMESTAMP,
+    DATE31 TIMESTAMP,
+    DATE32 TIMESTAMP,
+    DATE36 TIMESTAMP,
+    DATE37 TIMESTAMP,
+    DATE38 TIMESTAMP,
+    DATE4 TIMESTAMP,
+    DATE40 TIMESTAMP,
+    DATE41 TIMESTAMP,
+    DATE42 TIMESTAMP,
+    DATE47 TIMESTAMP,
+    DATE48 TIMESTAMP,
+    DATE49 TIMESTAMP,
+    DATE5 TIMESTAMP,
+    DATE52 TIMESTAMP,
+    DATE53 TIMESTAMP,
+    DATE54 TIMESTAMP,
+    DATE56 TIMESTAMP,
+    DATE57 TIMESTAMP,
+    DATE58 TIMESTAMP,
+    DATE6 TIMESTAMP,
+    DATE66 TIMESTAMP,
+    DATE67 TIMESTAMP,
+    DATE68 TIMESTAMP,
+    DATE72 TIMESTAMP,
+    DATE73 TIMESTAMP,
+    DATE74 TIMESTAMP,
+    DATE76 TIMESTAMP,
+    DATE77 TIMESTAMP,
+    DATE78 TIMESTAMP,
+    DATE83 TIMESTAMP,
+    DATE84 TIMESTAMP,
+    DATE85 TIMESTAMP,
+    DATE88 TIMESTAMP,
+    DATE89 TIMESTAMP,
+    DATE90 TIMESTAMP,
+    DATE92 TIMESTAMP,
+    DATE93 TIMESTAMP,
+    DATE94 TIMESTAMP
+);
+
+ALTER TABLE FIELDSOFDATE ADD CONSTRAINT FIELDSOFDATE_PK PRIMARY KEY (IDENTIFIER);
+
+CREATE TABLE FIELDSOFDOUBLE
+(
+    IDENTIFIER INTEGER NOT NULL,
+    DOUBLE0 DOUBLE,
+    DOUBLE1 DOUBLE,
+    DOUBLE102 DOUBLE,
+    DOUBLE103 DOUBLE,
+    DOUBLE104 DOUBLE,
+    DOUBLE108 DOUBLE,
+    DOUBLE109 DOUBLE,
+    DOUBLE11 DOUBLE,
+    DOUBLE110 DOUBLE,
+    DOUBLE112 DOUBLE,
+    DOUBLE113 DOUBLE,
+    DOUBLE114 DOUBLE,
+    DOUBLE119 DOUBLE,
+    DOUBLE12 DOUBLE,
+    DOUBLE120 DOUBLE,
+    DOUBLE121 DOUBLE,
+    DOUBLE124 DOUBLE,
+    DOUBLE125 DOUBLE,
+    DOUBLE126 DOUBLE,
+    DOUBLE128 DOUBLE,
+    DOUBLE129 DOUBLE,
+    DOUBLE13 DOUBLE,
+    DOUBLE130 DOUBLE,
+    DOUBLE138 DOUBLE,
+    DOUBLE139 DOUBLE,
+    DOUBLE140 DOUBLE,
+    DOUBLE16 DOUBLE,
+    DOUBLE17 DOUBLE,
+    DOUBLE18 DOUBLE,
+    DOUBLE2 DOUBLE,
+    DOUBLE20 DOUBLE,
+    DOUBLE21 DOUBLE,
+    DOUBLE22 DOUBLE,
+    DOUBLE30 DOUBLE,
+    DOUBLE31 DOUBLE,
+    DOUBLE32 DOUBLE,
+    DOUBLE36 DOUBLE,
+    DOUBLE37 DOUBLE,
+    DOUBLE38 DOUBLE,
+    DOUBLE4 DOUBLE,
+    DOUBLE40 DOUBLE,
+    DOUBLE41 DOUBLE,
+    DOUBLE42 DOUBLE,
+    DOUBLE47 DOUBLE,
+    DOUBLE48 DOUBLE,
+    DOUBLE49 DOUBLE,
+    DOUBLE5 DOUBLE,
+    DOUBLE52 DOUBLE,
+    DOUBLE53 DOUBLE,
+    DOUBLE54 DOUBLE,
+    DOUBLE56 DOUBLE,
+    DOUBLE57 DOUBLE,
+    DOUBLE58 DOUBLE,
+    DOUBLE6 DOUBLE,
+    DOUBLE66 DOUBLE,
+    DOUBLE67 DOUBLE,
+    DOUBLE68 DOUBLE,
+    DOUBLE72 DOUBLE,
+    DOUBLE73 DOUBLE,
+    DOUBLE74 DOUBLE,
+    DOUBLE76 DOUBLE,
+    DOUBLE77 DOUBLE,
+    DOUBLE78 DOUBLE,
+    DOUBLE83 DOUBLE,
+    DOUBLE84 DOUBLE,
+    DOUBLE85 DOUBLE,
+    DOUBLE88 DOUBLE,
+    DOUBLE89 DOUBLE,
+    DOUBLE90 DOUBLE,
+    DOUBLE92 DOUBLE,
+    DOUBLE93 DOUBLE,
+    DOUBLE94 DOUBLE
+);
+
+ALTER TABLE FIELDSOFDOUBLE ADD CONSTRAINT FIELDSOFDOUBLE_PK PRIMARY KEY (IDENTIFIER);
+
+CREATE TABLE FIELDSOFFLOAT
+(
+    IDENTIFIER INTEGER NOT NULL,
+    FLOAT0 FLOAT,
+    FLOAT1 FLOAT,
+    FLOAT102 FLOAT,
+    FLOAT103 FLOAT,
+    FLOAT104 FLOAT,
+    FLOAT108 FLOAT,
+    FLOAT109 FLOAT,
+    FLOAT11 FLOAT,
+    FLOAT110 FLOAT,
+    FLOAT112 FLOAT,
+    FLOAT113 FLOAT,
+    FLOAT114 FLOAT,
+    FLOAT119 FLOAT,
+    FLOAT12 FLOAT,
+    FLOAT120 FLOAT,
+    FLOAT121 FLOAT,
+    FLOAT124 FLOAT,
+    FLOAT125 FLOAT,
+    FLOAT126 FLOAT,
+    FLOAT128 FLOAT,
+    FLOAT129 FLOAT,
+    FLOAT13 FLOAT,
+    FLOAT130 FLOAT,
+    FLOAT138 FLOAT,
+    FLOAT139 FLOAT,
+    FLOAT140 FLOAT,
+    FLOAT16 FLOAT,
+    FLOAT17 FLOAT,
+    FLOAT18 FLOAT,
+    FLOAT2 FLOAT,
+    FLOAT20 FLOAT,
+    FLOAT21 FLOAT,
+    FLOAT22 FLOAT,
+    FLOAT30 FLOAT,
+    FLOAT31 FLOAT,
+    FLOAT32 FLOAT,
+    FLOAT36 FLOAT,
+    FLOAT37 FLOAT,
+    FLOAT38 FLOAT,
+    FLOAT4 FLOAT,
+    FLOAT40 FLOAT,
+    FLOAT41 FLOAT,
+    FLOAT42 FLOAT,
+    FLOAT47 FLOAT,
+    FLOAT48 FLOAT,
+    FLOAT49 FLOAT,
+    FLOAT5 FLOAT,
+    FLOAT52 FLOAT,
+    FLOAT53 FLOAT,
+    FLOAT54 FLOAT,
+    FLOAT56 FLOAT,
+    FLOAT57 FLOAT,
+    FLOAT58 FLOAT,
+    FLOAT6 FLOAT,
+    FLOAT66 FLOAT,
+    FLOAT67 FLOAT,
+    FLOAT68 FLOAT,
+    FLOAT72 FLOAT,
+    FLOAT73 FLOAT,
+    FLOAT74 FLOAT,
+    FLOAT76 FLOAT,
+    FLOAT77 FLOAT,
+    FLOAT78 FLOAT,
+    FLOAT83 FLOAT,
+    FLOAT84 FLOAT,
+    FLOAT85 FLOAT,
+    FLOAT88 FLOAT,
+    FLOAT89 FLOAT,
+    FLOAT90 FLOAT,
+    FLOAT92 FLOAT,
+    FLOAT93 FLOAT,
+    FLOAT94 FLOAT
+);
+
+ALTER TABLE FIELDSOFFLOAT ADD CONSTRAINT FIELDSOFFLOAT_PK PRIMARY KEY (IDENTIFIER);
+
+CREATE TABLE FIELDSOFINTEGER
+(
+    IDENTIFIER INTEGER NOT NULL,
+    INTEGER0 INTEGER,
+    INTEGER1 INTEGER,
+    INTEGER102 INTEGER,
+    INTEGER103 INTEGER,
+    INTEGER104 INTEGER,
+    INTEGER108 INTEGER,
+    INTEGER109 INTEGER,
+    INTEGER11 INTEGER,
+    INTEGER110 INTEGER,
+    INTEGER112 INTEGER,
+    INTEGER113 INTEGER,
+    INTEGER114 INTEGER,
+    INTEGER119 INTEGER,
+    INTEGER12 INTEGER,
+    INTEGER120 INTEGER,
+    INTEGER121 INTEGER,
+    INTEGER124 INTEGER,
+    INTEGER125 INTEGER,
+    INTEGER126 INTEGER,
+    INTEGER128 INTEGER,
+    INTEGER129 INTEGER,
+    INTEGER13 INTEGER,
+    INTEGER130 INTEGER,
+    INTEGER138 INTEGER,
+    INTEGER139 INTEGER,
+    INTEGER140 INTEGER,
+    INTEGER16 INTEGER,
+    INTEGER17 INTEGER,
+    INTEGER18 INTEGER,
+    INTEGER2 INTEGER,
+    INTEGER20 INTEGER,
+    INTEGER21 INTEGER,
+    INTEGER22 INTEGER,
+    INTEGER30 INTEGER,
+    INTEGER31 INTEGER,
+    INTEGER32 INTEGER,
+    INTEGER36 INTEGER,
+    INTEGER37 INTEGER,
+    INTEGER38 INTEGER,
+    INTEGER4 INTEGER,
+    INTEGER40 INTEGER,
+    INTEGER41 INTEGER,
+    INTEGER42 INTEGER,
+    INTEGER47 INTEGER,
+    INTEGER48 INTEGER,
+    INTEGER49 INTEGER,
+    INTEGER5 INTEGER,
+    INTEGER52 INTEGER,
+    INTEGER53 INTEGER,
+    INTEGER54 INTEGER,
+    INTEGER56 INTEGER,
+    INTEGER57 INTEGER,
+    INTEGER58 INTEGER,
+    INTEGER6 INTEGER,
+    INTEGER66 INTEGER,
+    INTEGER67 INTEGER,
+    INTEGER68 INTEGER,
+    INTEGER72 INTEGER,
+    INTEGER73 INTEGER,
+    INTEGER74 INTEGER,
+    INTEGER76 INTEGER,
+    INTEGER77 INTEGER,
+    INTEGER78 INTEGER,
+    INTEGER83 INTEGER,
+    INTEGER84 INTEGER,
+    INTEGER85 INTEGER,
+    INTEGER88 INTEGER,
+    INTEGER89 INTEGER,
+    INTEGER90 INTEGER,
+    INTEGER92 INTEGER,
+    INTEGER93 INTEGER,
+    INTEGER94 INTEGER
+);
+
+ALTER TABLE FIELDSOFINTEGER ADD CONSTRAINT FIELDSOFINTEV0_PK PRIMARY KEY (IDENTIFIER);
+
+CREATE TABLE FIELDSOFLOCALE
+(
+    IDENTIFIER INTEGER NOT NULL,
+    LOCALE0 CHAR(20),
+    LOCALE1 CHAR(20),
+    LOCALE102 CHAR(20),
+    LOCALE103 CHAR(20),
+    LOCALE104 CHAR(20),
+    LOCALE108 CHAR(20),
+    LOCALE109 CHAR(20),
+    LOCALE11 CHAR(20),
+    LOCALE110 CHAR(20),
+    LOCALE112 CHAR(20),
+    LOCALE113 CHAR(20),
+    LOCALE114 CHAR(20),
+    LOCALE119 CHAR(20),
+    LOCALE12 CHAR(20),
+    LOCALE120 CHAR(20),
+    LOCALE121 CHAR(20),
+    LOCALE124 CHAR(20),
+    LOCALE125 CHAR(20),
+    LOCALE126 CHAR(20),
+    LOCALE128 CHAR(20),
+    LOCALE129 CHAR(20),
+    LOCALE13 CHAR(20),
+    LOCALE130 CHAR(20),
+    LOCALE138 CHAR(20),
+    LOCALE139 CHAR(20),
+    LOCALE140 CHAR(20),
+    LOCALE16 CHAR(20),
+    LOCALE17 CHAR(20),
+    LOCALE18 CHAR(20),
+    LOCALE2 CHAR(20),
+    LOCALE20 CHAR(20),
+    LOCALE21 CHAR(20),
+    LOCALE22 CHAR(20),
+    LOCALE30 CHAR(20),
+    LOCALE31 CHAR(20),
+    LOCALE32 CHAR(20),
+    LOCALE36 CHAR(20),
+    LOCALE37 CHAR(20),
+    LOCALE38 CHAR(20),
+    LOCALE4 CHAR(20),
+    LOCALE40 CHAR(20),
+    LOCALE41 CHAR(20),
+    LOCALE42 CHAR(20),
+    LOCALE47 CHAR(20),
+    LOCALE48 CHAR(20),
+    LOCALE49 CHAR(20),
+    LOCALE5 CHAR(20),
+    LOCALE52 CHAR(20),
+    LOCALE53 CHAR(20),
+    LOCALE54 CHAR(20),
+    LOCALE56 CHAR(20),
+    LOCALE57 CHAR(20),
+    LOCALE58 CHAR(20),
+    LOCALE6 CHAR(20),
+    LOCALE66 CHAR(20),
+    LOCALE67 CHAR(20),
+    LOCALE68 CHAR(20),
+    LOCALE72 CHAR(20),
+    LOCALE73 CHAR(20),
+    LOCALE74 CHAR(20),
+    LOCALE76 CHAR(20),
+    LOCALE77 CHAR(20),
+    LOCALE78 CHAR(20),
+    LOCALE83 CHAR(20),
+    LOCALE84 CHAR(20),
+    LOCALE85 CHAR(20),
+    LOCALE88 CHAR(20),
+    LOCALE89 CHAR(20),
+    LOCALE90 CHAR(20),
+    LOCALE92 CHAR(20),
+    LOCALE93 CHAR(20),
+    LOCALE94 CHAR(20)
+);
+
+ALTER TABLE FIELDSOFLOCALE ADD CONSTRAINT FIELDSOFLOCALE_PK PRIMARY KEY (IDENTIFIER);
+
+CREATE TABLE FIELDSOFLONG
+(
+    IDENTIFIER INTEGER NOT NULL,
+    LONG0 BIGINT,
+    LONG1 BIGINT,
+    LONG102 BIGINT,
+    LONG103 BIGINT,
+    LONG104 BIGINT,
+    LONG108 BIGINT,
+    LONG109 BIGINT,
+    LONG11 BIGINT,
+    LONG110 BIGINT,
+    LONG112 BIGINT,
+    LONG113 BIGINT,
+    LONG114 BIGINT,
+    LONG119 BIGINT,
+    LONG12 BIGINT,
+    LONG120 BIGINT,
+    LONG121 BIGINT,
+    LONG124 BIGINT,
+    LONG125 BIGINT,
+    LONG126 BIGINT,
+    LONG128 BIGINT,
+    LONG129 BIGINT,
+    LONG13 BIGINT,
+    LONG130 BIGINT,
+    LONG138 BIGINT,
+    LONG139 BIGINT,
+    LONG140 BIGINT,
+    LONG16 BIGINT,
+    LONG17 BIGINT,
+    LONG18 BIGINT,
+    LONG2 BIGINT,
+    LONG20 BIGINT,
+    LONG21 BIGINT,
+    LONG22 BIGINT,
+    LONG30 BIGINT,
+    LONG31 BIGINT,
+    LONG32 BIGINT,
+    LONG36 BIGINT,
+    LONG37 BIGINT,
+    LONG38 BIGINT,
+    LONG4 BIGINT,
+    LONG40 BIGINT,
+    LONG41 BIGINT,
+    LONG42 BIGINT,
+    LONG47 BIGINT,
+    LONG48 BIGINT,
+    LONG49 BIGINT,
+    LONG5 BIGINT,
+    LONG52 BIGINT,
+    LONG53 BIGINT,
+    LONG54 BIGINT,
+    LONG56 BIGINT,
+    LONG57 BIGINT,
+    LONG58 BIGINT,
+    LONG6 BIGINT,
+    LONG66 BIGINT,
+    LONG67 BIGINT,
+    LONG68 BIGINT,
+    LONG72 BIGINT,
+    LONG73 BIGINT,
+    LONG74 BIGINT,
+    LONG76 BIGINT,
+    LONG77 BIGINT,
+    LONG78 BIGINT,
+    LONG83 BIGINT,
+    LONG84 BIGINT,
+    LONG85 BIGINT,
+    LONG88 BIGINT,
+    LONG89 BIGINT,
+    LONG90 BIGINT,
+    LONG92 BIGINT,
+    LONG93 BIGINT,
+    LONG94 BIGINT
+);
+
+ALTER TABLE FIELDSOFLONG ADD CONSTRAINT FIELDSOFLONG_PK PRIMARY KEY (IDENTIFIER);
+
+CREATE TABLE FIELDSOFOBJECT
+(
+    IDENTIFIER INTEGER NOT NULL,
+    OBJECT1 LONG VARCHAR FOR BIT DATA,
+    OBJECT102 LONG VARCHAR FOR BIT DATA,
+    OBJECT103 LONG VARCHAR FOR BIT DATA,
+    OBJECT104 LONG VARCHAR FOR BIT DATA,
+    OBJECT109 LONG VARCHAR FOR BIT DATA,
+    OBJECT11 LONG VARCHAR FOR BIT DATA,
+    OBJECT110 LONG VARCHAR FOR BIT DATA,
+    OBJECT112 LONG VARCHAR FOR BIT DATA,
+    OBJECT113 LONG VARCHAR FOR BIT DATA,
+    OBJECT114 LONG VARCHAR FOR BIT DATA,
+    OBJECT119 LONG VARCHAR FOR BIT DATA,
+    OBJECT12 LONG VARCHAR FOR BIT DATA,
+    OBJECT120 LONG VARCHAR FOR BIT DATA,
+    OBJECT121 LONG VARCHAR FOR BIT DATA,
+    OBJECT125 LONG VARCHAR FOR BIT DATA,
+    OBJECT126 LONG VARCHAR FOR BIT DATA,
+    OBJECT128 LONG VARCHAR FOR BIT DATA,
+    OBJECT129 LONG VARCHAR FOR BIT DATA,
+    OBJECT13 LONG VARCHAR FOR BIT DATA,
+    OBJECT130 LONG VARCHAR FOR BIT DATA,
+    OBJECT138 LONG VARCHAR FOR BIT DATA,
+    OBJECT139 LONG VARCHAR FOR BIT DATA,
+    OBJECT140 LONG VARCHAR FOR BIT DATA,
+    OBJECT17 LONG VARCHAR FOR BIT DATA,
+    OBJECT18 LONG VARCHAR FOR BIT DATA,
+    OBJECT2 LONG VARCHAR FOR BIT DATA,
+    OBJECT20 LONG VARCHAR FOR BIT DATA,
+    OBJECT21 LONG VARCHAR FOR BIT DATA,
+    OBJECT22 LONG VARCHAR FOR BIT DATA,
+    OBJECT30 LONG VARCHAR FOR BIT DATA,
+    OBJECT31 LONG VARCHAR FOR BIT DATA,
+    OBJECT32 LONG VARCHAR FOR BIT DATA,
+    OBJECT37 LONG VARCHAR FOR BIT DATA,
+    OBJECT38 LONG VARCHAR FOR BIT DATA,
+    OBJECT4 LONG VARCHAR FOR BIT DATA,
+    OBJECT40 LONG VARCHAR FOR BIT DATA,
+    OBJECT41 LONG VARCHAR FOR BIT DATA,
+    OBJECT42 LONG VARCHAR FOR BIT DATA,
+    OBJECT47 LONG VARCHAR FOR BIT DATA,
+    OBJECT48 LONG VARCHAR FOR BIT DATA,
+    OBJECT49 LONG VARCHAR FOR BIT DATA,
+    OBJECT5 LONG VARCHAR FOR BIT DATA,
+    OBJECT53 LONG VARCHAR FOR BIT DATA,
+    OBJECT54 LONG VARCHAR FOR BIT DATA,
+    OBJECT56 LONG VARCHAR FOR BIT DATA,
+    OBJECT57 LONG VARCHAR FOR BIT DATA,
+    OBJECT58 LONG VARCHAR FOR BIT DATA,
+    OBJECT6 LONG VARCHAR FOR BIT DATA,
+    OBJECT66 LONG VARCHAR FOR BIT DATA,
+    OBJECT67 LONG VARCHAR FOR BIT DATA,
+    OBJECT68 LONG VARCHAR FOR BIT DATA,
+    OBJECT73 LONG VARCHAR FOR BIT DATA,
+    OBJECT74 LONG VARCHAR FOR BIT DATA,
+    OBJECT76 LONG VARCHAR FOR BIT DATA,
+    OBJECT77 LONG VARCHAR FOR BIT DATA,
+    OBJECT78 LONG VARCHAR FOR BIT DATA,
+    OBJECT83 LONG VARCHAR FOR BIT DATA,
+    OBJECT84 LONG VARCHAR FOR BIT DATA,
+    OBJECT85 LONG VARCHAR FOR BIT DATA,
+    OBJECT89 LONG VARCHAR FOR BIT DATA,
+    OBJECT90 LONG VARCHAR FOR BIT DATA,
+    OBJECT92 LONG VARCHAR FOR BIT DATA,
+    OBJECT93 LONG VARCHAR FOR BIT DATA,
+    OBJECT94 LONG VARCHAR FOR BIT DATA
+);
+
+ALTER TABLE FIELDSOFOBJECT ADD CONSTRAINT FIELDSOFOBJECT_PK PRIMARY KEY (IDENTIFIER);
+
+CREATE TABLE FIELDSOFSIMPLEINTERFACE
+(
+    IDENTIFIER INTEGER NOT NULL,
+    SIMPLEINTERFACE1 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE102 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE103 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE104 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE109 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE11 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE110 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE112 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE113 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE114 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE119 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE12 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE120 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE121 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE125 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE126 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE128 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE129 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE13 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE130 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE138 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE139 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE140 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE17 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE18 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE2 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE20 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE21 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE22 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE30 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE31 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE32 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE37 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE38 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE4 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE40 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE41 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE42 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE47 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE48 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE49 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE5 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE53 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE54 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE56 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE57 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE58 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE6 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE66 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE67 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE68 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE73 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE74 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE76 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE77 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE78 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE83 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE84 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE85 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE89 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE90 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE92 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE93 LONG VARCHAR FOR BIT DATA,
+    SIMPLEINTERFACE94 LONG VARCHAR FOR BIT DATA
+);
+
+ALTER TABLE FIELDSOFSIMPLEINTERFACE ADD CONSTRAINT FOSI_PK PRIMARY KEY (IDENTIFIER);
+
+CREATE TABLE FIELDSOFPRIMITIVEBOOLEAN
+(
+    IDENTIFIER INTEGER NOT NULL,
+    BOOLEAN0 CHAR(1) NOT NULL CHECK (BOOLEAN0 IN ('Y','N')),
+    BOOLEAN1 CHAR(1) NOT NULL CHECK (BOOLEAN1 IN ('Y','N')),
+    BOOLEAN102 CHAR(1) NOT NULL CHECK (BOOLEAN102 IN ('Y','N')),
+    BOOLEAN103 CHAR(1) NOT NULL CHECK (BOOLEAN103 IN ('Y','N')),
+    BOOLEAN104 CHAR(1) NOT NULL CHECK (BOOLEAN104 IN ('Y','N')),
+    BOOLEAN108 CHAR(1) NOT NULL CHECK (BOOLEAN108 IN ('Y','N')),
+    BOOLEAN109 CHAR(1) NOT NULL CHECK (BOOLEAN109 IN ('Y','N')),
+    BOOLEAN11 CHAR(1) NOT NULL CHECK (BOOLEAN11 IN ('Y','N')),
+    BOOLEAN110 CHAR(1) NOT NULL CHECK (BOOLEAN110 IN ('Y','N')),
+    BOOLEAN112 CHAR(1) NOT NULL CHECK (BOOLEAN112 IN ('Y','N')),
+    BOOLEAN113 CHAR(1) NOT NULL CHECK (BOOLEAN113 IN ('Y','N')),
+    BOOLEAN114 CHAR(1) NOT NULL CHECK (BOOLEAN114 IN ('Y','N')),
+    BOOLEAN119 CHAR(1) NOT NULL CHECK (BOOLEAN119 IN ('Y','N')),
+    BOOLEAN12 CHAR(1) NOT NULL CHECK (BOOLEAN12 IN ('Y','N')),
+    BOOLEAN120 CHAR(1) NOT NULL CHECK (BOOLEAN120 IN ('Y','N')),
+    BOOLEAN121 CHAR(1) NOT NULL CHECK (BOOLEAN121 IN ('Y','N')),
+    BOOLEAN124 CHAR(1) NOT NULL CHECK (BOOLEAN124 IN ('Y','N')),
+    BOOLEAN125 CHAR(1) NOT NULL CHECK (BOOLEAN125 IN ('Y','N')),
+    BOOLEAN126 CHAR(1) NOT NULL CHECK (BOOLEAN126 IN ('Y','N')),
+    BOOLEAN128 CHAR(1) NOT NULL CHECK (BOOLEAN128 IN ('Y','N')),
+    BOOLEAN129 CHAR(1) NOT NULL CHECK (BOOLEAN129 IN ('Y','N')),
+    BOOLEAN13 CHAR(1) NOT NULL CHECK (BOOLEAN13 IN ('Y','N')),
+    BOOLEAN130 CHAR(1) NOT NULL CHECK (BOOLEAN130 IN ('Y','N')),
+    BOOLEAN138 CHAR(1) NOT NULL CHECK (BOOLEAN138 IN ('Y','N')),
+    BOOLEAN139 CHAR(1) NOT NULL CHECK (BOOLEAN139 IN ('Y','N')),
+    BOOLEAN140 CHAR(1) NOT NULL CHECK (BOOLEAN140 IN ('Y','N')),
+    BOOLEAN16 CHAR(1) NOT NULL CHECK (BOOLEAN16 IN ('Y','N')),
+    BOOLEAN17 CHAR(1) NOT NULL CHECK (BOOLEAN17 IN ('Y','N')),
+    BOOLEAN18 CHAR(1) NOT NULL CHECK (BOOLEAN18 IN ('Y','N')),
+    BOOLEAN2 CHAR(1) NOT NULL CHECK (BOOLEAN2 IN ('Y','N')),
+    BOOLEAN20 CHAR(1) NOT NULL CHECK (BOOLEAN20 IN ('Y','N')),
+    BOOLEAN21 CHAR(1) NOT NULL CHECK (BOOLEAN21 IN ('Y','N')),
+    BOOLEAN22 CHAR(1) NOT NULL CHECK (BOOLEAN22 IN ('Y','N')),
+    BOOLEAN30 CHAR(1) NOT NULL CHECK (BOOLEAN30 IN ('Y','N')),
+    BOOLEAN31 CHAR(1) NOT NULL CHECK (BOOLEAN31 IN ('Y','N')),
+    BOOLEAN32 CHAR(1) NOT NULL CHECK (BOOLEAN32 IN ('Y','N')),
+    BOOLEAN36 CHAR(1) NOT NULL CHECK (BOOLEAN36 IN ('Y','N')),
+    BOOLEAN37 CHAR(1) NOT NULL CHECK (BOOLEAN37 IN ('Y','N')),
+    BOOLEAN38 CHAR(1) NOT NULL CHECK (BOOLEAN38 IN ('Y','N')),
+    BOOLEAN4 CHAR(1) NOT NULL CHECK (BOOLEAN4 IN ('Y','N')),
+    BOOLEAN40 CHAR(1) NOT NULL CHECK (BOOLEAN40 IN ('Y','N')),
+    BOOLEAN41 CHAR(1) NOT NULL CHECK (BOOLEAN41 IN ('Y','N')),
+    BOOLEAN42 CHAR(1) NOT NULL CHECK (BOOLEAN42 IN ('Y','N')),
+    BOOLEAN47 CHAR(1) NOT NULL CHECK (BOOLEAN47 IN ('Y','N')),
+    BOOLEAN48 CHAR(1) NOT NULL CHECK (BOOLEAN48 IN ('Y','N')),
+    BOOLEAN49 CHAR(1) NOT NULL CHECK (BOOLEAN49 IN ('Y','N')),
+    BOOLEAN5 CHAR(1) NOT NULL CHECK (BOOLEAN5 IN ('Y','N')),
+    BOOLEAN52 CHAR(1) NOT NULL CHECK (BOOLEAN52 IN ('Y','N')),
+    BOOLEAN53 CHAR(1) NOT NULL CHECK (BOOLEAN53 IN ('Y','N')),
+    BOOLEAN54 CHAR(1) NOT NULL CHECK (BOOLEAN54 IN ('Y','N')),
+    BOOLEAN56 CHAR(1) NOT NULL CHECK (BOOLEAN56 IN ('Y','N')),
+    BOOLEAN57 CHAR(1) NOT NULL CHECK (BOOLEAN57 IN ('Y','N')),
+    BOOLEAN58 CHAR(1) NOT NULL CHECK (BOOLEAN58 IN ('Y','N')),
+    BOOLEAN6 CHAR(1) NOT NULL CHECK (BOOLEAN6 IN ('Y','N')),
+    BOOLEAN66 CHAR(1) NOT NULL CHECK (BOOLEAN66 IN ('Y','N')),
+    BOOLEAN67 CHAR(1) NOT NULL CHECK (BOOLEAN67 IN ('Y','N')),
+    BOOLEAN68 CHAR(1) NOT NULL CHECK (BOOLEAN68 IN ('Y','N')),
+    BOOLEAN72 CHAR(1) NOT NULL CHECK (BOOLEAN72 IN ('Y','N')),
+    BOOLEAN73 CHAR(1) NOT NULL CHECK (BOOLEAN73 IN ('Y','N')),
+    BOOLEAN74 CHAR(1) NOT NULL CHECK (BOOLEAN74 IN ('Y','N')),
+    BOOLEAN76 CHAR(1) NOT NULL CHECK (BOOLEAN76 IN ('Y','N')),
+    BOOLEAN77 CHAR(1) NOT NULL CHECK (BOOLEAN77 IN ('Y','N')),
+    BOOLEAN78 CHAR(1) NOT NULL CHECK (BOOLEAN78 IN ('Y','N')),
+    BOOLEAN83 CHAR(1) NOT NULL CHECK (BOOLEAN83 IN ('Y','N')),
+    BOOLEAN84 CHAR(1) NOT NULL CHECK (BOOLEAN84 IN ('Y','N')),
+    BOOLEAN85 CHAR(1) NOT NULL CHECK (BOOLEAN85 IN ('Y','N')),
+    BOOLEAN88 CHAR(1) NOT NULL CHECK (BOOLEAN88 IN ('Y','N')),
+    BOOLEAN89 CHAR(1) NOT NULL CHECK (BOOLEAN89 IN ('Y','N')),
+    BOOLEAN90 CHAR(1) NOT NULL CHECK (BOOLEAN90 IN ('Y','N')),
+    BOOLEAN92 CHAR(1) NOT NULL CHECK (BOOLEAN92 IN ('Y','N')),
+    BOOLEAN93 CHAR(1) NOT NULL CHECK (BOOLEAN93 IN ('Y','N')),
+    BOOLEAN94 CHAR(1) NOT NULL CHECK (BOOLEAN94 IN ('Y','N'))
+);
+
+ALTER TABLE FIELDSOFPRIMITIVEBOOLEAN ADD CONSTRAINT FIELDSOFPRIMC2_PK PRIMARY KEY (IDENTIFIER);
+
+CREATE TABLE FIELDSOFPRIMITIVEBYTE
+(
+    IDENTIFIER INTEGER NOT NULL,
+    BYTE0 SMALLINT NOT NULL,
+    BYTE1 SMALLINT NOT NULL,
+    BYTE102 SMALLINT NOT NULL,
+    BYTE103 SMALLINT NOT NULL,
+    BYTE104 SMALLINT NOT NULL,
+    BYTE108 SMALLINT NOT NULL,
+    BYTE109 SMALLINT NOT NULL,
+    BYTE11 SMALLINT NOT NULL,
+    BYTE110 SMALLINT NOT NULL,
+    BYTE112 SMALLINT NOT NULL,
+    BYTE113 SMALLINT NOT NULL,
+    BYTE114 SMALLINT NOT NULL,
+    BYTE119 SMALLINT NOT NULL,
+    BYTE12 SMALLINT NOT NULL,
+    BYTE120 SMALLINT NOT NULL,
+    BYTE121 SMALLINT NOT NULL,
+    BYTE124 SMALLINT NOT NULL,
+    BYTE125 SMALLINT NOT NULL,
+    BYTE126 SMALLINT NOT NULL,
+    BYTE128 SMALLINT NOT NULL,
+    BYTE129 SMALLINT NOT NULL,
+    BYTE13 SMALLINT NOT NULL,
+    BYTE130 SMALLINT NOT NULL,
+    BYTE138 SMALLINT NOT NULL,
+    BYTE139 SMALLINT NOT NULL,
+    BYTE140 SMALLINT NOT NULL,
+    BYTE16 SMALLINT NOT NULL,
+    BYTE17 SMALLINT NOT NULL,
+    BYTE18 SMALLINT NOT NULL,
+    BYTE2 SMALLINT NOT NULL,
+    BYTE20 SMALLINT NOT NULL,
+    BYTE21 SMALLINT NOT NULL,
+    BYTE22 SMALLINT NOT NULL,
+    BYTE30 SMALLINT NOT NULL,
+    BYTE31 SMALLINT NOT NULL,
+    BYTE32 SMALLINT NOT NULL,
+    BYTE36 SMALLINT NOT NULL,
+    BYTE37 SMALLINT NOT NULL,
+    BYTE38 SMALLINT NOT NULL,
+    BYTE4 SMALLINT NOT NULL,
+    BYTE40 SMALLINT NOT NULL,
+    BYTE41 SMALLINT NOT NULL,
+    BYTE42 SMALLINT NOT NULL,
+    BYTE47 SMALLINT NOT NULL,
+    BYTE48 SMALLINT NOT NULL,
+    BYTE49 SMALLINT NOT NULL,
+    BYTE5 SMALLINT NOT NULL,
+    BYTE52 SMALLINT NOT NULL,
+    BYTE53 SMALLINT NOT NULL,
+    BYTE54 SMALLINT NOT NULL,
+    BYTE56 SMALLINT NOT NULL,
+    BYTE57 SMALLINT NOT NULL,
+    BYTE58 SMALLINT NOT NULL,
+    BYTE6 SMALLINT NOT NULL,
+    BYTE66 SMALLINT NOT NULL,
+    BYTE67 SMALLINT NOT NULL,
+    BYTE68 SMALLINT NOT NULL,
+    BYTE72 SMALLINT NOT NULL,
+    BYTE73 SMALLINT NOT NULL,
+    BYTE74 SMALLINT NOT NULL,
+    BYTE76 SMALLINT NOT NULL,
+    BYTE77 SMALLINT NOT NULL,
+    BYTE78 SMALLINT NOT NULL,
+    BYTE83 SMALLINT NOT NULL,
+    BYTE84 SMALLINT NOT NULL,
+    BYTE85 SMALLINT NOT NULL,
+    BYTE88 SMALLINT NOT NULL,
+    BYTE89 SMALLINT NOT NULL,
+    BYTE90 SMALLINT NOT NULL,
+    BYTE92 SMALLINT NOT NULL,
+    BYTE93 SMALLINT NOT NULL,
+    BYTE94 SMALLINT NOT NULL
+);
+
+ALTER TABLE FIELDSOFPRIMITIVEBYTE ADD CONSTRAINT FIELDSOFPRIMSD_PK PRIMARY KEY (IDENTIFIER);
+
+CREATE TABLE FIELDSOFPRIMITIVECHAR
+(
+    IDENTIFIER INTEGER NOT NULL,
+    CHAR0 INTEGER NOT NULL,
+    CHAR1 INTEGER NOT NULL,
+    CHAR102 INTEGER NOT NULL,
+    CHAR103 INTEGER NOT NULL,
+    CHAR104 INTEGER NOT NULL,
+    CHAR108 INTEGER NOT NULL,
+    CHAR109 INTEGER NOT NULL,
+    CHAR11 INTEGER NOT NULL,
+    CHAR110 INTEGER NOT NULL,
+    CHAR112 INTEGER NOT NULL,
+    CHAR113 INTEGER NOT NULL,
+    CHAR114 INTEGER NOT NULL,
+    CHAR119 INTEGER NOT NULL,
+    CHAR12 INTEGER NOT NULL,
+    CHAR120 INTEGER NOT NULL,
+    CHAR121 INTEGER NOT NULL,
+    CHAR124 INTEGER NOT NULL,
+    CHAR125 INTEGER NOT NULL,
+    CHAR126 INTEGER NOT NULL,
+    CHAR128 INTEGER NOT NULL,
+    CHAR129 INTEGER NOT NULL,
+    CHAR13 INTEGER NOT NULL,
+    CHAR130 INTEGER NOT NULL,
+    CHAR138 INTEGER NOT NULL,
+    CHAR139 INTEGER NOT NULL,
+    CHAR140 INTEGER NOT NULL,
+    CHAR16 INTEGER NOT NULL,
+    CHAR17 INTEGER NOT NULL,
+    CHAR18 INTEGER NOT NULL,
+    CHAR2 INTEGER NOT NULL,
+    CHAR20 INTEGER NOT NULL,
+    CHAR21 INTEGER NOT NULL,
+    CHAR22 INTEGER NOT NULL,
+    CHAR30 INTEGER NOT NULL,
+    CHAR31 INTEGER NOT NULL,
+    CHAR32 INTEGER NOT NULL,
+    CHAR36 INTEGER NOT NULL,
+    CHAR37 INTEGER NOT NULL,
+    CHAR38 INTEGER NOT NULL,
+    CHAR4 INTEGER NOT NULL,
+    CHAR40 INTEGER NOT NULL,
+    CHAR41 INTEGER NOT NULL,
+    CHAR42 INTEGER NOT NULL,
+    CHAR47 INTEGER NOT NULL,
+    CHAR48 INTEGER NOT NULL,
+    CHAR49 INTEGER NOT NULL,
+    CHAR5 INTEGER NOT NULL,
+    CHAR52 INTEGER NOT NULL,
+    CHAR53 INTEGER NOT NULL,
+    CHAR54 INTEGER NOT NULL,
+    CHAR56 INTEGER NOT NULL,
+    CHAR57 INTEGER NOT NULL,
+    CHAR58 INTEGER NOT NULL,
+    CHAR6 INTEGER NOT NULL,
+    CHAR66 INTEGER NOT NULL,
+    CHAR67 INTEGER NOT NULL,
+    CHAR68 INTEGER NOT NULL,
+    CHAR72 INTEGER NOT NULL,
+    CHAR73 INTEGER NOT NULL,
+    CHAR74 INTEGER NOT NULL,
+    CHAR76 INTEGER NOT NULL,
+    CHAR77 INTEGER NOT NULL,
+    CHAR78 INTEGER NOT NULL,
+    CHAR83 INTEGER NOT NULL,
+    CHAR84 INTEGER NOT NULL,
+    CHAR85 INTEGER NOT NULL,
+    CHAR88 INTEGER NOT NULL,
+    CHAR89 INTEGER NOT NULL,
+    CHAR90 INTEGER NOT NULL,
+    CHAR92 INTEGER NOT NULL,
+    CHAR93 INTEGER NOT NULL,
+    CHAR94 INTEGER NOT NULL
+);
+
+ALTER TABLE FIELDSOFPRIMITIVECHAR ADD CONSTRAINT FIELDSOFPRIMQ3_PK PRIMARY KEY (IDENTIFIER);
+
+CREATE TABLE FIELDSOFPRIMITIVEDOUBLE
+(
+    IDENTIFIER INTEGER NOT NULL,
+    DOUBLE0 DOUBLE NOT NULL,
+    DOUBLE1 DOUBLE NOT NULL,
+    DOUBLE102 DOUBLE NOT NULL,
+    DOUBLE103 DOUBLE NOT NULL,
+    DOUBLE104 DOUBLE NOT NULL,
+    DOUBLE108 DOUBLE NOT NULL,
+    DOUBLE109 DOUBLE NOT NULL,
+    DOUBLE11 DOUBLE NOT NULL,
+    DOUBLE110 DOUBLE NOT NULL,
+    DOUBLE112 DOUBLE NOT NULL,
+    DOUBLE113 DOUBLE NOT NULL,
+    DOUBLE114 DOUBLE NOT NULL,
+    DOUBLE119 DOUBLE NOT NULL,
+    DOUBLE12 DOUBLE NOT NULL,
+    DOUBLE120 DOUBLE NOT NULL,
+    DOUBLE121 DOUBLE NOT NULL,
+    DOUBLE124 DOUBLE NOT NULL,
+    DOUBLE125 DOUBLE NOT NULL,
+    DOUBLE126 DOUBLE NOT NULL,
+    DOUBLE128 DOUBLE NOT NULL,
+    DOUBLE129 DOUBLE NOT NULL,
+    DOUBLE13 DOUBLE NOT NULL,
+    DOUBLE130 DOUBLE NOT NULL,
+    DOUBLE138 DOUBLE NOT NULL,
+    DOUBLE139 DOUBLE NOT NULL,
+    DOUBLE140 DOUBLE NOT NULL,
+    DOUBLE16 DOUBLE NOT NULL,
+    DOUBLE17 DOUBLE NOT NULL,
+    DOUBLE18 DOUBLE NOT NULL,
+    DOUBLE2 DOUBLE NOT NULL,
+    DOUBLE20 DOUBLE NOT NULL,
+    DOUBLE21 DOUBLE NOT NULL,
+    DOUBLE22 DOUBLE NOT NULL,
+    DOUBLE30 DOUBLE NOT NULL,
+    DOUBLE31 DOUBLE NOT NULL,
+    DOUBLE32 DOUBLE NOT NULL,
+    DOUBLE36 DOUBLE NOT NULL,
+    DOUBLE37 DOUBLE NOT NULL,
+    DOUBLE38 DOUBLE NOT NULL,
+    DOUBLE4 DOUBLE NOT NULL,
+    DOUBLE40 DOUBLE NOT NULL,
+    DOUBLE41 DOUBLE NOT NULL,
+    DOUBLE42 DOUBLE NOT NULL,
+    DOUBLE47 DOUBLE NOT NULL,
+    DOUBLE48 DOUBLE NOT NULL,
+    DOUBLE49 DOUBLE NOT NULL,
+    DOUBLE5 DOUBLE NOT NULL,
+    DOUBLE52 DOUBLE NOT NULL,
+    DOUBLE53 DOUBLE NOT NULL,
+    DOUBLE54 DOUBLE NOT NULL,
+    DOUBLE56 DOUBLE NOT NULL,
+    DOUBLE57 DOUBLE NOT NULL,
+    DOUBLE58 DOUBLE NOT NULL,
+    DOUBLE6 DOUBLE NOT NULL,
+    DOUBLE66 DOUBLE NOT NULL,
+    DOUBLE67 DOUBLE NOT NULL,
+    DOUBLE68 DOUBLE NOT NULL,
+    DOUBLE72 DOUBLE NOT NULL,
+    DOUBLE73 DOUBLE NOT NULL,
+    DOUBLE74 DOUBLE NOT NULL,
+    DOUBLE76 DOUBLE NOT NULL,
+    DOUBLE77 DOUBLE NOT NULL,
+    DOUBLE78 DOUBLE NOT NULL,
+    DOUBLE83 DOUBLE NOT NULL,
+    DOUBLE84 DOUBLE NOT NULL,
+    DOUBLE85 DOUBLE NOT NULL,
+    DOUBLE88 DOUBLE NOT NULL,
+    DOUBLE89 DOUBLE NOT NULL,
+    DOUBLE90 DOUBLE NOT NULL,
+    DOUBLE92 DOUBLE NOT NULL,
+    DOUBLE93 DOUBLE NOT NULL,
+    DOUBLE94 DOUBLE NOT NULL
+);
+
+ALTER TABLE FIELDSOFPRIMITIVEDOUBLE ADD CONSTRAINT FIELDSOFPRIMHH_PK PRIMARY KEY (IDENTIFIER);
+
+CREATE TABLE FIELDSOFPRIMITIVEFLOAT
+(
+    IDENTIFIER INTEGER NOT NULL,
+    FLOAT0 FLOAT NOT NULL,
+    FLOAT1 FLOAT NOT NULL,
+    FLOAT102 FLOAT NOT NULL,
+    FLOAT103 FLOAT NOT NULL,
+    FLOAT104 FLOAT NOT NULL,
+    FLOAT108 FLOAT NOT NULL,
+    FLOAT109 FLOAT NOT NULL,
+    FLOAT11 FLOAT NOT NULL,
+    FLOAT110 FLOAT NOT NULL,
+    FLOAT112 FLOAT NOT NULL,
+    FLOAT113 FLOAT NOT NULL,
+    FLOAT114 FLOAT NOT NULL,
+    FLOAT119 FLOAT NOT NULL,
+    FLOAT12 FLOAT NOT NULL,
+    FLOAT120 FLOAT NOT NULL,
+    FLOAT121 FLOAT NOT NULL,
+    FLOAT124 FLOAT NOT NULL,
+    FLOAT125 FLOAT NOT NULL,
+    FLOAT126 FLOAT NOT NULL,
+    FLOAT128 FLOAT NOT NULL,
+    FLOAT129 FLOAT NOT NULL,
+    FLOAT13 FLOAT NOT NULL,
+    FLOAT130 FLOAT NOT NULL,
+    FLOAT138 FLOAT NOT NULL,
+    FLOAT139 FLOAT NOT NULL,
+    FLOAT140 FLOAT NOT NULL,
+    FLOAT16 FLOAT NOT NULL,
+    FLOAT17 FLOAT NOT NULL,
+    FLOAT18 FLOAT NOT NULL,
+    FLOAT2 FLOAT NOT NULL,
+    FLOAT20 FLOAT NOT NULL,
+    FLOAT21 FLOAT NOT NULL,
+    FLOAT22 FLOAT NOT NULL,
+    FLOAT30 FLOAT NOT NULL,
+    FLOAT31 FLOAT NOT NULL,
+    FLOAT32 FLOAT NOT NULL,
+    FLOAT36 FLOAT NOT NULL,
+    FLOAT37 FLOAT NOT NULL,
+    FLOAT38 FLOAT NOT NULL,
+    FLOAT4 FLOAT NOT NULL,
+    FLOAT40 FLOAT NOT NULL,
+    FLOAT41 FLOAT NOT NULL,
+    FLOAT42 FLOAT NOT NULL,
+    FLOAT47 FLOAT NOT NULL,
+    FLOAT48 FLOAT NOT NULL,
+    FLOAT49 FLOAT NOT NULL,
+    FLOAT5 FLOAT NOT NULL,
+    FLOAT52 FLOAT NOT NULL,
+    FLOAT53 FLOAT NOT NULL,
+    FLOAT54 FLOAT NOT NULL,
+    FLOAT56 FLOAT NOT NULL,
+    FLOAT57 FLOAT NOT NULL,
+    FLOAT58 FLOAT NOT NULL,
+    FLOAT6 FLOAT NOT NULL,
+    FLOAT66 FLOAT NOT NULL,
+    FLOAT67 FLOAT NOT NULL,
+    FLOAT68 FLOAT NOT NULL,
+    FLOAT72 FLOAT NOT NULL,
+    FLOAT73 FLOAT NOT NULL,
+    FLOAT74 FLOAT NOT NULL,
+    FLOAT76 FLOAT NOT NULL,
+    FLOAT77 FLOAT NOT NULL,
+    FLOAT78 FLOAT NOT NULL,
+    FLOAT83 FLOAT NOT NULL,
+    FLOAT84 FLOAT NOT NULL,
+    FLOAT85 FLOAT NOT NULL,
+    FLOAT88 FLOAT NOT NULL,
+    FLOAT89 FLOAT NOT NULL,
+    FLOAT90 FLOAT NOT NULL,
+    FLOAT92 FLOAT NOT NULL,
+    FLOAT93 FLOAT NOT NULL,
+    FLOAT94 FLOAT NOT NULL
+);
+
+ALTER TABLE FIELDSOFPRIMITIVEFLOAT ADD CONSTRAINT FIELDSOFPRIMR3_PK PRIMARY KEY (IDENTIFIER);
+
+CREATE TABLE FIELDSOFPRIMITIVEINT
+(
+    IDENTIFIER INTEGER NOT NULL,
+    INT0 INTEGER NOT NULL,
+    INT1 INTEGER NOT NULL,
+    INT102 INTEGER NOT NULL,
+    INT103 INTEGER NOT NULL,
+    INT104 INTEGER NOT NULL,
+    INT108 INTEGER NOT NULL,
+    INT109 INTEGER NOT NULL,
+    INT11 INTEGER NOT NULL,
+    INT110 INTEGER NOT NULL,
+    INT112 INTEGER NOT NULL,
+    INT113 INTEGER NOT NULL,
+    INT114 INTEGER NOT NULL,
+    INT119 INTEGER NOT NULL,
+    INT12 INTEGER NOT NULL,
+    INT120 INTEGER NOT NULL,
+    INT121 INTEGER NOT NULL,
+    INT124 INTEGER NOT NULL,
+    INT125 INTEGER NOT NULL,
+    INT126 INTEGER NOT NULL,
+    INT128 INTEGER NOT NULL,
+    INT129 INTEGER NOT NULL,
+    INT13 INTEGER NOT NULL,
+    INT130 INTEGER NOT NULL,
+    INT138 INTEGER NOT NULL,
+    INT139 INTEGER NOT NULL,
+    INT140 INTEGER NOT NULL,
+    INT16 INTEGER NOT NULL,
+    INT17 INTEGER NOT NULL,
+    INT18 INTEGER NOT NULL,
+    INT2 INTEGER NOT NULL,
+    INT20 INTEGER NOT NULL,
+    INT21 INTEGER NOT NULL,
+    INT22 INTEGER NOT NULL,
+    INT30 INTEGER NOT NULL,
+    INT31 INTEGER NOT NULL,
+    INT32 INTEGER NOT NULL,
+    INT36 INTEGER NOT NULL,
+    INT37 INTEGER NOT NULL,
+    INT38 INTEGER NOT NULL,
+    INT4 INTEGER NOT NULL,
+    INT40 INTEGER NOT NULL,
+    INT41 INTEGER NOT NULL,
+    INT42 INTEGER NOT NULL,
+    INT47 INTEGER NOT NULL,
+    INT48 INTEGER NOT NULL,
+    INT49 INTEGER NOT NULL,
+    INT5 INTEGER NOT NULL,
+    INT52 INTEGER NOT NULL,
+    INT53 INTEGER NOT NULL,
+    INT54 INTEGER NOT NULL,
+    INT56 INTEGER NOT NULL,
+    INT57 INTEGER NOT NULL,
+    INT58 INTEGER NOT NULL,
+    INT6 INTEGER NOT NULL,
+    INT66 INTEGER NOT NULL,
+    INT67 INTEGER NOT NULL,
+    INT68 INTEGER NOT NULL,
+    INT72 INTEGER NOT NULL,
+    INT73 INTEGER NOT NULL,
+    INT74 INTEGER NOT NULL,
+    INT76 INTEGER NOT NULL,
+    INT77 INTEGER NOT NULL,
+    INT78 INTEGER NOT NULL,
+    INT83 INTEGER NOT NULL,
+    INT84 INTEGER NOT NULL,
+    INT85 INTEGER NOT NULL,
+    INT88 INTEGER NOT NULL,
+    INT89 INTEGER NOT NULL,
+    INT90 INTEGER NOT NULL,
+    INT92 INTEGER NOT NULL,
+    INT93 INTEGER NOT NULL,
+    INT94 INTEGER NOT NULL
+);
+
+ALTER TABLE FIELDSOFPRIMITIVEINT ADD CONSTRAINT FIELDSOFPRIMT6_PK PRIMARY KEY (IDENTIFIER);
+
+CREATE TABLE FIELDSOFPRIMITIVELONG
+(
+    IDENTIFIER INTEGER NOT NULL,
+    LONG0 BIGINT NOT NULL,
+    LONG1 BIGINT NOT NULL,
+    LONG102 BIGINT NOT NULL,
+    LONG103 BIGINT NOT NULL,
+    LONG104 BIGINT NOT NULL,
+    LONG108 BIGINT NOT NULL,
+    LONG109 BIGINT NOT NULL,
+    LONG11 BIGINT NOT NULL,
+    LONG110 BIGINT NOT NULL,
+    LONG112 BIGINT NOT NULL,
+    LONG113 BIGINT NOT NULL,
+    LONG114 BIGINT NOT NULL,
+    LONG119 BIGINT NOT NULL,
+    LONG12 BIGINT NOT NULL,
+    LONG120 BIGINT NOT NULL,
+    LONG121 BIGINT NOT NULL,
+    LONG124 BIGINT NOT NULL,
+    LONG125 BIGINT NOT NULL,
+    LONG126 BIGINT NOT NULL,
+    LONG128 BIGINT NOT NULL,
+    LONG129 BIGINT NOT NULL,
+    LONG13 BIGINT NOT NULL,
+    LONG130 BIGINT NOT NULL,
+    LONG138 BIGINT NOT NULL,
+    LONG139 BIGINT NOT NULL,
+    LONG140 BIGINT NOT NULL,
+    LONG16 BIGINT NOT NULL,
+    LONG17 BIGINT NOT NULL,
+    LONG18 BIGINT NOT NULL,
+    LONG2 BIGINT NOT NULL,
+    LONG20 BIGINT NOT NULL,
+    LONG21 BIGINT NOT NULL,
+    LONG22 BIGINT NOT NULL,
+    LONG30 BIGINT NOT NULL,
+    LONG31 BIGINT NOT NULL,
+    LONG32 BIGINT NOT NULL,
+    LONG36 BIGINT NOT NULL,
+    LONG37 BIGINT NOT NULL,
+    LONG38 BIGINT NOT NULL,
+    LONG4 BIGINT NOT NULL,
+    LONG40 BIGINT NOT NULL,
+    LONG41 BIGINT NOT NULL,
+    LONG42 BIGINT NOT NULL,
+    LONG47 BIGINT NOT NULL,
+    LONG48 BIGINT NOT NULL,
+    LONG49 BIGINT NOT NULL,
+    LONG5 BIGINT NOT NULL,
+    LONG52 BIGINT NOT NULL,
+    LONG53 BIGINT NOT NULL,
+    LONG54 BIGINT NOT NULL,
+    LONG56 BIGINT NOT NULL,
+    LONG57 BIGINT NOT NULL,
+    LONG58 BIGINT NOT NULL,
+    LONG6 BIGINT NOT NULL,
+    LONG66 BIGINT NOT NULL,
+    LONG67 BIGINT NOT NULL,
+    LONG68 BIGINT NOT NULL,
+    LONG72 BIGINT NOT NULL,
+    LONG73 BIGINT NOT NULL,
+    LONG74 BIGINT NOT NULL,
+    LONG76 BIGINT NOT NULL,
+    LONG77 BIGINT NOT NULL,
+    LONG78 BIGINT NOT NULL,
+    LONG83 BIGINT NOT NULL,
+    LONG84 BIGINT NOT NULL,
+    LONG85 BIGINT NOT NULL,
+    LONG88 BIGINT NOT NULL,
+    LONG89 BIGINT NOT NULL,
+    LONG90 BIGINT NOT NULL,
+    LONG92 BIGINT NOT NULL,
+    LONG93 BIGINT NOT NULL,
+    LONG94 BIGINT NOT NULL
+);
+
+ALTER TABLE FIELDSOFPRIMITIVELONG ADD CONSTRAINT FIELDSOFPRIMLL_PK PRIMARY KEY (IDENTIFIER);
+
+CREATE TABLE FIELDSOFPRIMITIVESHORT
+(
+    IDENTIFIER INTEGER NOT NULL,
+    SHORT0 SMALLINT NOT NULL,
+    SHORT1 SMALLINT NOT NULL,
+    SHORT102 SMALLINT NOT NULL,
+    SHORT103 SMALLINT NOT NULL,
+    SHORT104 SMALLINT NOT NULL,
+    SHORT108 SMALLINT NOT NULL,
+    SHORT109 SMALLINT NOT NULL,
+    SHORT11 SMALLINT NOT NULL,
+    SHORT110 SMALLINT NOT NULL,
+    SHORT112 SMALLINT NOT NULL,
+    SHORT113 SMALLINT NOT NULL,
+    SHORT114 SMALLINT NOT NULL,
+    SHORT119 SMALLINT NOT NULL,
+    SHORT12 SMALLINT NOT NULL,
+    SHORT120 SMALLINT NOT NULL,
+    SHORT121 SMALLINT NOT NULL,
+    SHORT124 SMALLINT NOT NULL,
+    SHORT125 SMALLINT NOT NULL,
+    SHORT126 SMALLINT NOT NULL,
+    SHORT128 SMALLINT NOT NULL,
+    SHORT129 SMALLINT NOT NULL,
+    SHORT13 SMALLINT NOT NULL,
+    SHORT130 SMALLINT NOT NULL,
+    SHORT138 SMALLINT NOT NULL,
+    SHORT139 SMALLINT NOT NULL,
+    SHORT140 SMALLINT NOT NULL,
+    SHORT16 SMALLINT NOT NULL,
+    SHORT17 SMALLINT NOT NULL,
+    SHORT18 SMALLINT NOT NULL,
+    SHORT2 SMALLINT NOT NULL,
+    SHORT20 SMALLINT NOT NULL,
+    SHORT21 SMALLINT NOT NULL,
+    SHORT22 SMALLINT NOT NULL,
+    SHORT30 SMALLINT NOT NULL,
+    SHORT31 SMALLINT NOT NULL,
+    SHORT32 SMALLINT NOT NULL,
+    SHORT36 SMALLINT NOT NULL,
+    SHORT37 SMALLINT NOT NULL,
+    SHORT38 SMALLINT NOT NULL,
+    SHORT4 SMALLINT NOT NULL,
+    SHORT40 SMALLINT NOT NULL,
+    SHORT41 SMALLINT NOT NULL,
+    SHORT42 SMALLINT NOT NULL,
+    SHORT47 SMALLINT NOT NULL,
+    SHORT48 SMALLINT NOT NULL,
+    SHORT49 SMALLINT NOT NULL,
+    SHORT5 SMALLINT NOT NULL,
+    SHORT52 SMALLINT NOT NULL,
+    SHORT53 SMALLINT NOT NULL,
+    SHORT54 SMALLINT NOT NULL,
+    SHORT56 SMALLINT NOT NULL,
+    SHORT57 SMALLINT NOT NULL,
+    SHORT58 SMALLINT NOT NULL,
+    SHORT6 SMALLINT NOT NULL,
+    SHORT66 SMALLINT NOT NULL,
+    SHORT67 SMALLINT NOT NULL,
+    SHORT68 SMALLINT NOT NULL,
+    SHORT72 SMALLINT NOT NULL,
+    SHORT73 SMALLINT NOT NULL,
+    SHORT74 SMALLINT NOT NULL,
+    SHORT76 SMALLINT NOT NULL,
+    SHORT77 SMALLINT NOT NULL,
+    SHORT78 SMALLINT NOT NULL,
+    SHORT83 SMALLINT NOT NULL,
+    SHORT84 SMALLINT NOT NULL,
+    SHORT85 SMALLINT NOT NULL,
+    SHORT88 SMALLINT NOT NULL,
+    SHORT89 SMALLINT NOT NULL,
+    SHORT90 SMALLINT NOT NULL,
+    SHORT92 SMALLINT NOT NULL,
+    SHORT93 SMALLINT NOT NULL,
+    SHORT94 SMALLINT NOT NULL
+);
+
+ALTER TABLE FIELDSOFPRIMITIVESHORT ADD CONSTRAINT FIELDSOFPRIMXB_PK PRIMARY KEY (IDENTIFIER);
+
+CREATE TABLE FIELDSOFSHORT
+(
+    IDENTIFIER INTEGER NOT NULL,
+    SHORT0 SMALLINT,
+    SHORT1 SMALLINT,
+    SHORT102 SMALLINT,
+    SHORT103 SMALLINT,
+    SHORT104 SMALLINT,
+    SHORT108 SMALLINT,
+    SHORT109 SMALLINT,
+    SHORT11 SMALLINT,
+    SHORT110 SMALLINT,
+    SHORT112 SMALLINT,
+    SHORT113 SMALLINT,
+    SHORT114 SMALLINT,
+    SHORT119 SMALLINT,
+    SHORT12 SMALLINT,
+    SHORT120 SMALLINT,
+    SHORT121 SMALLINT,
+    SHORT124 SMALLINT,
+    SHORT125 SMALLINT,
+    SHORT126 SMALLINT,
+    SHORT128 SMALLINT,
+    SHORT129 SMALLINT,
+    SHORT13 SMALLINT,
+    SHORT130 SMALLINT,
+    SHORT138 SMALLINT,
+    SHORT139 SMALLINT,
+    SHORT140 SMALLINT,
+    SHORT16 SMALLINT,
+    SHORT17 SMALLINT,
+    SHORT18 SMALLINT,
+    SHORT2 SMALLINT,
+    SHORT20 SMALLINT,
+    SHORT21 SMALLINT,
+    SHORT22 SMALLINT,
+    SHORT30 SMALLINT,
+    SHORT31 SMALLINT,
+    SHORT32 SMALLINT,
+    SHORT36 SMALLINT,
+    SHORT37 SMALLINT,
+    SHORT38 SMALLINT,
+    SHORT4 SMALLINT,
+    SHORT40 SMALLINT,
+    SHORT41 SMALLINT,
+    SHORT42 SMALLINT,
+    SHORT47 SMALLINT,
+    SHORT48 SMALLINT,
+    SHORT49 SMALLINT,
+    SHORT5 SMALLINT,
+    SHORT52 SMALLINT,
+    SHORT53 SMALLINT,
+    SHORT54 SMALLINT,
+    SHORT56 SMALLINT,
+    SHORT57 SMALLINT,
+    SHORT58 SMALLINT,
+    SHORT6 SMALLINT,
+    SHORT66 SMALLINT,
+    SHORT67 SMALLINT,
+    SHORT68 SMALLINT,
+    SHORT72 SMALLINT,
+    SHORT73 SMALLINT,
+    SHORT74 SMALLINT,
+    SHORT76 SMALLINT,
+    SHORT77 SMALLINT,
+    SHORT78 SMALLINT,
+    SHORT83 SMALLINT,
+    SHORT84 SMALLINT,
+    SHORT85 SMALLINT,
+    SHORT88 SMALLINT,
+    SHORT89 SMALLINT,
+    SHORT90 SMALLINT,
+    SHORT92 SMALLINT,
+    SHORT93 SMALLINT,
+    SHORT94 SMALLINT
+);
+
+ALTER TABLE FIELDSOFSHORT ADD CONSTRAINT FIELDSOFSHORT_PK PRIMARY KEY (IDENTIFIER);
+
+CREATE TABLE FIELDSOFSTRING
+(
+    IDENTIFIER INTEGER NOT NULL,
+    STRING0 VARCHAR(255),
+    STRING1 VARCHAR(255),
+    STRING102 VARCHAR(255),
+    STRING103 VARCHAR(255),
+    STRING104 VARCHAR(255),
+    STRING108 VARCHAR(255),
+    STRING109 VARCHAR(255),
+    STRING11 VARCHAR(255),
+    STRING110 VARCHAR(255),
+    STRING112 VARCHAR(255),
+    STRING113 VARCHAR(255),
+    STRING114 VARCHAR(255),
+    STRING119 VARCHAR(255),
+    STRING12 VARCHAR(255),
+    STRING120 VARCHAR(255),
+    STRING121 VARCHAR(255),
+    STRING124 VARCHAR(255),
+    STRING125 VARCHAR(255),
+    STRING126 VARCHAR(255),
+    STRING128 VARCHAR(255),
+    STRING129 VARCHAR(255),
+    STRING13 VARCHAR(255),
+    STRING130 VARCHAR(255),
+    STRING138 VARCHAR(255),
+    STRING139 VARCHAR(255),
+    STRING140 VARCHAR(255),
+    STRING16 VARCHAR(255),
+    STRING17 VARCHAR(255),
+    STRING18 VARCHAR(255),
+    STRING2 VARCHAR(255),
+    STRING20 VARCHAR(255),
+    STRING21 VARCHAR(255),
+    STRING22 VARCHAR(255),
+    STRING30 VARCHAR(255),
+    STRING31 VARCHAR(255),
+    STRING32 VARCHAR(255),
+    STRING36 VARCHAR(255),
+    STRING37 VARCHAR(255),
+    STRING38 VARCHAR(255),
+    STRING4 VARCHAR(255),
+    STRING40 VARCHAR(255),
+    STRING41 VARCHAR(255),
+    STRING42 VARCHAR(255),
+    STRING47 VARCHAR(255),
+    STRING48 VARCHAR(255),
+    STRING49 VARCHAR(255),
+    STRING5 VARCHAR(255),
+    STRING52 VARCHAR(255),
+    STRING53 VARCHAR(255),
+    STRING54 VARCHAR(255),
+    STRING56 VARCHAR(255),
+    STRING57 VARCHAR(255),
+    STRING58 VARCHAR(255),
+    STRING6 VARCHAR(255),
+    STRING66 VARCHAR(255),
+    STRING67 VARCHAR(255),
+    STRING68 VARCHAR(255),
+    STRING72 VARCHAR(255),
+    STRING73 VARCHAR(255),
+    STRING74 VARCHAR(255),
+    STRING76 VARCHAR(255),
+    STRING77 VARCHAR(255),
+    STRING78 VARCHAR(255),
+    STRING83 VARCHAR(255),
+    STRING84 VARCHAR(255),
+    STRING85 VARCHAR(255),
+    STRING88 VARCHAR(255),
+    STRING89 VARCHAR(255),
+    STRING90 VARCHAR(255),
+    STRING92 VARCHAR(255),
+    STRING93 VARCHAR(255),
+    STRING94 VARCHAR(255)
+);
+
+ALTER TABLE FIELDSOFSTRING ADD CONSTRAINT FIELDSOFSTRING_PK PRIMARY KEY (IDENTIFIER);
+
+CREATE TABLE FieldsOfByte (
+    IDENTIFIER INTEGER NOT NULL,
+    BYTE0 SMALLINT,
+    BYTE1 SMALLINT,
+    BYTE2 SMALLINT,
+    BYTE4 SMALLINT,
+    BYTE5 SMALLINT,
+    BYTE6 SMALLINT,
+    BYTE11 SMALLINT,
+    BYTE12 SMALLINT,
+    BYTE13 SMALLINT,
+    BYTE16 SMALLINT,
+    BYTE17 SMALLINT,
+    BYTE18 SMALLINT,
+    BYTE20 SMALLINT,
+    BYTE21 SMALLINT,
+    BYTE22 SMALLINT,
+    BYTE30 SMALLINT,
+    BYTE31 SMALLINT,
+    BYTE32 SMALLINT,
+    BYTE36 SMALLINT,
+    BYTE37 SMALLINT,
+    BYTE38 SMALLINT,
+    BYTE40 SMALLINT,
+    BYTE41 SMALLINT,
+    BYTE42 SMALLINT,
+    BYTE43 SMALLINT,
+    BYTE47 SMALLINT,
+    BYTE48 SMALLINT,
+    BYTE49 SMALLINT,
+    BYTE52 SMALLINT,
+    BYTE53 SMALLINT,
+    BYTE54 SMALLINT,
+    BYTE56 SMALLINT,
+    BYTE57 SMALLINT,
+    BYTE58 SMALLINT,
+    BYTE66 SMALLINT,
+    BYTE67 SMALLINT,
+    BYTE68 SMALLINT,
+    BYTE72 SMALLINT,
+    BYTE73 SMALLINT,
+    BYTE74 SMALLINT,
+    BYTE76 SMALLINT,
+    BYTE77 SMALLINT,
+    BYTE78 SMALLINT,
+    BYTE83 SMALLINT,
+    BYTE84 SMALLINT,
+    BYTE85 SMALLINT,
+    BYTE88 SMALLINT,
+    BYTE89 SMALLINT,
+    BYTE90 SMALLINT,
+    BYTE92 SMALLINT,
+    BYTE93 SMALLINT,
+    BYTE94 SMALLINT,
+    BYTE102 SMALLINT,
+    BYTE103 SMALLINT,
+    BYTE104 SMALLINT,
+    BYTE108 SMALLINT,
+    BYTE109 SMALLINT,
+    BYTE110 SMALLINT,
+    BYTE112 SMALLINT,
+    BYTE113 SMALLINT,
+    BYTE114 SMALLINT,
+    BYTE119 SMALLINT,
+    BYTE120 SMALLINT,
+    BYTE121 SMALLINT,
+    BYTE124 SMALLINT,
+    BYTE125 SMALLINT,
+    BYTE126 SMALLINT,
+    BYTE128 SMALLINT,
+    BYTE129 SMALLINT,
+    BYTE130 SMALLINT,
+    BYTE138 SMALLINT,
+    BYTE139 SMALLINT,
+    BYTE140 SMALLINT,
+    CONSTRAINT FieldsOfByte_PK PRIMARY KEY (IDENTIFIER)
+);
+
+CREATE TABLE SIMPLE_CLASS
+(
+    IDENTIFIER BIGINT NOT NULL,
+    INTVAL INTEGER NOT NULL,
+    STRINGVAL VARCHAR(128) NOT NULL,
+    CONSTRAINT SIMPLE_CLASS_PK PRIMARY KEY (IDENTIFIER)
+);
+
+CREATE TABLE FIELDSOFSIMPLECLASS
+(
+    IDENTIFIER INTEGER NOT NULL,
+    SIMPLECLASS0 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS1 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS2 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS3 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS4 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS5 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS6 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS7 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS10 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS11 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS12 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS13 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS14 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS16 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS17 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS18 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS19 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS20 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS21 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS22 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS23 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS29 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS30 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS31 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS32 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS33 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS36 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS37 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS38 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS39 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS40 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS41 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS42 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS43 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS46 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS47 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS48 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS49 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS50 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS52 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS53 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS54 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS55 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS56 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS57 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS58 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS59 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS65 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS66 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS67 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS68 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS69 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS72 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS73 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS74 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS75 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS76 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS77 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS78 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS79 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS82 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS83 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS84 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS85 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS86 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS88 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS89 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS90 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS91 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS92 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS93 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS94 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS95 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS101 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS102 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS103 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS104 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS105 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS108 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS109 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS110 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS111 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS112 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS113 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS114 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS115 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS118 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS119 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS120 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS121 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS122 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS124 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS125 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS126 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS127 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS128 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS129 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS130 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS131 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS137 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS138 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS139 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS140 BIGINT REFERENCES SIMPLE_CLASS,
+    SIMPLECLASS141 BIGINT REFERENCES SIMPLE_CLASS
+);
+
+CREATE TABLE ARRAY_COLLECTIONS
+(
+   IDENTIFIER INTEGER NOT NULL,
+   ARRAY_OF_BIG_DECIMAL12 LONG VARCHAR FOR BIT DATA,
+   ARRAY_OF_BIG_DECIMAL13 LONG VARCHAR FOR BIT DATA,
+   ARRAY_OF_BIG_INTEGER14 LONG VARCHAR FOR BIT DATA,
+   ARRAY_OF_BIG_INTEGER15 LONG VARCHAR FOR BIT DATA,
+   ARRAY_OF_BYTE16 LONG VARCHAR FOR BIT DATA,
+   ARRAY_OF_BYTE17 LONG VARCHAR FOR BIT DATA,
+   ARRAY_OF_DATE8 LONG VARCHAR FOR BIT DATA,
+   ARRAY_OF_DATE9 LONG VARCHAR FOR BIT DATA,
+   ARRAY_OF_DOUBLE18 LONG VARCHAR FOR BIT DATA,
+   ARRAY_OF_DOUBLE19 LONG VARCHAR FOR BIT DATA,
+   ARRAY_OF_FLOAT20 LONG VARCHAR FOR BIT DATA,
+   ARRAY_OF_FLOAT21 LONG VARCHAR FOR BIT DATA,
+   ARRAY_OF_INTEGER22 LONG VARCHAR FOR BIT DATA,
+   ARRAY_OF_INTEGER23 LONG VARCHAR FOR BIT DATA,
+   ARRAY_OF_LOCALE10 LONG VARCHAR FOR BIT DATA,
+   ARRAY_OF_LOCALE11 LONG VARCHAR FOR BIT DATA,
+   ARRAY_OF_LONG24 LONG VARCHAR FOR BIT DATA,
+   ARRAY_OF_LONG25 LONG VARCHAR FOR BIT DATA,
+   ARRAY_OF_OBJECT0 LONG VARCHAR FOR BIT DATA,
+   ARRAY_OF_OBJECT1 LONG VARCHAR FOR BIT DATA,
+   ARRAY_OF_SHORT26 LONG VARCHAR FOR BIT DATA,
+   ARRAY_OF_SHORT27 LONG VARCHAR FOR BIT DATA,
+   ARRAY_OF_SIMPLE_INTERFACE4 LONG VARCHAR FOR BIT DATA,
+   ARRAY_OF_SIMPLE_INTERFACE5 LONG VARCHAR FOR BIT DATA,
+   ARRAY_OF_STRING6 LONG VARCHAR FOR BIT DATA,
+   ARRAY_OF_STRING7 LONG VARCHAR FOR BIT DATA
+);
+
+--CollectionCollections
+
+CREATE TABLE COLLECTION_COLLECTIONS
+(
+    IDENTIFIER INTEGER NOT NULL,
+    COLLECTION_OF_STRING9 LONG VARCHAR FOR BIT DATA,
+    COLLECTION_OF_STRING10 LONG VARCHAR FOR BIT DATA,
+    COLLECTION_OF_DATE12 LONG VARCHAR FOR BIT DATA,
+    COLLECTION_OF_DATE13 LONG VARCHAR FOR BIT DATA,
+    COLLECTION_OF_LOCALE15 LONG VARCHAR FOR BIT DATA,
+    COLLECTION_OF_LOCALE16 LONG VARCHAR FOR BIT DATA,
+    COLLECTION_OF_BIG_DECIMAL18 LONG VARCHAR FOR BIT DATA,
+    COLLECTION_OF_BIG_DECIMAL19 LONG VARCHAR FOR BIT DATA,
+    COLLECTION_OF_BIG_INTEGER21 LONG VARCHAR FOR BIT DATA,
+    COLLECTION_OF_BIG_INTEGER22 LONG VARCHAR FOR BIT DATA,
+    COLLECTION_OF_BYTE24 LONG VARCHAR FOR BIT DATA,
+    COLLECTION_OF_BYTE25 LONG VARCHAR FOR BIT DATA,
+    COLLECTION_OF_DOUBLE27 LONG VARCHAR FOR BIT DATA,
+    COLLECTION_OF_DOUBLE28 LONG VARCHAR FOR BIT DATA,
+    COLLECTION_OF_FLOAT30 LONG VARCHAR FOR BIT DATA,
+    COLLECTION_OF_FLOAT31 LONG VARCHAR FOR BIT DATA,
+    COLLECTION_OF_INTEGER33  LONG VARCHAR FOR BIT DATA,
+    COLLECTION_OF_INTEGER34 LONG VARCHAR FOR BIT DATA,
+    COLLECTION_OF_LONG36 LONG VARCHAR FOR BIT DATA,
+    COLLECTION_OF_LONG37 LONG VARCHAR FOR BIT DATA,
+    COLLECTION_OF_SHORT39 LONG VARCHAR FOR BIT DATA,
+    COLLECTION_OF_SHORT40 LONG VARCHAR FOR BIT DATA,
+    CONSTRAINT CC_PK PRIMARY KEY (IDENTIFIER)
+);
+
+CREATE TABLE COLLECTION_OF_OBJECT0
+(
+    IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL,
+    OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
+);
+
+CREATE TABLE COLLECTION_OF_OBJECT1
+(
+    IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL,
+    OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
+);
+
+CREATE TABLE COLLECTION_OF_OBJECT2
+(
+    IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL,
+    OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
+);
+
+CREATE TABLE COLLECTION_OF_SIMPLE_CLASS3
+(
+    IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL,
+    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
+);
+
+CREATE TABLE COLLECTION_OF_SIMPLE_CLASS4
+(
+    IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL,
+    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
+);
+
+CREATE TABLE COLLECTION_OF_SIMPLE_CLASS5
+(
+    IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL,
+    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
+);
+
+CREATE TABLE COLLECTION_OF_SIMPLE_INTERFACE6
+(
+    IDENTIFIER INTEGER REFERENCES COLLECTION_COLLECTIONS NOT NULL,
+    SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL
+);
+

[... 4360 lines stripped ...]


Mime
View raw message