You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jdo-commits@db.apache.org by mc...@apache.org on 2005/04/26 01:51:35 UTC
svn commit: r164692 [2/2] - in /incubator/jdo/trunk/tck20: ./
test/jdo/datastoreidentity/org/apache/jdo/tck/pc/fieldtypes/
test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/
test/sql/derby/
Modified: incubator/jdo/trunk/tck20/test/sql/derby/schema2.sql
URL: http://svn.apache.org/viewcvs/incubator/jdo/trunk/tck20/test/sql/derby/schema2.sql?rev=164692&r1=164691&r2=164692&view=diff
==============================================================================
--- incubator/jdo/trunk/tck20/test/sql/derby/schema2.sql (original)
+++ incubator/jdo/trunk/tck20/test/sql/derby/schema2.sql Mon Apr 25 16:51:33 2005
@@ -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 GENERATED ALWAYS AS IDENTITY,
+ 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 GENERATED ALWAYS AS IDENTITY,
+ 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 GENERATED ALWAYS AS IDENTITY,
+ 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 GENERATED ALWAYS AS IDENTITY,
+ 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 GENERATED ALWAYS AS IDENTITY,
+ 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 GENERATED ALWAYS AS IDENTITY,
+ 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 GENERATED ALWAYS AS IDENTITY,
+ 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 GENERATED ALWAYS AS IDENTITY,
+ 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 GENERATED ALWAYS AS IDENTITY,
+ 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 GENERATED ALWAYS AS IDENTITY,
+ 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 GENERATED ALWAYS AS IDENTITY,
+ 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 GENERATED ALWAYS AS IDENTITY,
+ 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 GENERATED ALWAYS AS IDENTITY,
+ 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 GENERATED ALWAYS AS IDENTITY,
+ 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 GENERATED ALWAYS AS IDENTITY,
+ 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 GENERATED ALWAYS AS IDENTITY,
+ 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 GENERATED ALWAYS AS IDENTITY,
+ 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 GENERATED ALWAYS AS IDENTITY,
+ 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 GENERATED ALWAYS AS IDENTITY,
+ 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 GENERATED ALWAYS AS IDENTITY,
+ 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 GENERATED ALWAYS AS IDENTITY,
+ 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 GENERATED ALWAYS AS IDENTITY,