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=168510&r1=168509&r2=168510&view=diff ============================================================================== --- incubator/jdo/trunk/tck20/test/sql/derby/schema1.sql (original) +++ incubator/jdo/trunk/tck20/test/sql/derby/schema1.sql Thu May 5 20:20:51 2005 @@ -276,6 +276,253 @@ DROP TABLE SET_OF_SHORT41; DROP TABLE SET_COLLECTIONS; +DROP TABLE MAP_OF_STRING_OBJECT0; +DROP TABLE MAP_OF_STRING_OBJECT1; +DROP TABLE MAP_OF_STRING_OBJECT2; +DROP TABLE MAP_OF_STRING_SIMPLE_CLASS3; +DROP TABLE MAP_OF_STRING_SIMPLE_CLASS4; +DROP TABLE MAP_OF_STRING_SIMPLE_CLASS5; +DROP TABLE MAP_OF_STRING_SIMPLE_INTERFACE6; +DROP TABLE MAP_OF_STRING_SIMPLE_INTERFACE7; +DROP TABLE MAP_OF_STRING_SIMPLE_INTERFACE8; +DROP TABLE MAP_OF_STRING_STRING9; +DROP TABLE MAP_OF_STRING_STRING10; +DROP TABLE MAP_OF_STRING_STRING11; +DROP TABLE MAP_OF_STRING_DATE12; +DROP TABLE MAP_OF_STRING_DATE13; +DROP TABLE MAP_OF_STRING_DATE14; +DROP TABLE MAP_OF_STRING_LOCALE15; +DROP TABLE MAP_OF_STRING_LOCALE16; +DROP TABLE MAP_OF_STRING_LOCALE17; +DROP TABLE MAP_OF_STRING_BIG_DECIMAL18; +DROP TABLE MAP_OF_STRING_BIG_DECIMAL19; +DROP TABLE MAP_OF_STRING_BIG_DECIMAL20; +DROP TABLE MAP_OF_STRING_BIG_INTEGER21; +DROP TABLE MAP_OF_STRING_BIG_INTEGER22; +DROP TABLE MAP_OF_STRING_BIG_INTEGER23; +DROP TABLE MAP_OF_STRING_BYTE24; +DROP TABLE MAP_OF_STRING_BYTE25; +DROP TABLE MAP_OF_STRING_BYTE26; +DROP TABLE MAP_OF_STRING_DOUBLE27; +DROP TABLE MAP_OF_STRING_DOUBLE28; +DROP TABLE MAP_OF_STRING_DOUBLE29; +DROP TABLE MAP_OF_STRING_FLOAT30; +DROP TABLE MAP_OF_STRING_FLOAT31; +DROP TABLE MAP_OF_STRING_FLOAT32; +DROP TABLE MAP_OF_STRING_INTEGER33; +DROP TABLE MAP_OF_STRING_INTEGER34; +DROP TABLE MAP_OF_STRING_INTEGER35; +DROP TABLE MAP_OF_STRING_LONG36; +DROP TABLE MAP_OF_STRING_LONG37; +DROP TABLE MAP_OF_STRING_LONG38; +DROP TABLE MAP_OF_STRING_SHORT39; +DROP TABLE MAP_OF_STRING_SHORT40; +DROP TABLE MAP_OF_STRING_SHORT41; +DROP TABLE MAP_OF_STRING_OBJECT42; +DROP TABLE MAP_OF_STRING_OBJECT43; +DROP TABLE MAP_OF_STRING_OBJECT44; +DROP TABLE MAP_OF_STRING_SIMPLE_CLASS45; +DROP TABLE MAP_OF_STRING_SIMPLE_CLASS46; +DROP TABLE MAP_OF_STRING_SIMPLE_CLASS47; +DROP TABLE MAP_OF_STRING_SIMPLE_INTERFACE48; +DROP TABLE MAP_OF_STRING_SIMPLE_INTERFACE49; +DROP TABLE MAP_OF_STRING_SIMPLE_INTERFACE50; +DROP TABLE MAP_OF_STRING_STRING51; +DROP TABLE MAP_OF_STRING_STRING52; +DROP TABLE MAP_OF_STRING_STRING53; +DROP TABLE MAP_OF_STRING_DATE54; +DROP TABLE MAP_OF_STRING_DATE55; +DROP TABLE MAP_OF_STRING_DATE56; +DROP TABLE MAP_OF_STRING_LOCALE57; +DROP TABLE MAP_OF_STRING_LOCALE58; +DROP TABLE MAP_OF_STRING_LOCALE59; +DROP TABLE MAP_OF_STRING_BIG_DECIMAL60; +DROP TABLE MAP_OF_STRING_BIG_DECIMAL61; +DROP TABLE MAP_OF_STRING_BIG_DECIMAL62; +DROP TABLE MAP_OF_STRING_BIG_INTEGER63; +DROP TABLE MAP_OF_STRING_BIG_INTEGER64; +DROP TABLE MAP_OF_STRING_BIG_INTEGER65; +DROP TABLE MAP_OF_STRING_BYTE66; +DROP TABLE MAP_OF_STRING_BYTE67; +DROP TABLE MAP_OF_STRING_BYTE68; +DROP TABLE MAP_OF_STRING_DOUBLE69; +DROP TABLE MAP_OF_STRING_DOUBLE70; +DROP TABLE MAP_OF_STRING_DOUBLE71; +DROP TABLE MAP_OF_STRING_FLOAT72; +DROP TABLE MAP_OF_STRING_FLOAT73; +DROP TABLE MAP_OF_STRING_FLOAT74; +DROP TABLE MAP_OF_STRING_INTEGER75; +DROP TABLE MAP_OF_STRING_INTEGER76; +DROP TABLE MAP_OF_STRING_INTEGER77; +DROP TABLE MAP_OF_STRING_LONG78; +DROP TABLE MAP_OF_STRING_LONG79; +DROP TABLE MAP_OF_STRING_LONG80; +DROP TABLE MAP_OF_STRING_SHORT81; +DROP TABLE MAP_OF_STRING_SHORT82; +DROP TABLE MAP_OF_STRING_SHORT83; +DROP TABLE MAP_OF_STRING_OBJECT84; +DROP TABLE MAP_OF_STRING_OBJECT85; +DROP TABLE MAP_OF_STRING_OBJECT86; +DROP TABLE MAP_OF_STRING_SIMPLE_CLASS87; +DROP TABLE MAP_OF_STRING_SIMPLE_CLASS88; +DROP TABLE MAP_OF_STRING_SIMPLE_CLASS89; +DROP TABLE MAP_OF_STRING_SIMPLE_INTERFACE90; +DROP TABLE MAP_OF_STRING_SIMPLE_INTERFACE91; +DROP TABLE MAP_OF_STRING_SIMPLE_INTERFACE92; +DROP TABLE MAP_OF_STRING_STRING93; +DROP TABLE MAP_OF_STRING_STRING94; +DROP TABLE MAP_OF_STRING_STRING95; +DROP TABLE MAP_OF_STRING_DATE96; +DROP TABLE MAP_OF_STRING_DATE97; +DROP TABLE MAP_OF_STRING_DATE98; +DROP TABLE MAP_OF_STRING_LOCALE99; +DROP TABLE MAP_OF_STRING_LOCALE100; +DROP TABLE MAP_OF_STRING_LOCALE101; +DROP TABLE MAP_OF_STRING_BIG_DECIMAL102; +DROP TABLE MAP_OF_STRING_BIG_DECIMAL103; +DROP TABLE MAP_OF_STRING_BIG_DECIMAL104; +DROP TABLE MAP_OF_STRING_BIG_INTEGER015; +DROP TABLE MAP_OF_STRING_BIG_INTEGER106; +DROP TABLE MAP_OF_STRING_BIG_INTEGER107; +DROP TABLE MAP_OF_STRING_BYTE108; +DROP TABLE MAP_OF_STRING_BYTE109; +DROP TABLE MAP_OF_STRING_BYTE110; +DROP TABLE MAP_OF_STRING_DOUBLE111; +DROP TABLE MAP_OF_STRING_DOUBLE112; +DROP TABLE MAP_OF_STRING_DOUBLE113; +DROP TABLE MAP_OF_STRING_FLOAT114; +DROP TABLE MAP_OF_STRING_FLOAT115; +DROP TABLE MAP_OF_STRING_FLOAT116; +DROP TABLE MAP_OF_STRING_INTEGER117; +DROP TABLE MAP_OF_STRING_INTEGER118; +DROP TABLE MAP_OF_STRING_INTEGER119; +DROP TABLE MAP_OF_STRING_LONG120; +DROP TABLE MAP_OF_STRING_LONG121; +DROP TABLE MAP_OF_STRING_LONG122; +DROP TABLE MAP_OF_STRING_SHORT123; +DROP TABLE MAP_OF_STRING_SHORT124; +DROP TABLE MAP_OF_STRING_SHORT125; +DROP TABLE MAPSTRINGKEY_COLLECTIONS; + +DROP TABLE MAP_OF_OBJECT0_STRING; +DROP TABLE MAP_OF_OBJECT1_STRING; +DROP TABLE MAP_OF_OBJECT2_STRING; +DROP TABLE MAP_OF_OBJECT3_STRING; +DROP TABLE MAP_OF_OBJECT4_STRING; +DROP TABLE MAP_OF_OBJECT5_STRING; +DROP TABLE MAP_OF_OBJECT6_STRING; +DROP TABLE MAP_OF_OBJECT7_STRING; +DROP TABLE MAP_OF_OBJECT8_STRING; +DROP TABLE MAP_OF_SIMPLE_CLASS9_STRING; +DROP TABLE MAP_OF_SIMPLE_CLASS10_STRING; +DROP TABLE MAP_OF_SIMPLE_CLASS11_STRING; +DROP TABLE MAP_OF_SIMPLE_CLASS12_STRING; +DROP TABLE MAP_OF_SIMPLE_CLASS13_STRING; +DROP TABLE MAP_OF_SIMPLE_CLASS14_STRING; +DROP TABLE MAP_OF_SIMPLE_CLASS15_STRING; +DROP TABLE MAP_OF_SIMPLE_CLASS16_STRING; +DROP TABLE MAP_OF_SIMPLE_CLASS17_STRING; +DROP TABLE MAP_OF_SIMPLE_INTERFACE18_STRING; +DROP TABLE MAP_OF_SIMPLE_INTERFACE19_STRING; +DROP TABLE MAP_OF_SIMPLE_INTERFACE20_STRING; +DROP TABLE MAP_OF_SIMPLE_INTERFACE21_STRING; +DROP TABLE MAP_OF_SIMPLE_INTERFACE22_STRING; +DROP TABLE MAP_OF_SIMPLE_INTERFACE23_STRING; +DROP TABLE MAP_OF_SIMPLE_INTERFACE24_STRING; +DROP TABLE MAP_OF_SIMPLE_INTERFACE25_STRING; +DROP TABLE MAP_OF_SIMPLE_INTERFACE26_STRING; +DROP TABLE MAP_OF_STRING27_STRING; +DROP TABLE MAP_OF_STRING28_STRING; +DROP TABLE MAP_OF_STRING29_STRING; +DROP TABLE MAP_OF_STRING30_STRING; +DROP TABLE MAP_OF_STRING31_STRING; +DROP TABLE MAP_OF_STRING32_STRING; +DROP TABLE MAP_OF_STRING33_STRING; +DROP TABLE MAP_OF_STRING34_STRING; +DROP TABLE MAP_OF_STRING35_STRING; +DROP TABLE MAP_OF_DATE36_STRING; +DROP TABLE MAP_OF_DATE37_STRING; +DROP TABLE MAP_OF_DATE38_STRING; +DROP TABLE MAP_OF_DATE39_STRING; +DROP TABLE MAP_OF_DATE40_STRING; +DROP TABLE MAP_OF_DATE41_STRING; +DROP TABLE MAP_OF_DATE42_STRING; +DROP TABLE MAP_OF_DATE43_STRING; +DROP TABLE MAP_OF_DATE44_STRING; +DROP TABLE MAP_OF_BIG_DECIMAL45_STRING; +DROP TABLE MAP_OF_BIG_DECIMAL46_STRING; +DROP TABLE MAP_OF_BIG_DECIMAL47_STRING; +DROP TABLE MAP_OF_BIG_DECIMAL48_STRING; +DROP TABLE MAP_OF_BIG_DECIMAL49_STRING; +DROP TABLE MAP_OF_BIG_DECIMAL50_STRING; +DROP TABLE MAP_OF_BIG_DECIMAL51_STRING; +DROP TABLE MAP_OF_BIG_DECIMAL52_STRING; +DROP TABLE MAP_OF_BIG_DECIMAL53_STRING; +DROP TABLE MAP_OF_BIG_INTEGER54_STRING; +DROP TABLE MAP_OF_BIG_INTEGER55_STRING; +DROP TABLE MAP_OF_BIG_INTEGER56_STRING; +DROP TABLE MAP_OF_BIG_INTEGER57_STRING; +DROP TABLE MAP_OF_BIG_INTEGER58_STRING; +DROP TABLE MAP_OF_BIG_INTEGER59_STRING; +DROP TABLE MAP_OF_BIG_INTEGER60_STRING; +DROP TABLE MAP_OF_BIG_INTEGER61_STRING; +DROP TABLE MAP_OF_BIG_INTEGER62_STRING; +DROP TABLE MAP_OF_BYTE63_STRING; +DROP TABLE MAP_OF_BYTE64_STRING; +DROP TABLE MAP_OF_BYTE65_STRING; +DROP TABLE MAP_OF_BYTE66_STRING; +DROP TABLE MAP_OF_BYTE67_STRING; +DROP TABLE MAP_OF_BYTE68_STRING; +DROP TABLE MAP_OF_BYTE69_STRING; +DROP TABLE MAP_OF_BYTE70_STRING; +DROP TABLE MAP_OF_BYTE71_STRING; +DROP TABLE MAP_OF_DOUBLE72_STRING; +DROP TABLE MAP_OF_DOUBLE73_STRING; +DROP TABLE MAP_OF_DOUBLE74_STRING; +DROP TABLE MAP_OF_DOUBLE75_STRING; +DROP TABLE MAP_OF_DOUBLE76_STRING; +DROP TABLE MAP_OF_DOUBLE77_STRING; +DROP TABLE MAP_OF_DOUBLE78_STRING; +DROP TABLE MAP_OF_DOUBLE79_STRING; +DROP TABLE MAP_OF_DOUBLE80_STRING; +DROP TABLE MAP_OF_FLOAT81_STRING; +DROP TABLE MAP_OF_FLOAT82_STRING; +DROP TABLE MAP_OF_FLOAT83_STRING; +DROP TABLE MAP_OF_FLOAT84_STRING; +DROP TABLE MAP_OF_FLOAT85_STRING; +DROP TABLE MAP_OF_FLOAT86_STRING; +DROP TABLE MAP_OF_FLOAT87_STRING; +DROP TABLE MAP_OF_FLOAT88_STRING; +DROP TABLE MAP_OF_FLOAT89_STRING; +DROP TABLE MAP_OF_INTEGER90_STRING; +DROP TABLE MAP_OF_INTEGER91_STRING; +DROP TABLE MAP_OF_INTEGER92_STRING; +DROP TABLE MAP_OF_INTEGER93_STRING; +DROP TABLE MAP_OF_INTEGER94_STRING; +DROP TABLE MAP_OF_INTEGER95_STRING; +DROP TABLE MAP_OF_INTEGER96_STRING; +DROP TABLE MAP_OF_INTEGER97_STRING; +DROP TABLE MAP_OF_INTEGER98_STRING; +DROP TABLE MAP_OF_LONG99_STRING; +DROP TABLE MAP_OF_LONG100_STRING; +DROP TABLE MAP_OF_LONG101_STRING; +DROP TABLE MAP_OF_LONG102_STRING; +DROP TABLE MAP_OF_LONG103_STRING; +DROP TABLE MAP_OF_LONG104_STRING; +DROP TABLE MAP_OF_LONG105_STRING; +DROP TABLE MAP_OF_LONG106_STRING; +DROP TABLE MAP_OF_LONG107_STRING; +DROP TABLE MAP_OF_SHORT108_STRING; +DROP TABLE MAP_OF_SHORT109_STRING; +DROP TABLE MAP_OF_SHORT110_STRING; +DROP TABLE MAP_OF_SHORT111_STRING; +DROP TABLE MAP_OF_SHORT112_STRING; +DROP TABLE MAP_OF_SHORT113_STRING; +DROP TABLE MAP_OF_SHORT114_STRING; +DROP TABLE MAP_OF_SHORT115_STRING; +DROP TABLE MAP_OF_SHORT116_STRING; +DROP TABLE MAPSTRINGVALUE_COLLECTIONS; + DROP TABLE FIELDSOFSIMPLECLASS; DROP TABLE SIMPLE_CLASS; DROP TABLE FIELDSOFBYTE; @@ -2659,7 +2906,6 @@ --SetCollections - CREATE TABLE SET_COLLECTIONS ( IDENTIFIER INTEGER NOT NULL, @@ -2951,11 +3197,1846 @@ IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL, SHORTVAL SMALLINT, INDEX INTEGER NOT NULL +); CREATE TABLE SET_OF_SHORT41 ( IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL, SHORTVAL SMALLINT, INDEX INTEGER NOT NULL); + +--MapOfStringKeyCollections + +CREATE TABLE MAPSTRINGKEY_COLLECTIONS +( + IDENTIFIER INTEGER NOT NULL, + CONSTRAINT MSKC_PK PRIMARY KEY (IDENTIFIER) ); -CREATE TABLE SET_OF_SHORT41 + +CREATE TABLE MAP_OF_STRING_OBJECT0 ( - IDENTIFIER INTEGER REFERENCES SET_COLLECTIONS NOT NULL, + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_OBJECT1 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_OBJECT2 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_SIMPLE_CLASS3 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_SIMPLE_CLASS4 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_SIMPLE_CLASS5 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_SIMPLE_INTERFACE6 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_SIMPLE_INTERFACE7 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_SIMPLE_INTERFACE8 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_STRING9 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + STRINGVAL VARCHAR(1024), + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_STRING10 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + STRINGVAL VARCHAR(1024), + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_STRING11 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + STRINGVAL VARCHAR(1024), + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_DATE12 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + DATEVAL DATE, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_DATE13 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + DATEVAL DATE, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_DATE14 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + DATEVAL DATE, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_LOCALE15 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + LOCALEVAL CHAR(20), + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_LOCALE16 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + LOCALEVAL CHAR(20), + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_LOCALE17 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + LOCALEVAL CHAR(20), + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_BIG_DECIMAL18 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + BIG_DECIMALVAL DECIMAL(19), + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_BIG_DECIMAL19 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + BIG_DECIMALVAL DECIMAL(19), + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_BIG_DECIMAL20 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + BIG_DECIMALVAL DECIMAL(19), + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_BIG_INTEGER21 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + BIG_INTEGERVAL BIGINT, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_BIG_INTEGER22 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + BIG_INTEGERVAL BIGINT, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_BIG_INTEGER23 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + BIG_INTEGERVAL BIGINT, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_BYTE24 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + BYTEVAL SMALLINT, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_BYTE25 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + BYTEVAL SMALLINT, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_BYTE26 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + BYTEVAL SMALLINT, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_DOUBLE27 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + DOUBLEVAL DOUBLE, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_DOUBLE28 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + DOUBLEVAL DOUBLE, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_DOUBLE29 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + DOUBLEVAL DOUBLE, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_FLOAT30 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + FLOATVAL FLOAT, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_FLOAT31 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + FLOATVAL FLOAT, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_FLOAT32 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + FLOATVAL FLOAT, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_INTEGER33 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + INTEGERVAL INTEGER, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_INTEGER34 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + INTEGERVAL INTEGER, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_INTEGER35 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + INTEGERVAL INTEGER, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_LONG36 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + LONGVAL BIGINT, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_LONG37 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + LONGVAL BIGINT, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_LONG38 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + LONGVAL BIGINT, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_SHORT39 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + SHORTVAL SMALLINT, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_SHORT40 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + SHORTVAL SMALLINT, + INDEX INTEGER NOT NULL +); +CREATE TABLE MAP_OF_STRING_SHORT41 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, SHORTVAL SMALLINT, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_OBJECT42 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_OBJECT43 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_OBJECT44 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_SIMPLE_CLASS45 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_SIMPLE_CLASS46 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_SIMPLE_CLASS47 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_SIMPLE_INTERFACE48 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_SIMPLE_INTERFACE49 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_SIMPLE_INTERFACE50 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_STRING51 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + STRINGVAL VARCHAR(1024), + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_STRING52 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + STRINGVAL VARCHAR(1024), + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_STRING53 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + STRINGVAL VARCHAR(1024), + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_DATE54 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + DATEVAL DATE, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_DATE55 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + DATEVAL DATE, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_DATE56 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + DATEVAL DATE, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_LOCALE57 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + LOCALEVAL CHAR(20), + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_LOCALE58 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + LOCALEVAL CHAR(20), + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_LOCALE59 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + LOCALEVAL CHAR(20), + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_BIG_DECIMAL60 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + BIG_DECIMALVAL LONG VARCHAR FOR BIT DATA, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_BIG_DECIMAL61 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + BIG_DECIMALVAL LONG VARCHAR FOR BIT DATA, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_BIG_DECIMAL62 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + BIG_DECIMALVAL LONG VARCHAR FOR BIT DATA, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_BIG_INTEGER63 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + BIG_INTEGERVAL BIGINT, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_BIG_INTEGER64 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + BIG_INTEGERVAL BIGINT, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_BIG_INTEGER65 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + BIG_INTEGERVAL BIGINT, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_BYTE66 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + BYTEVAL SMALLINT, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_BYTE67 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + BYTEVAL SMALLINT, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_BYTE68 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + BYTEVAL SMALLINT, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_DOUBLE69 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + DOUBLEVAL DOUBLE, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_DOUBLE70 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + DOUBLEVAL DOUBLE, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_DOUBLE71 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + DOUBLEVAL DOUBLE, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_FLOAT72 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + FLOATVAL FLOAT, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_FLOAT73 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + FLOATVAL FLOAT, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_FLOAT74 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + FLOATVAL FLOAT, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_INTEGER75 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + INTEGERVAL INTEGER, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_INTEGER76 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + INTEGERVAL INTEGER, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_INTEGER77 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + INTEGERVAL INTEGER, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_LONG78 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + LONGVAL BIGINT, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_LONG79 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + LONGVAL BIGINT, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_LONG80 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + LONGVAL BIGINT, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_SHORT81 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + SHORTVAL SMALLINT, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_SHORT82 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + SHORTVAL SMALLINT, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_SHORT83 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + SHORTVAL SMALLINT, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_OBJECT84 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_OBJECT85 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_OBJECT86 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + OBJREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_SIMPLE_CLASS87 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_SIMPLE_CLASS88 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_SIMPLE_CLASS89 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_SIMPLE_INTERFACE90 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_SIMPLE_INTERFACE91 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_SIMPLE_INTERFACE92 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + SIMPINTERFREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_STRING93 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + STRINGVAL VARCHAR(1024), + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_STRING94 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + STRINGVAL VARCHAR(1024), + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_STRING95 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + STRINGVAL VARCHAR(1024), + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_DATE96 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + DATEVAL DATE, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_DATE97 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + DATEVAL DATE, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_DATE98 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + DATEVAL DATE, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_LOCALE99 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + LOCALEVAL CHAR(20), + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_LOCALE100 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + LOCALEVAL CHAR(20), + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_LOCALE101 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + LOCALEVAL CHAR(20), + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_BIG_DECIMAL102 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + BIG_DECIMALVAL LONG VARCHAR FOR BIT DATA, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_BIG_DECIMAL103 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + BIG_DECIMALVAL LONG VARCHAR FOR BIT DATA, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_BIG_DECIMAL104 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + BIG_DECIMALVAL LONG VARCHAR FOR BIT DATA, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_BIG_INTEGER015 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + BIG_INTEGERVAL BIGINT, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_BIG_INTEGER106 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + BIG_INTEGERVAL BIGINT, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_BIG_INTEGER107 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + BIG_INTEGERVAL BIGINT, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_BYTE108 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + BYTEVAL SMALLINT, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_BYTE109 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + BYTEVAL SMALLINT, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_BYTE110 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + BYTEVAL SMALLINT, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_DOUBLE111 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + DOUBLEVAL DOUBLE, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_DOUBLE112 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + DOUBLEVAL DOUBLE, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_DOUBLE113 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + DOUBLEVAL DOUBLE, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_FLOAT114 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + FLOATVAL FLOAT, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_FLOAT115 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + FLOATVAL FLOAT, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_FLOAT116 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + FLOATVAL FLOAT, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_INTEGER117 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + INTEGERVAL INTEGER, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_INTEGER118 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + INTEGERVAL INTEGER, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_INTEGER119 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + INTEGERVAL INTEGER, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_LONG120 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + LONGVAL BIGINT, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_LONG121 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + LONGVAL BIGINT, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_LONG122 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + LONGVAL BIGINT, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_SHORT123 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + SHORTVAL SMALLINT, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_SHORT124 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + SHORTVAL SMALLINT, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING_SHORT125 +( + IDENTIFIER INTEGER REFERENCES MAPSTRINGKEY_COLLECTIONS NOT NULL, + KEYVAL INTEGER NOT NULL, + SHORTVAL SMALLINT, + INDEX INTEGER NOT NULL +); + +--MapOfStringValueCollections + +CREATE TABLE MAPSTRINGVALUE_COLLECTIONS ( + IDENTIFIER INTEGER NOT NULL, + CONSTRAINT MSVC_PK PRIMARY KEY (IDENTIFIER) +); + +CREATE TABLE MAP_OF_OBJECT0_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_OBJECT1_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_OBJECT2_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_OBJECT3_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_OBJECT4_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_OBJECT5_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_OBJECT6_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_OBJECT7_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_OBJECT8_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_SIMPLE_CLASS9_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_SIMPLE_CLASS10_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_SIMPLE_CLASS11_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_SIMPLE_CLASS12_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_SIMPLE_CLASS13_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_SIMPLE_CLASS14_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_SIMPLE_CLASS15_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_SIMPLE_CLASS16_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_SIMPLE_CLASS17_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_SIMPLE_INTERFACE18_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_SIMPLE_INTERFACE19_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_SIMPLE_INTERFACE20_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_SIMPLE_INTERFACE21_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_SIMPLE_INTERFACE22_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_SIMPLE_INTERFACE23_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_SIMPLE_INTERFACE24_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_SIMPLE_INTERFACE25_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_SIMPLE_INTERFACE26_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYREF BIGINT REFERENCES SIMPLE_CLASS NOT NULL, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING27_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYVAL VARCHAR(1024), + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING28_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYVAL VARCHAR(1024), + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING29_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYVAL VARCHAR(1024), + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING30_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYVAL VARCHAR(1024), + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING31_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYVAL VARCHAR(1024), + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING32_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYVAL VARCHAR(1024), + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING33_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYVAL VARCHAR(1024), + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING34_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYVAL VARCHAR(1024), + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_STRING35_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYVAL VARCHAR(1024), + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_DATE36_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYVAL DATE, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_DATE37_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYVAL DATE, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_DATE38_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYVAL DATE, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_DATE39_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYVAL DATE, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_DATE40_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYVAL DATE, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_DATE41_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYVAL DATE, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_DATE42_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYVAL DATE, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_DATE43_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYVAL DATE, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_DATE44_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYVAL DATE, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_BIG_DECIMAL45_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYVAL DECIMAL(19), + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_BIG_DECIMAL46_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYVAL DECIMAL(19), + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_BIG_DECIMAL47_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYVAL DECIMAL(19), + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_BIG_DECIMAL48_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYVAL DECIMAL(19), + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_BIG_DECIMAL49_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYVAL DECIMAL(19), + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_BIG_DECIMAL50_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYVAL DECIMAL(19), + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_BIG_DECIMAL51_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYVAL DECIMAL(19), + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_BIG_DECIMAL52_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYVAL DECIMAL(19), + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_BIG_DECIMAL53_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYVAL DECIMAL(19), + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_BIG_INTEGER54_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYVAL BIGINT, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_BIG_INTEGER55_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYVAL BIGINT, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_BIG_INTEGER56_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYVAL BIGINT, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_BIG_INTEGER57_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYVAL BIGINT, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_BIG_INTEGER58_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYVAL BIGINT, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_BIG_INTEGER59_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYVAL BIGINT, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_BIG_INTEGER60_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYVAL BIGINT, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_BIG_INTEGER61_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYVAL BIGINT, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_BIG_INTEGER62_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYVAL BIGINT, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_BYTE63_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYVAL SMALLINT, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_BYTE64_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYVAL SMALLINT, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_BYTE65_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYVAL SMALLINT, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_BYTE66_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYVAL SMALLINT, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_BYTE67_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYVAL SMALLINT, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_BYTE68_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYVAL SMALLINT, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_BYTE69_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYVAL SMALLINT, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_BYTE70_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYVAL SMALLINT, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_BYTE71_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYVAL SMALLINT, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_DOUBLE72_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYVAL DOUBLE, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_DOUBLE73_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYVAL DOUBLE, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_DOUBLE74_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYVAL DOUBLE, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_DOUBLE75_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYVAL DOUBLE, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_DOUBLE76_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYVAL DOUBLE, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_DOUBLE77_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYVAL DOUBLE, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_DOUBLE78_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYVAL DOUBLE, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_DOUBLE79_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYVAL DOUBLE, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_DOUBLE80_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYVAL DOUBLE, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_FLOAT81_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYVAL FLOAT, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_FLOAT82_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYVAL FLOAT, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_FLOAT83_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYVAL FLOAT, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_FLOAT84_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYVAL FLOAT, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_FLOAT85_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYVAL FLOAT, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_FLOAT86_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYVAL FLOAT, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_FLOAT87_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYVAL FLOAT, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_FLOAT88_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYVAL FLOAT, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_FLOAT89_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYVAL FLOAT, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_INTEGER90_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYVAL INTEGER, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_INTEGER91_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYVAL INTEGER, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_INTEGER92_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYVAL INTEGER, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_INTEGER93_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYVAL INTEGER, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_INTEGER94_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYVAL INTEGER, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_INTEGER95_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYVAL INTEGER, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_INTEGER96_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYVAL INTEGER, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_INTEGER97_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYVAL INTEGER, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_INTEGER98_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYVAL INTEGER, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_LONG99_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYVAL BIGINT, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_LONG100_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYVAL BIGINT, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_LONG101_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYVAL BIGINT, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_LONG102_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYVAL BIGINT, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_LONG103_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYVAL BIGINT, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_LONG104_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYVAL BIGINT, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_LONG105_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYVAL BIGINT, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_LONG106_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYVAL BIGINT, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_LONG107_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYVAL BIGINT, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_SHORT108_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYVAL SMALLINT, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_SHORT109_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYVAL SMALLINT, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_SHORT110_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYVAL SMALLINT, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_SHORT111_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYVAL SMALLINT, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_SHORT112_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYVAL SMALLINT, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_SHORT113_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYVAL SMALLINT, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_SHORT114_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYVAL SMALLINT, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_SHORT115_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYVAL SMALLINT, + INDEX INTEGER NOT NULL +); + +CREATE TABLE MAP_OF_SHORT116_STRING ( + IDENTIFIER INTEGER REFERENCES MAPSTRINGVALUE_COLLECTIONS NOT NULL, + VALUEVAL INTEGER NOT NULL, + KEYVAL SMALLINT, INDEX INTEGER NOT NULL );
