Return-Path: Delivered-To: apmail-db-jdo-commits-archive@www.apache.org Received: (qmail 95244 invoked from network); 23 Jun 2005 19:16:48 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 23 Jun 2005 19:16:48 -0000 Received: (qmail 3764 invoked by uid 500); 23 Jun 2005 19:16:46 -0000 Mailing-List: contact jdo-commits-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: jdo-dev@db.apache.org Delivered-To: mailing list jdo-commits@db.apache.org Received: (qmail 3572 invoked by uid 99); 23 Jun 2005 19:16:45 -0000 X-ASF-Spam-Status: No, hits=0.7 required=10.0 tests=NO_REAL_NAME,UPPERCASE_75_100 X-Spam-Check-By: apache.org Received: from [209.237.227.194] (HELO minotaur.apache.org) (209.237.227.194) by apache.org (qpsmtpd/0.29) with SMTP; Thu, 23 Jun 2005 12:16:41 -0700 Received: (qmail 95131 invoked by uid 65534); 23 Jun 2005 19:16:41 -0000 Message-ID: <20050623191641.95128.qmail@minotaur.apache.org> Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Subject: svn commit: r193203 [4/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 -0000 To: jdo-commits@db.apache.org From: mcaisse@apache.org X-Mailer: svnmailer-1.0.2 X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N Added: 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=193203&view=auto ============================================================================== --- incubator/jdo/trunk/tck20/test/sql/derby/datastoreidentity/schema.sql (added) +++ incubator/jdo/trunk/tck20/test/sql/derby/datastoreidentity/schema.sql Thu Jun 23 12:16:32 2005 @@ -0,0 +1,7150 @@ +-- SchemaType: datastore identity + +connect 'jdbc:derby:jdotckdb;create=true' user 'tckuser' password 'tckuser'; + +CREATE SCHEMA datastoreidentity0; +SET SCHEMA datastoreidentity0; + +------------------------- +-- mylib +------------------------- + +DROP TABLE PCRect; +DROP TABLE PCPoint; +DROP TABLE PCPoint2; +DROP TABLE PrimitiveTypes; + +CREATE TABLE PCPoint ( + DATASTORE_IDENTITY BIGINT NOT NULL GENERATED ALWAYS AS IDENTITY, + ID BIGINT, + X INTEGER NOT NULL, + Y INTEGER, + CONSTRAINT PCPNT_CONST PRIMARY KEY (DATASTORE_IDENTITY) +); + +CREATE TABLE PCPoint2 ( + DATASTORE_IDENTITY BIGINT NOT NULL GENERATED ALWAYS AS IDENTITY, + ID BIGINT, + X INTEGER NOT NULL, + Y INTEGER, + CONSTRAINT PCPNT2_CONST PRIMARY KEY (DATASTORE_IDENTITY) +); + +CREATE TABLE PCRect ( + DATASTORE_IDENTITY BIGINT NOT NULL GENERATED ALWAYS AS IDENTITY, + ID BIGINT, + UPPER_LEFT BIGINT REFERENCES PCPoint NOT NULL, + LOWER_RIGHT BIGINT REFERENCES PCPoint NOT NULL, + CONSTRAINT PCRCT_CONST PRIMARY KEY (DATASTORE_IDENTITY) +); + +CREATE TABLE PrimitiveTypes ( + DATASTORE_IDENTITY BIGINT NOT NULL GENERATED ALWAYS AS IDENTITY, + ID BIGINT, + 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 (DATASTORE_IDENTITY) +); + +------------------------- +-- 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 ( + DATASTORE_IDENTITY INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY, + ID INTEGER, + 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 (DATASTORE_IDENTITY) +); + +CREATE TABLE departments ( + DATASTORE_IDENTITY INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY, + ID INTEGER, + NAME VARCHAR(32) NOT NULL, + EMP_OF_THE_MONTH INTEGER, + COMPANYID INTEGER REFERENCES companies, + CONSTRAINT DEPTS_PK PRIMARY KEY (DATASTORE_IDENTITY) +); + +CREATE TABLE persons ( + DATASTORE_IDENTITY INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY, + PERSONID INTEGER, + 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 (DATASTORE_IDENTITY) +); + +CREATE TABLE insuranceplans ( + DATASTORE_IDENTITY INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY, + INSID INTEGER, + 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 (DATASTORE_IDENTITY) +); + +CREATE TABLE projects ( + DATASTORE_IDENTITY INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY, + PROJID INTEGER, + NAME VARCHAR(32) NOT NULL, + BUDGET DECIMAL(11,2) NOT NULL, + CONSTRAINT PROJS_PK PRIMARY KEY (DATASTORE_IDENTITY) +); + +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(DATASTORE_IDENTITY) +; + +------------------------- +--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 +( + DATASTORE_IDENTITY INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY, + ID INTEGER, + 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 (DATASTORE_IDENTITY); + +CREATE TABLE FIELDSOFBIGDECIMAL +( + DATASTORE_IDENTITY INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY, + IDENTIFIER INTEGER, + 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 (DATASTORE_IDENTITY); + +CREATE TABLE FIELDSOFBIGINTEGER +( + DATASTORE_IDENTITY INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY, + IDENTIFIER INTEGER, + 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 (DATASTORE_IDENTITY); + +CREATE TABLE FIELDSOFBOOLEAN +( + DATASTORE_IDENTITY INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY, + IDENTIFIER INTEGER, + 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 (DATASTORE_IDENTITY); + +CREATE TABLE FIELDSOFCHARACTER +( + DATASTORE_IDENTITY INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY, + 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); + +CREATE TABLE FIELDSOFDATE +( + DATASTORE_IDENTITY INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY, + IDENTIFIER INTEGER, + 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 (DATASTORE_IDENTITY); + +CREATE TABLE FIELDSOFDOUBLE +( + DATASTORE_IDENTITY INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY, + IDENTIFIER INTEGER, + 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 (DATASTORE_IDENTITY); + +CREATE TABLE FIELDSOFFLOAT +( + DATASTORE_IDENTITY INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY, + IDENTIFIER INTEGER, + 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 (DATASTORE_IDENTITY); + +CREATE TABLE FIELDSOFINTEGER +( + DATASTORE_IDENTITY INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY, + IDENTIFIER INTEGER, + 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 (DATASTORE_IDENTITY); + +CREATE TABLE FIELDSOFLOCALE +( + DATASTORE_IDENTITY INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY, + IDENTIFIER INTEGER, + 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 (DATASTORE_IDENTITY); + +CREATE TABLE FIELDSOFLONG +( + DATASTORE_IDENTITY INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY, + IDENTIFIER INTEGER, + 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 (DATASTORE_IDENTITY); + +CREATE TABLE FIELDSOFOBJECT +( + DATASTORE_IDENTITY INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY, + IDENTIFIER INTEGER, + 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 (DATASTORE_IDENTITY); + +CREATE TABLE FIELDSOFSIMPLEINTERFACE +( + DATASTORE_IDENTITY INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY, + IDENTIFIER INTEGER, + 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 (DATASTORE_IDENTITY); + +CREATE TABLE FIELDSOFPRIMITIVEBOOLEAN +( + DATASTORE_IDENTITY INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY, + IDENTIFIER INTEGER, + 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 (DATASTORE_IDENTITY); + +CREATE TABLE FIELDSOFPRIMITIVEBYTE +( + DATASTORE_IDENTITY INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY, + IDENTIFIER INTEGER, + 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 (DATASTORE_IDENTITY); + +CREATE TABLE FIELDSOFPRIMITIVECHAR +( + DATASTORE_IDENTITY INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY, + IDENTIFIER INTEGER, + 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 (DATASTORE_IDENTITY); + +CREATE TABLE FIELDSOFPRIMITIVEDOUBLE +( + DATASTORE_IDENTITY INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY, + IDENTIFIER INTEGER, + 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 (DATASTORE_IDENTITY); + +CREATE TABLE FIELDSOFPRIMITIVEFLOAT +( + DATASTORE_IDENTITY INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY, + IDENTIFIER INTEGER, + 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 (DATASTORE_IDENTITY); + +CREATE TABLE FIELDSOFPRIMITIVEINT +( + DATASTORE_IDENTITY INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY, + IDENTIFIER INTEGER, + 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 (DATASTORE_IDENTITY); + +CREATE TABLE FIELDSOFPRIMITIVELONG +( + DATASTORE_IDENTITY INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY, + IDENTIFIER INTEGER, + 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 (DATASTORE_IDENTITY); + +CREATE TABLE FIELDSOFPRIMITIVESHORT +( + DATASTORE_IDENTITY INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY, + IDENTIFIER INTEGER, + 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 (DATASTORE_IDENTITY); + +CREATE TABLE FIELDSOFSHORT +( + DATASTORE_IDENTITY INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY, + IDENTIFIER INTEGER, + 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 (DATASTORE_IDENTITY); + +CREATE TABLE FIELDSOFSTRING +( + DATASTORE_IDENTITY INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY, + IDENTIFIER INTEGER, + 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 (DATASTORE_IDENTITY); + +CREATE TABLE FieldsOfByte ( + DATASTORE_IDENTITY INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY, + IDENTIFIER INTEGER, + 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 (DATASTORE_IDENTITY) +); + +CREATE TABLE SIMPLE_CLASS +( + DATASTORE_IDENTITY BIGINT NOT NULL GENERATED ALWAYS AS IDENTITY, + IDENTIFIER BIGINT, + INTVAL INTEGER NOT NULL, + STRINGVAL VARCHAR(128) NOT NULL, + CONSTRAINT SIMPLE_CLASS_PK PRIMARY KEY (DATASTORE_IDENTITY) +); + +CREATE TABLE FIELDSOFSIMPLECLASS +( + DATASTORE_IDENTITY INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY, + IDENTIFIER INTEGER, + 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 +( + DATASTORE_IDENTITY INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY, + IDENTIFIER INTEGER, + 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 + [... 4453 lines stripped ...]