-- H2 0.5/B -- -- H2 0.5/B -- -- H2 0.5/B -- eeenSET DEFAULT_LOCK_TIMEOUT 1000ÆeeenSET DEFAULT_TABLE_TYPE 0 1000meeenSET TRACE_LEVEL_FILE 1 0 1000eeenSET TRACE_LEVEL_SYSTEM_OUT 008e eenSET CACHE_SIZE 16384EM_OUT 00Ne eenSET CLUSTER '' 16384EM_OUT 00ìe eenSET WRITE_DELAY 5004EM_OUT 00eeentCREATE USER SA SALT '2a27b916c65b3759' HASH '9fb88d499dd1bffec4c34a04f9a67165f8724e1449ed585632c65828997b14c0' ADMINe-een“CREATE CACHED TABLE PUBLIC.COMP_KEY_EMPLOYEE( EMPLOYEE_ID1 INTEGER NOT NULL, EMPLOYEE_ID2 INTEGER NOT NULL, EMPLOYEE_NO INTEGER NOT NULL, EMPLOYEE_NAME VARCHAR(20), MANAGER_ID1 INTEGER, MANAGER_ID2 INTEGER, HIREDATE DATE, SALARY NUMERIC(7, 2), DEPARTMENT_ID1 INTEGER, DEPARTMENT_ID2 INTEGER, ADDRESS_ID1 INTEGER, ADDRESS_ID2 INTEGER, VERSION INTEGER )ueeenÏCREATE CACHED TABLE PUBLIC.DEPARTMENT( DEPARTMENT_ID INTEGER NOT NULL, DEPARTMENT_NO INTEGER NOT NULL, DEPARTMENT_NAME VARCHAR(20), LOCATION VARCHAR(20) DEFAULT 'TOKYO', VERSION INTEGER ) MANAGER_ID2 ÔNe6een-CREATE PRIMARY KEY ON PUBLIC.LARGE_OBJECT(ID)D START WITH 1201 INCREMENT BY 100RT WITH 331 BELBNe\e@en3CREATE PRIMARY KEY ON PUBLIC.SEQUENCE_STRATEGY2(ID)T WITH 1201 INCREMENT BY 100RT WITH 331 BELïNe@een/CREATE PRIMARY KEY ON PUBLIC.OWNER_OF_NO_ID(ID)(ID)T WITH 1201 INCREMENT BY 100RT WITH 331 BELuNeNeen-CREATE PRIMARY KEY ON PUBLIC.ID_GENERATOR(PK)D)(ID)T WITH 1201 INCREMENT BY 100RT WITH 331 BEL)Ne:e€en$CREATE PRIMARY KEY ON PUBLIC.JOB(ID)RATOR(PK)D)(ID)T WITH 1201 INCREMENT BY 100RT WITH 331 BEL8NeEeen|ALTER TABLE PUBLIC.CONSTRAINT_CHECKING ADD CONSTRAINT PUBLIC.CONSTRAINT_2 UNIQUE(UNIQUE_KEY) INDEX PUBLIC.CONSTRAINT_INDEX_2T_NAME VARCHAR(20), LOCATION VARCHAR(20) DEFAULT 'TOKYO', VERSION INTEGER ) MANAGER_ID2 ÖNe1eenýALTER TABLE PUBLIC.COMP_KEY_EMPLOYEE ADD CONSTRAINT PUBLIC.FK_COMP_KEY_DEPARTMENT_ID FOREIGN KEY(DEPARTMENT_ID1, DEPARTMENT_ID2) INDEX PUBLIC.FK_COMP_KEY_DEPARTMENT_ID_INDEX_0 REFERENCES PUBLIC.COMP_KEY_DEPARTMENT(DEPARTMENT_ID1, DEPARTMENT_ID2) NOCHECK SALARY NUMERIC(7, 2), DEPARTMENT_ID1 INTEGER, DEPARTMENT_ID2 INTEGER, ADDRESS_ID1 INÓEeGeenyALTER TABLE PUBLIC.CONSTRAINT_CHECKING ADD CONSTRAINT PUBLIC.CK_CONSTRAINT_CHECKING_1 CHECK(CHECK_CONSTRAINT > 0) NOCHECKNT_ID2) INDEX PUBLIC.FK_COMP_KEY_DEPARTMENT_ID_INDEX_0 REFERENCES PUBLIC.COMP_KEY_DEPARTMENT(DEPARTME”Te0e€enqCREATE INDEX PUBLIC.FK_COMP_KEY_DEPARTMENT_ID_INDEX_0 ON PUBLIC.COMP_KEY_EMPLOYEE(DEPARTMENT_ID1, DEPARTMENT_ID2)ìeBe@en=CREATE PRIMARY KEY ON PUBLIC.CONSTRAINT_CHECKING(PRIMARY_KEY)IC.COMP_KEY_EMPLOYEE(DEPARTMENT_IB1eIeen ALTER TABLE PUBLIC.CONSTRAINT_CHECKING ADD CONSTRAINT PUBLIC.FK_JOB_ID FOREIGN KEY(FOREIGN_KEY) INDEX PUBLIC.FK_JOB_ID_INDEX_0 REFERENCES PUBLIC.JOB(ID) NOCHECKMENT_ID_INDEX_0 REFERENCES PUBLIC.COMP_KEY_DEPARTMENT(DEPARTMEdTeMeenbCREATE CACHED TABLE PUBLIC.ID_GENERATOR( PK VARCHAR(20) NOT NULL, VALUE INTEGER NOT NULL )DEX PUBLIC.FK_JOB_ID_INDEX_0 REFERENCES PUBLIC.JOB(ID) NOCHECKMENT_ID_INDEX_0 REFERENCES PUBLIC.COMP_KEY_DEPARTMENT(DEPARTME@Te5een¼CREATE CACHED TABLE PUBLIC.LARGE_OBJECT( ID NUMERIC(8) NOT NULL, NAME VARCHAR(10), LARGE_NAME CLOB, BYTES BINARY, LARGE_BYTES BLOB, DTO BINARY, LARGE_DTO BLOB )UBLIC.COMP_KEY_DEPARTMENT(DEPARTME²TePe@en3CREATE PRIMARY KEY ON PUBLIC.MY_ID_GENERATOR(MY_PK)IMARY_KEY)IC.COMP_KEY_EMPLOYEE(DEPARTMENT_If1e=eenJCREATE CACHED TABLE PUBLIC.NO_ID( VALUE1 INTEGER, VALUE2 INTEGER )AME VARCHAR(10), ILeOeenkCREATE CACHED TABLE PUBLIC.MY_ID_GENERATOR( MY_PK VARCHAR(20) NOT NULL, MY_VALUE INTEGER NOT NULL )LOB, BYTES BINARY, LARGE_BYTES BLOB, DTO BINARY, LARGE_DTO BLOB )UBLIC.COMP_KEY_DEPARTMENT(DEPARTMETe3eenèALTER TABLE PUBLIC.COMP_KEY_EMPLOYEE ADD CONSTRAINT PUBLIC.FK_COMP_KEY_ADDRESS_ID FOREIGN KEY(ADDRESS_ID1, ADDRESS_ID2) INDEX PUBLIC.FK_COMP_KEY_ADDRESS_ID_INDEX_0 REFERENCES PUBLIC.COMP_KEY_ADDRESS(ADDRESS_ID1, ADDRESS_ID2) NOCHECKPARTMENT_ID2) NOCHECK SALARY NUMERIC(7, 2), DEPARTMENT_ID1 INTEGER, DEPARTMENT_ID2 INTEGER, ADDRESS_ID1 IN EeSeenCREATE CACHED TABLE PUBLIC.AUTO_STRATEGY( ID INTEGER DEFAULT (NEXT VALUE FOR PUBLIC.SYSTEM_SEQUENCE_395FDCC0_465B_4CDA_93E1_5A9709CFF584) NOT NULL NULL_TO_DEFAULT SEQUENCE PUBLIC.SYSTEM_SEQUENCE_395FDCC0_465B_4CDA_93E1_5A9709CFF584, VALUE VARCHAR(10) ) NUMERIC(7, 2), DEPARTMENT_ID1 INTEGER, DEPARTMENT_ID2 INTEGER, ADDRESS_ID1 INOEe^e€en/CREATE PRIMARY KEY ON PUBLIC.TABLE_STRATEGY(ID)_PK)IMARY_KEY)IC.COMP_KEY_EMPLOYEE(DEPARTMENT_Ic1eHeÀenPCREATE INDEX PUBLIC.FK_JOB_ID_INDEX_0 ON PUBLIC.CONSTRAINT_CHECKING(FOREIGN_KEY)E(DEPARTMENT_I‹1e2eÀenhCREATE INDEX PUBLIC.FK_COMP_KEY_ADDRESS_ID_INDEX_0 ON PUBLIC.COMP_KEY_EMPLOYEE(ADDRESS_ID1, ADDRESS_ID2)MENT_ID2)ÖeDe€enWCREATE UNIQUE INDEX PUBLIC.CONSTRAINT_INDEX_2 ON PUBLIC.CONSTRAINT_CHECKING(UNIQUE_KEY)ID1, ADDRESS_ID2)MENT_ID2),e7eenCREATE CACHED TABLE PUBLIC.TENSE( ID INTEGER NOT NULL, DATE_DATE DATE, DATE_TIME TIME, DATE_TIMESTAMP TIMESTAMP, CAL_DATE DATE, CAL_TIME TIME, CAL_TIMESTAMP TIMESTAMP, SQL_DATE DATE, SQL_TIME TIME, SQL_TIMESTAMP TIMESTAMP )MERIC(7, 2), DEPARTMENT_ID1 INTEGER, DEPARTMENT_ID2 INTEGER, ADDRESS_ID1 INÝEeTe€en.CREATE PRIMARY KEY ON PUBLIC.AUTO_STRATEGY(ID)ON PUBLIC.CONSTRAINT_CHECKING(UNIQUE_KEY)ID1, AD§ReN eeKnALLENekQÓŸ€g1600.00eeeY_ID START WITH 1201 INCREMENT BY 100RT WITH 331 BELéN e eÞnFORDekW”zU€g3000.00ee eY_ID START WITH 1201 INCREMENT BY 100RT WITH 331 BELµN eeŽnJONESe kR¦ÄI€g2975.00eeeY_ID START WITH 1201 INCREMENT BY 100RT WITH 331 BEL N eefnCLARKe kTô¹€g2450.00eeeY_ID START WITH 1201 INCREMENT BY 100RT WITH 331 BELÊN eeanWARDekQÝìE€g1250.00eeeY_ID START WITH 1201 INCREMENT BY 100RT WITH 331 BELÓN eeænMARTINekV@–€g1250.00eeeY_ID START WITH 1201 INCREMENT BY 100RT WITH 331 BELcN eelnSCOTTek_ ©€g3000.00eeeY_ID START WITH 1201 INCREMENT BY 100RT WITH 331 BELN eenBLAKEe kS<µ€g2850.00eeeY_ID START WITH 1201 INCREMENT BY 100RT WITH 331 BELÇN e e¤nTURNERekUÙ—m€g1500.00ee eY_ID START WITH 1201 INCREMENT BY 100RT WITH 331 BEL¨N eeÉnSMITHe kP„â1€g800.00eeeY_ID START WITH 1201 INCREMENT BY 100RT WITH 331 BELêN%eee n ACCOUNTINGnNEW YORKeQUENCE_STRATEGY_ID START WITH 1201 INCREMENT BY 100RT WITH 331 BEL?N%eeenRESEARCHnDALLASeQUENCE_STRATEGY_ID START WITH 1 INCREMENT BY 100START WITH 1 BELON˜S%eeenSALESnCHICAGOeeeY_ID START WITH 1 INCREMENT BY 100START WITH 1 BELON«S%eee(n OPERATIONSnBOSTONeeeY_ID START WITH 1 INCREMENT BY 100START WITH 1 BELON-S+eenSTREET 1eNSnBOSTONeeeY_ID START WITH 1 INCREMENT BY 100START WITH 1 BELONÇS+eenSTREET 2eNSnBOSTONeeeY_ID START WITH 1 INCREMENT BY 100START WITH 1 BELONÊS+eenSTREET 3eNSnBOSTONeeeY_ID START WITH 1 INCREMENT BY 100START WITH 1 BELONÍS+eenSTREET 4eNSnBOSTONeeeY_ID START WITH 1 INCREMENT BY 100START WITH 1 BELONÐS+eenSTREET 5eNSnBOSTONeeeY_ID START WITH 1 INCREMENT BY 100START WITH 1 BELONÓS+eenSTREET 6eNSnBOSTONeeeY_ID START WITH 1 INCREMENT BY 100START WITH 1 BELONÖS+eenSTREET 7eNSnBOSTONeeeY_ID START WITH 1 INCREMENT BY 100START WITH 1 BELONÙS+eenSTREET 8eNSnBOSTONeeeY_ID START WITH 1 INCREMENT BY 100START WITH 1 BELONÜS+e e nSTREET 9eNSnBOSTONeeeY_ID START WITH 1 INCREMENT BY 100START WITH 1 BELONßS+e e n STREET 10eSnBOSTONeeeY_ID START WITH 1 INCREMENT BY 100START WITH 1 BELON¼S+e e n STREET 11eSnBOSTONeeeY_ID START WITH 1 INCREMENT BY 100START WITH 1 BELON¿S+e e n STREET 12eSnBOSTONeeeY_ID START WITH 1 INCREMENT BY 100START WITH 1 BELONÂS+e e n STREET 13eSnBOSTONeeeY_ID START WITH 1 INCREMENT BY 100START WITH 1 BELONÅS+een STREET 14eSnBOSTONeeeY_ID START WITH 1 INCREMENT BY 100START WITH 1 BELONÈS- eeeKnALLENeekQÓŸ€g1600.00eeeee INCREMENT BY 100ART WITH 221 BEL©N- eeeÉnSMITHe e kP„â1€g800.00eeeee INCREMENT BY 100ART WITH 221 BEL¯N- eeeanWARDeekQÝìE€g1250.00eeeeeNCREMENT BY 100START WITH 1 BELON S- eeeŽnJONESe e kR¦ÄI€g2975.00eeeeeNCREMENT BY 100START WITH 1 BELONGS- eeeænMARTINeekV@–€g1250.00eeeeeCREMENT BY 100START WITH 1 BELONSS- eeenBLAKEe e kS<µ€g2850.00eeeeeCREMENT BY 100START WITH 1 BELON¼S- eeefnCLARKe e kTô¹€g2450.00eeeeeCREMENT BY 100START WITH 1 BELON¿S- eeelnSCOTTeek_ ©€g3000.00eeeeeCREMENT BY 100START WITH 1 BELONøS- e e eŸnKING--kWB•€g5000.00eee e eeCREMENT BY 100START WITH 1 BELONÞS- e e e¤nTURNEReekUÙ—m€g1500.00eee e eCREMENT BY 100START WITH 1 BELON¢S- e e eÄnADAMSeek_º)á€g1100.00eee e eCREMENT BY 100START WITH 1 BELON;S- e e eÜnJAMESeekW”zU€g950.00eee e eCREMENT BY 100START WITH 1 BELONÒS- e e eÞnFORDeekW”zU€g3000.00eee e eCREMENT BY 100START WITH 1 BELON²S- eeeþnMILLEReekX›©€g1300.00eeeeeCREMENT BY 100START WITH 1 BELONuS7 ek ;­€j¯°lÙ°k ;­€j¯°lÙ°k ;­€j¯°lÙ°0RT WITH 331 BELßN9enSALESMAN¯°lÙ°k ;­€j¯°lÙ°k ;­€j¯°lÙ°ART WITH 1 BELONŸS9enMANAGERN¯°lÙ°k ;­€j¯°lÙ°k ;­€j¯°lÙ°ART WITH 1 BELON”S9en PRESIDENT¯°lÙ°k ;­€j¯°lÙ°k ;­€j¯°lÙ°ART WITH 1 BELONüS;ee PRESIDENT¯°lÙ°k ;­€j¯°lÙ°k ;­€j¯°lÙ°ART WITH 1 BELONôS;eePRESIDENT¯°lÙ°k ;­€j¯°lÙ°k ;­€j¯°lÙ°ART WITH 1 BELONÿS;eePRESIDENT¯°lÙ°k ;­€j¯°lÙ°k ;­€j¯°lÙ°ART WITH 1 BELON S=eePRESIDENT¯°lÙ°k ;­€j¯°lÙ°k ;­€j¯°lÙ°ART WITH 1 BELONíS=eePRESIDENT¯°lÙ°k ;­€j¯°lÙ°k ;­€j¯°lÙ°ART WITH 1 BELONíSMnTABLE_STRATEGY_IDe‘SEQUENCE PUBLIC.MY_SEQUENCE_STRATEGY_ID START WITH 1201 INCREMENT BY 100RT WITH 331 BEL9NOnTableStrategy2e‘TE SEQUENCE PUBLIC.MY_SEQUENCE_STRATEGY_ID START WITH 1201 INCREMENT BY 100RT WITH 331 BEL8N