-- 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)PARTMENT_ID INTEGER NOT NULL, DEPARTMENT_NO I3Te\e@en3CREATE PRIMARY KEY ON PUBLIC.SEQUENCE_STRATEGY2(ID)NT_ID INTEGER NOT NULL, DEPARTMENT_NO IµTe@een/CREATE PRIMARY KEY ON PUBLIC.OWNER_OF_NO_ID(ID)(ID)NT_ID INTEGER NOT NULL, DEPARTMENT_NO I;TeNeen-CREATE PRIMARY KEY ON PUBLIC.ID_GENERATOR(PK)D)(ID)NT_ID INTEGER NOT NULL, DEPARTMENT_NO IïTe:e€en$CREATE PRIMARY KEY ON PUBLIC.JOB(ID)RATOR(PK)D)(ID)NT_ID INTEGER NOT NULL, DEPARTMENT_NO IþTeEeen|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) NOCHECKNT_ID2) INDEX PUBLIC.FK_COMP_KEY_DEPARTMENT_ID_INDEX_0 REFERENCES PUBLIC.COMP_KEY_DEPARTMENT(DEPARTMEôTeBe@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)ERIC(8) NOT NULL, NAME VARCHAR(10), Le=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)D INTEGER DEFAULT (NEXT VALUE FOR PUBLIC.SYSTEMMSeHeÀenPCREATE INDEX PUBLIC.FK_JOB_ID_INDEX_0 ON PUBLIC.CONSTRAINT_CHECKING(FOREIGN_KEY) PUBLIC.SYSTEMtSe2eÀenhCREATE INDEX PUBLIC.FK_COMP_KEY_ADDRESS_ID_INDEX_0 ON PUBLIC.COMP_KEY_EMPLOYEE(ADDRESS_ID1, ADDRESS_ID2)395FDCC0_465B_4CDA_93E1_5A9709CFF584) NOT NULL NULL_TO_DEFAULT SEQUENCE PUBLIC.SYSTEM_SEQUENCE_395FDCC0_465B_4CDA_93E1Ë5eDe€enWCREATE UNIQUE INDEX PUBLIC.CONSTRAINT_INDEX_2 ON PUBLIC.CONSTRAINT_CHECKING(UNIQUE_KEY)ID1, ADDRESS_ID2)395FDCC0_465B_4CDA_93E1_5A9709CFF584) NOT NULL NULL_TO_DEFAULT SEQUENCE PUBLIC.SYSTEM_SEQUENCE_395FDCC0_465B_4CDA_93E1!5e7eenCREATE 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)ER NOT NULL, DATE_DATE DATE, DATE_TIME TÆMe