Added: incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/FieldsOfPrimitiveint-derby.orm URL: http://svn.apache.org/viewcvs/incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/FieldsOfPrimitiveint-derby.orm?rev=164672&view=auto ============================================================================== --- incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/FieldsOfPrimitiveint-derby.orm (added) +++ incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/FieldsOfPrimitiveint-derby.orm Mon Apr 25 15:26:24 2005 @@ -0,0 +1,81 @@ +<?xml version="1.0" encoding="UTF-8"?> +<!DOCTYPE orm PUBLIC "-//Sun Microsystems, Inc.//DTD Java Data Objects Metadata 2.0//EN" "http://java.sun.com/dtd/orm_2_0.dtd"> +<orm> + <package name="org.apache.jdo.tck.pc.fieldtypes"> + <class name="FieldsOfPrimitiveint" table="FIELDSOFPRIMITIVEINT"> + <field name="identifier" primary-key="true" column="IDENTIFIER"/> + <field name="int0" column="INT0"/> + <field name="int1" column="INT1"/> + <field name="int102" column="INT102"/> + <field name="int103" column="INT103"/> + <field name="int104" column="INT104"/> + <field name="int108" column="INT108"/> + <field name="int109" column="INT109"/> + <field name="int11" column="INT11"/> + <field name="int110" column="INT110"/> + <field name="int112" column="INT112"/> + <field name="int113" column="INT113"/> + <field name="int114" column="INT114"/> + <field name="int119" column="INT119"/> + <field name="int12" column="INT12"/> + <field name="int120" column="INT120"/> + <field name="int121" column="INT121"/> + <field name="int124" column="INT124"/> + <field name="int125" column="INT125"/> + <field name="int126" column="INT126"/> + <field name="int128" column="INT128"/> + <field name="int129" column="INT129"/> + <field name="int13" column="INT13"/> + <field name="int130" column="INT130"/> + <field name="int138" column="INT138"/> + <field name="int139" column="INT139"/> + <field name="int140" column="INT140"/> + <field name="int16" column="INT16"/> + <field name="int17" column="INT17"/> + <field name="int18" column="INT18"/> + <field name="int2" column="INT2"/> + <field name="int20" column="INT20"/> + <field name="int21" column="INT21"/> + <field name="int22" column="INT22"/> + <field name="int30" column="INT30"/> + <field name="int31" column="INT31"/> + <field name="int32" column="INT32"/> + <field name="int36" column="INT36"/> + <field name="int37" column="INT37"/> + <field name="int38" column="INT38"/> + <field name="int4" column="INT4"/> + <field name="int40" column="INT40"/> + <field name="int41" column="INT41"/> + <field name="int42" column="INT42"/> + <field name="int47" column="INT47"/> + <field name="int48" column="INT48"/> + <field name="int49" column="INT49"/> + <field name="int5" column="INT5"/> + <field name="int52" column="INT52"/> + <field name="int53" column="INT53"/> + <field name="int54" column="INT54"/> + <field name="int56" column="INT56"/> + <field name="int57" column="INT57"/> + <field name="int58" column="INT58"/> + <field name="int6" column="INT6"/> + <field name="int66" column="INT66"/> + <field name="int67" column="INT67"/> + <field name="int68" column="INT68"/> + <field name="int72" column="INT72"/> + <field name="int73" column="INT73"/> + <field name="int74" column="INT74"/> + <field name="int76" column="INT76"/> + <field name="int77" column="INT77"/> + <field name="int78" column="INT78"/> + <field name="int83" column="INT83"/> + <field name="int84" column="INT84"/> + <field name="int85" column="INT85"/> + <field name="int88" column="INT88"/> + <field name="int89" column="INT89"/> + <field name="int90" column="INT90"/> + <field name="int92" column="INT92"/> + <field name="int93" column="INT93"/> + <field name="int94" column="INT94"/> + </class> + </package> +</orm>
Propchange: incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/FieldsOfPrimitiveint-derby.orm ------------------------------------------------------------------------------ svn:executable = * Added: incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/FieldsOfPrimitivelong-derby.orm URL: http://svn.apache.org/viewcvs/incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/FieldsOfPrimitivelong-derby.orm?rev=164672&view=auto ============================================================================== --- incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/FieldsOfPrimitivelong-derby.orm (added) +++ incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/FieldsOfPrimitivelong-derby.orm Mon Apr 25 15:26:24 2005 @@ -0,0 +1,81 @@ +<?xml version="1.0" encoding="UTF-8"?> +<!DOCTYPE orm PUBLIC "-//Sun Microsystems, Inc.//DTD Java Data Objects Metadata 2.0//EN" "http://java.sun.com/dtd/orm_2_0.dtd"> +<orm> + <package name="org.apache.jdo.tck.pc.fieldtypes"> + <class name="FieldsOfPrimitivelong" table="FIELDSOFPRIMITIVELONG"> + <field name="identifier" primary-key="true" column="IDENTIFIER"/> + <field name="long0" column="LONG0"/> + <field name="long1" column="LONG1"/> + <field name="long102" column="LONG102"/> + <field name="long103" column="LONG103"/> + <field name="long104" column="LONG104"/> + <field name="long108" column="LONG108"/> + <field name="long109" column="LONG109"/> + <field name="long11" column="LONG11"/> + <field name="long110" column="LONG110"/> + <field name="long112" column="LONG112"/> + <field name="long113" column="LONG113"/> + <field name="long114" column="LONG114"/> + <field name="long119" column="LONG119"/> + <field name="long12" column="LONG12"/> + <field name="long120" column="LONG120"/> + <field name="long121" column="LONG121"/> + <field name="long124" column="LONG124"/> + <field name="long125" column="LONG125"/> + <field name="long126" column="LONG126"/> + <field name="long128" column="LONG128"/> + <field name="long129" column="LONG129"/> + <field name="long13" column="LONG13"/> + <field name="long130" column="LONG130"/> + <field name="long138" column="LONG138"/> + <field name="long139" column="LONG139"/> + <field name="long140" column="LONG140"/> + <field name="long16" column="LONG16"/> + <field name="long17" column="LONG17"/> + <field name="long18" column="LONG18"/> + <field name="long2" column="LONG2"/> + <field name="long20" column="LONG20"/> + <field name="long21" column="LONG21"/> + <field name="long22" column="LONG22"/> + <field name="long30" column="LONG30"/> + <field name="long31" column="LONG31"/> + <field name="long32" column="LONG32"/> + <field name="long36" column="LONG36"/> + <field name="long37" column="LONG37"/> + <field name="long38" column="LONG38"/> + <field name="long4" column="LONG4"/> + <field name="long40" column="LONG40"/> + <field name="long41" column="LONG41"/> + <field name="long42" column="LONG42"/> + <field name="long47" column="LONG47"/> + <field name="long48" column="LONG48"/> + <field name="long49" column="LONG49"/> + <field name="long5" column="LONG5"/> + <field name="long52" column="LONG52"/> + <field name="long53" column="LONG53"/> + <field name="long54" column="LONG54"/> + <field name="long56" column="LONG56"/> + <field name="long57" column="LONG57"/> + <field name="long58" column="LONG58"/> + <field name="long6" column="LONG6"/> + <field name="long66" column="LONG66"/> + <field name="long67" column="LONG67"/> + <field name="long68" column="LONG68"/> + <field name="long72" column="LONG72"/> + <field name="long73" column="LONG73"/> + <field name="long74" column="LONG74"/> + <field name="long76" column="LONG76"/> + <field name="long77" column="LONG77"/> + <field name="long78" column="LONG78"/> + <field name="long83" column="LONG83"/> + <field name="long84" column="LONG84"/> + <field name="long85" column="LONG85"/> + <field name="long88" column="LONG88"/> + <field name="long89" column="LONG89"/> + <field name="long90" column="LONG90"/> + <field name="long92" column="LONG92"/> + <field name="long93" column="LONG93"/> + <field name="long94" column="LONG94"/> + </class> + </package> +</orm> Propchange: incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/FieldsOfPrimitivelong-derby.orm ------------------------------------------------------------------------------ svn:executable = * Added: incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/FieldsOfPrimitiveshort-derby.orm URL: http://svn.apache.org/viewcvs/incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/FieldsOfPrimitiveshort-derby.orm?rev=164672&view=auto ============================================================================== --- incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/FieldsOfPrimitiveshort-derby.orm (added) +++ incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/FieldsOfPrimitiveshort-derby.orm Mon Apr 25 15:26:24 2005 @@ -0,0 +1,81 @@ +<?xml version="1.0" encoding="UTF-8"?> +<!DOCTYPE orm PUBLIC "-//Sun Microsystems, Inc.//DTD Java Data Objects Metadata 2.0//EN" "http://java.sun.com/dtd/orm_2_0.dtd"> +<orm> + <package name="org.apache.jdo.tck.pc.fieldtypes"> + <class name="FieldsOfPrimitiveshort" table="FIELDSOFPRIMITIVESHORT"> + <field name="identifier" primary-key="true" column="IDENTIFIER"/> + <field name="short0" column="SHORT0"/> + <field name="short1" column="SHORT1"/> + <field name="short102" column="SHORT102"/> + <field name="short103" column="SHORT103"/> + <field name="short104" column="SHORT104"/> + <field name="short108" column="SHORT108"/> + <field name="short109" column="SHORT109"/> + <field name="short11" column="SHORT11"/> + <field name="short110" column="SHORT110"/> + <field name="short112" column="SHORT112"/> + <field name="short113" column="SHORT113"/> + <field name="short114" column="SHORT114"/> + <field name="short119" column="SHORT119"/> + <field name="short12" column="SHORT12"/> + <field name="short120" column="SHORT120"/> + <field name="short121" column="SHORT121"/> + <field name="short124" column="SHORT124"/> + <field name="short125" column="SHORT125"/> + <field name="short126" column="SHORT126"/> + <field name="short128" column="SHORT128"/> + <field name="short129" column="SHORT129"/> + <field name="short13" column="SHORT13"/> + <field name="short130" column="SHORT130"/> + <field name="short138" column="SHORT138"/> + <field name="short139" column="SHORT139"/> + <field name="short140" column="SHORT140"/> + <field name="short16" column="SHORT16"/> + <field name="short17" column="SHORT17"/> + <field name="short18" column="SHORT18"/> + <field name="short2" column="SHORT2"/> + <field name="short20" column="SHORT20"/> + <field name="short21" column="SHORT21"/> + <field name="short22" column="SHORT22"/> + <field name="short30" column="SHORT30"/> + <field name="short31" column="SHORT31"/> + <field name="short32" column="SHORT32"/> + <field name="short36" column="SHORT36"/> + <field name="short37" column="SHORT37"/> + <field name="short38" column="SHORT38"/> + <field name="short4" column="SHORT4"/> + <field name="short40" column="SHORT40"/> + <field name="short41" column="SHORT41"/> + <field name="short42" column="SHORT42"/> + <field name="short47" column="SHORT47"/> + <field name="short48" column="SHORT48"/> + <field name="short49" column="SHORT49"/> + <field name="short5" column="SHORT5"/> + <field name="short52" column="SHORT52"/> + <field name="short53" column="SHORT53"/> + <field name="short54" column="SHORT54"/> + <field name="short56" column="SHORT56"/> + <field name="short57" column="SHORT57"/> + <field name="short58" column="SHORT58"/> + <field name="short6" column="SHORT6"/> + <field name="short66" column="SHORT66"/> + <field name="short67" column="SHORT67"/> + <field name="short68" column="SHORT68"/> + <field name="short72" column="SHORT72"/> + <field name="short73" column="SHORT73"/> + <field name="short74" column="SHORT74"/> + <field name="short76" column="SHORT76"/> + <field name="short77" column="SHORT77"/> + <field name="short78" column="SHORT78"/> + <field name="short83" column="SHORT83"/> + <field name="short84" column="SHORT84"/> + <field name="short85" column="SHORT85"/> + <field name="short88" column="SHORT88"/> + <field name="short89" column="SHORT89"/> + <field name="short90" column="SHORT90"/> + <field name="short92" column="SHORT92"/> + <field name="short93" column="SHORT93"/> + <field name="short94" column="SHORT94"/> + </class> + </package> +</orm> Propchange: incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/FieldsOfPrimitiveshort-derby.orm ------------------------------------------------------------------------------ svn:executable = * Added: incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/FieldsOfShort-derby.orm URL: http://svn.apache.org/viewcvs/incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/FieldsOfShort-derby.orm?rev=164672&view=auto ============================================================================== --- incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/FieldsOfShort-derby.orm (added) +++ incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/FieldsOfShort-derby.orm Mon Apr 25 15:26:24 2005 @@ -0,0 +1,81 @@ +<?xml version="1.0" encoding="UTF-8"?> +<!DOCTYPE orm PUBLIC "-//Sun Microsystems, Inc.//DTD Java Data Objects Metadata 2.0//EN" "http://java.sun.com/dtd/orm_2_0.dtd"> +<orm> + <package name="org.apache.jdo.tck.pc.fieldtypes"> + <class name="FieldsOfShort" table="FIELDSOFSHORT"> + <field name="identifier" primary-key="true" column="IDENTIFIER"/> + <field name="Short0" column="SHORT0"/> + <field name="Short1" column="SHORT1"/> + <field name="Short102" column="SHORT102"/> + <field name="Short103" column="SHORT103"/> + <field name="Short104" column="SHORT104"/> + <field name="Short108" column="SHORT108"/> + <field name="Short109" column="SHORT109"/> + <field name="Short11" column="SHORT11"/> + <field name="Short110" column="SHORT110"/> + <field name="Short112" column="SHORT112"/> + <field name="Short113" column="SHORT113"/> + <field name="Short114" column="SHORT114"/> + <field name="Short119" column="SHORT119"/> + <field name="Short12" column="SHORT12"/> + <field name="Short120" column="SHORT120"/> + <field name="Short121" column="SHORT121"/> + <field name="Short124" column="SHORT124"/> + <field name="Short125" column="SHORT125"/> + <field name="Short126" column="SHORT126"/> + <field name="Short128" column="SHORT128"/> + <field name="Short129" column="SHORT129"/> + <field name="Short13" column="SHORT13"/> + <field name="Short130" column="SHORT130"/> + <field name="Short138" column="SHORT138"/> + <field name="Short139" column="SHORT139"/> + <field name="Short140" column="SHORT140"/> + <field name="Short16" column="SHORT16"/> + <field name="Short17" column="SHORT17"/> + <field name="Short18" column="SHORT18"/> + <field name="Short2" column="SHORT2"/> + <field name="Short20" column="SHORT20"/> + <field name="Short21" column="SHORT21"/> + <field name="Short22" column="SHORT22"/> + <field name="Short30" column="SHORT30"/> + <field name="Short31" column="SHORT31"/> + <field name="Short32" column="SHORT32"/> + <field name="Short36" column="SHORT36"/> + <field name="Short37" column="SHORT37"/> + <field name="Short38" column="SHORT38"/> + <field name="Short4" column="SHORT4"/> + <field name="Short40" column="SHORT40"/> + <field name="Short41" column="SHORT41"/> + <field name="Short42" column="SHORT42"/> + <field name="Short47" column="SHORT47"/> + <field name="Short48" column="SHORT48"/> + <field name="Short49" column="SHORT49"/> + <field name="Short5" column="SHORT5"/> + <field name="Short52" column="SHORT52"/> + <field name="Short53" column="SHORT53"/> + <field name="Short54" column="SHORT54"/> + <field name="Short56" column="SHORT56"/> + <field name="Short57" column="SHORT57"/> + <field name="Short58" column="SHORT58"/> + <field name="Short6" column="SHORT6"/> + <field name="Short66" column="SHORT66"/> + <field name="Short67" column="SHORT67"/> + <field name="Short68" column="SHORT68"/> + <field name="Short72" column="SHORT72"/> + <field name="Short73" column="SHORT73"/> + <field name="Short74" column="SHORT74"/> + <field name="Short76" column="SHORT76"/> + <field name="Short77" column="SHORT77"/> + <field name="Short78" column="SHORT78"/> + <field name="Short83" column="SHORT83"/> + <field name="Short84" column="SHORT84"/> + <field name="Short85" column="SHORT85"/> + <field name="Short88" column="SHORT88"/> + <field name="Short89" column="SHORT89"/> + <field name="Short90" column="SHORT90"/> + <field name="Short92" column="SHORT92"/> + <field name="Short93" column="SHORT93"/> + <field name="Short94" column="SHORT94"/> + </class> + </package> +</orm> Propchange: incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/FieldsOfShort-derby.orm ------------------------------------------------------------------------------ svn:executable = * Added: incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/FieldsOfString-derby.orm URL: http://svn.apache.org/viewcvs/incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/FieldsOfString-derby.orm?rev=164672&view=auto ============================================================================== --- incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/FieldsOfString-derby.orm (added) +++ incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/FieldsOfString-derby.orm Mon Apr 25 15:26:24 2005 @@ -0,0 +1,81 @@ +<?xml version="1.0" encoding="UTF-8"?> +<!DOCTYPE orm PUBLIC "-//Sun Microsystems, Inc.//DTD Java Data Objects Metadata 2.0//EN" "http://java.sun.com/dtd/orm_2_0.dtd"> +<orm> + <package name="org.apache.jdo.tck.pc.fieldtypes"> + <class name="FieldsOfString" table="FIELDSOFSTRING"> + <field name="identifier" primary-key="true" column="IDENTIFIER"/> + <field name="String0" column="STRING0"/> + <field name="String1" column="STRING1"/> + <field name="String102" column="STRING102"/> + <field name="String103" column="STRING103"/> + <field name="String104" column="STRING104"/> + <field name="String108" column="STRING108"/> + <field name="String109" column="STRING109"/> + <field name="String11" column="STRING11"/> + <field name="String110" column="STRING110"/> + <field name="String112" column="STRING112"/> + <field name="String113" column="STRING113"/> + <field name="String114" column="STRING114"/> + <field name="String119" column="STRING119"/> + <field name="String12" column="STRING12"/> + <field name="String120" column="STRING120"/> + <field name="String121" column="STRING121"/> + <field name="String124" column="STRING124"/> + <field name="String125" column="STRING125"/> + <field name="String126" column="STRING126"/> + <field name="String128" column="STRING128"/> + <field name="String129" column="STRING129"/> + <field name="String13" column="STRING13"/> + <field name="String130" column="STRING130"/> + <field name="String138" column="STRING138"/> + <field name="String139" column="STRING139"/> + <field name="String140" column="STRING140"/> + <field name="String16" column="STRING16"/> + <field name="String17" column="STRING17"/> + <field name="String18" column="STRING18"/> + <field name="String2" column="STRING2"/> + <field name="String20" column="STRING20"/> + <field name="String21" column="STRING21"/> + <field name="String22" column="STRING22"/> + <field name="String30" column="STRING30"/> + <field name="String31" column="STRING31"/> + <field name="String32" column="STRING32"/> + <field name="String36" column="STRING36"/> + <field name="String37" column="STRING37"/> + <field name="String38" column="STRING38"/> + <field name="String4" column="STRING4"/> + <field name="String40" column="STRING40"/> + <field name="String41" column="STRING41"/> + <field name="String42" column="STRING42"/> + <field name="String47" column="STRING47"/> + <field name="String48" column="STRING48"/> + <field name="String49" column="STRING49"/> + <field name="String5" column="STRING5"/> + <field name="String52" column="STRING52"/> + <field name="String53" column="STRING53"/> + <field name="String54" column="STRING54"/> + <field name="String56" column="STRING56"/> + <field name="String57" column="STRING57"/> + <field name="String58" column="STRING58"/> + <field name="String6" column="STRING6"/> + <field name="String66" column="STRING66"/> + <field name="String67" column="STRING67"/> + <field name="String68" column="STRING68"/> + <field name="String72" column="STRING72"/> + <field name="String73" column="STRING73"/> + <field name="String74" column="STRING74"/> + <field name="String76" column="STRING76"/> + <field name="String77" column="STRING77"/> + <field name="String78" column="STRING78"/> + <field name="String83" column="STRING83"/> + <field name="String84" column="STRING84"/> + <field name="String85" column="STRING85"/> + <field name="String88" column="STRING88"/> + <field name="String89" column="STRING89"/> + <field name="String90" column="STRING90"/> + <field name="String92" column="STRING92"/> + <field name="String93" column="STRING93"/> + <field name="String94" column="STRING94"/> + </class> + </package> +</orm> Propchange: incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/FieldsOfString-derby.orm ------------------------------------------------------------------------------ svn:executable = * Modified: incubator/jdo/trunk/tck20/test/sql/derby/schema1.sql URL: http://svn.apache.org/viewcvs/incubator/jdo/trunk/tck20/test/sql/derby/schema1.sql?rev=164672&r1=164671&r2=164672&view=diff ============================================================================== --- incubator/jdo/trunk/tck20/test/sql/derby/schema1.sql (original) +++ incubator/jdo/trunk/tck20/test/sql/derby/schema1.sql Mon Apr 25 15:26:24 2005 @@ -28,7 +28,7 @@ CREATE TABLE PCRect ( ID BIGINT NOT NULL, UPPER_LEFT BIGINT REFERENCES PCPoint NOT NULL, - LOWER_RIGHT BIGINT REFERECES PCPoint NOT NULL, + LOWER_RIGHT BIGINT REFERENCES PCPoint NOT NULL, CONSTRAINT PCRCT_CONST PRIMARY KEY (ID) ); @@ -158,6 +158,1678 @@ ------------------------- 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 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; + +CREATE TABLE FIELDSOFBIGDECIMAL +( + IDENTIFIER INTEGER NOT NULL, + BIG_DECIMAL0 DECIMAL(19), + BIG_DECIMAL1 DECIMAL(19), + BIG_DECIMAL102 DECIMAL(19), + BIG_DECIMAL103 DECIMAL(19), + BIG_DECIMAL104 DECIMAL(19), + BIG_DECIMAL108 DECIMAL(19), + BIG_DECIMAL109 DECIMAL(19), + BIG_DECIMAL11 DECIMAL(19), + BIG_DECIMAL110 DECIMAL(19), + BIG_DECIMAL112 DECIMAL(19), + BIG_DECIMAL113 DECIMAL(19), + BIG_DECIMAL114 DECIMAL(19), + BIG_DECIMAL119 DECIMAL(19), + BIG_DECIMAL12 DECIMAL(19), + BIG_DECIMAL120 DECIMAL(19), + BIG_DECIMAL121 DECIMAL(19), + BIG_DECIMAL124 DECIMAL(19), + BIG_DECIMAL125 DECIMAL(19), + BIG_DECIMAL126 DECIMAL(19), + BIG_DECIMAL128 DECIMAL(19), + BIG_DECIMAL129 DECIMAL(19), + BIG_DECIMAL13 DECIMAL(19), + BIG_DECIMAL130 DECIMAL(19), + BIG_DECIMAL138 DECIMAL(19), + BIG_DECIMAL139 DECIMAL(19), + BIG_DECIMAL140 DECIMAL(19), + BIG_DECIMAL16 DECIMAL(19), + BIG_DECIMAL17 DECIMAL(19), + BIG_DECIMAL18 DECIMAL(19), + BIG_DECIMAL2 DECIMAL(19), + BIG_DECIMAL20 DECIMAL(19), + BIG_DECIMAL21 DECIMAL(19), + BIG_DECIMAL22 DECIMAL(19), + BIG_DECIMAL30 DECIMAL(19), + BIG_DECIMAL31 DECIMAL(19), + BIG_DECIMAL32 DECIMAL(19), + BIG_DECIMAL36 DECIMAL(19), + BIG_DECIMAL37 DECIMAL(19), + BIG_DECIMAL38 DECIMAL(19), + BIG_DECIMAL4 DECIMAL(19), + BIG_DECIMAL40 DECIMAL(19), + BIG_DECIMAL41 DECIMAL(19), + BIG_DECIMAL42 DECIMAL(19), + BIG_DECIMAL47 DECIMAL(19), + BIG_DECIMAL48 DECIMAL(19), + BIG_DECIMAL49 DECIMAL(19), + BIG_DECIMAL5 DECIMAL(19), + BIG_DECIMAL52 DECIMAL(19), + BIG_DECIMAL53 DECIMAL(19), + BIG_DECIMAL54 DECIMAL(19), + BIG_DECIMAL56 DECIMAL(19), + BIG_DECIMAL57 DECIMAL(19), + BIG_DECIMAL58 DECIMAL(19), + BIG_DECIMAL6 DECIMAL(19), + BIG_DECIMAL66 DECIMAL(19), + BIG_DECIMAL67 DECIMAL(19), + BIG_DECIMAL68 DECIMAL(19), + BIG_DECIMAL72 DECIMAL(19), + BIG_DECIMAL73 DECIMAL(19), + BIG_DECIMAL74 DECIMAL(19), + BIG_DECIMAL76 DECIMAL(19), + BIG_DECIMAL77 DECIMAL(19), + BIG_DECIMAL78 DECIMAL(19), + BIG_DECIMAL83 DECIMAL(19), + BIG_DECIMAL84 DECIMAL(19), + BIG_DECIMAL85 DECIMAL(19), + BIG_DECIMAL88 DECIMAL(19), + BIG_DECIMAL89 DECIMAL(19), + BIG_DECIMAL90 DECIMAL(19), + BIG_DECIMAL92 DECIMAL(19), + BIG_DECIMAL93 DECIMAL(19), + BIG_DECIMAL94 DECIMAL(19) +); + +ALTER TABLE FIELDSOFBIGDECIMAL ADD CONSTRAINT FIELDSOFBIGDPP_PK PRIMARY KEY (IDENTIFIER); + +CREATE TABLE FIELDSOFBIGINTEGER +( + IDENTIFIER INTEGER NOT NULL, + BIG_INTEGER0 NUMERIC, + BIG_INTEGER1 NUMERIC, + BIG_INTEGER102 NUMERIC, + BIG_INTEGER103 NUMERIC, + BIG_INTEGER104 NUMERIC, + BIG_INTEGER108 NUMERIC, + BIG_INTEGER109 NUMERIC, + BIG_INTEGER11 NUMERIC, + BIG_INTEGER110 NUMERIC, + BIG_INTEGER112 NUMERIC, + BIG_INTEGER113 NUMERIC, + BIG_INTEGER114 NUMERIC, + BIG_INTEGER119 NUMERIC, + BIG_INTEGER12 NUMERIC, + BIG_INTEGER120 NUMERIC, + BIG_INTEGER121 NUMERIC, + BIG_INTEGER124 NUMERIC, + BIG_INTEGER125 NUMERIC, + BIG_INTEGER126 NUMERIC, + BIG_INTEGER128 NUMERIC, + BIG_INTEGER129 NUMERIC, + BIG_INTEGER13 NUMERIC, + BIG_INTEGER130 NUMERIC, + BIG_INTEGER138 NUMERIC, + BIG_INTEGER139 NUMERIC, + BIG_INTEGER140 NUMERIC, + BIG_INTEGER16 NUMERIC, + BIG_INTEGER17 NUMERIC, + BIG_INTEGER18 NUMERIC, + BIG_INTEGER2 NUMERIC, + BIG_INTEGER20 NUMERIC, + BIG_INTEGER21 NUMERIC, + BIG_INTEGER22 NUMERIC, + BIG_INTEGER30 NUMERIC, + BIG_INTEGER31 NUMERIC, + BIG_INTEGER32 NUMERIC, + BIG_INTEGER36 NUMERIC, + BIG_INTEGER37 NUMERIC, + BIG_INTEGER38 NUMERIC, + BIG_INTEGER4 NUMERIC, + BIG_INTEGER40 NUMERIC, + BIG_INTEGER41 NUMERIC, + BIG_INTEGER42 NUMERIC, + BIG_INTEGER47 NUMERIC, + BIG_INTEGER48 NUMERIC, + BIG_INTEGER49 NUMERIC, + BIG_INTEGER5 NUMERIC, + BIG_INTEGER52 NUMERIC, + BIG_INTEGER53 NUMERIC, + BIG_INTEGER54 NUMERIC, + BIG_INTEGER56 NUMERIC, + BIG_INTEGER57 NUMERIC, + BIG_INTEGER58 NUMERIC, + BIG_INTEGER6 NUMERIC, + BIG_INTEGER66 NUMERIC, + BIG_INTEGER67 NUMERIC, + BIG_INTEGER68 NUMERIC, + BIG_INTEGER72 NUMERIC, + BIG_INTEGER73 NUMERIC, + BIG_INTEGER74 NUMERIC, + BIG_INTEGER76 NUMERIC, + BIG_INTEGER77 NUMERIC, + BIG_INTEGER78 NUMERIC, + BIG_INTEGER83 NUMERIC, + BIG_INTEGER84 NUMERIC, + BIG_INTEGER85 NUMERIC, + BIG_INTEGER88 NUMERIC, + BIG_INTEGER89 NUMERIC, + BIG_INTEGER90 NUMERIC, + BIG_INTEGER92 NUMERIC, + BIG_INTEGER93 NUMERIC, + BIG_INTEGER94 NUMERIC +); + +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 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, @@ -234,7 +1906,7 @@ BYTE138 SMALLINT, BYTE139 SMALLINT, BYTE140 SMALLINT, - CONSTRAINT AllTypes_PK PRIMARY KEY (IDENTIFIER) + CONSTRAINT FieldsOfByte_PK PRIMARY KEY (IDENTIFIER) ); -------------------------