SQLite format 3@ a&a-â'ç"ûöñìçƒ1†5tableEMPLOYEEEMPLOYEECREATE TABLE EMPLOYEE(EMPLOYEE_ID INTEGER NOT NULL PRIMARY KEY, EMPLOYEE_NO INTEGER NOT NULL ,EMPLOYEE_NAME VARCHAR(20),MANAGER_ID INTEGER,HIREDATE DATE,SALARY NUMERIC(7,2),DEPARTMENT_ID INTEGER,ADDRESS_ID INTEGER,VERSION INTEGER, CONSTRAINT FK_DEPARTMENT_ID FOREIGN KEY(DEPARTMENT_ID) REFERENCES DEPARTMENT(DEPARTMENT_ID), CONSTRAINT FK_ADDRESS_ID FOREIGN KEY(ADDRESS_ID) REFERENCES ADDRESS(ADDRESS_ID))}�QtableADDRESSADDRESSCREATE TABLE ADDRESS(ADDRESS_ID INTEGER NOT NULL PRIMARY KEY, STREET VARCHAR(20), VERSION INTEGER)�]!!ƒtableDEPARTMENTDEPARTMENTCREATE TABLE DEPARTMENT(DEPARTMENT_ID INTEGER NOT NULL PRIMARY KEY, DEPARTMENT_NO INTEGER NOT NULL UNIQUE,DEPARTMENT_NAME VARCHAR(20),LOCATION VARCHAR(20) DEFAULT 'TOKYO', VERSION INTEGER)3G!indexsqlite_autoindex_DE   åι ! (OPERATIONSBOSTON SALESCHICAGO RESEARCHDALLAS! ACCOUNTINGNEW YORK éûõïé( 7òäÖȺ¬ž�‚sdUF7  STREET 14  STREET 13  STREET 12  STREET 11  STREET 10  STREET 9  STREET 8  STREET 7  STREET 6  STREET 5  STREET 4  STREET 3  STREET 2  STREET 1 )ß½œzW5òÓ°ŽlK)  !  þMILLER1982-01-23 ! ÞFORD1981-12-03 ¸ ! ÜJAMES1981-12-03¶ ! ÄADAMS1983-01-12L ! ! ¤TURNER1981-09-08Ü  !  ŸKING1981-11-17ˆ  ! lSCOTT1982-12-09 ¸ !  fCLARK 1981-06-09 ’  ! BLAKE 1981-05-01 "! ! æMARTIN1981-09-28â  ! ŽJONES 1981-04-02 Ÿ ! aWARD1981-02-22â  ! KALLEN1981-02-20@ ! ÉSMITH 1980-12-17  –äʲ–! (OPERATIONSBOSTON SALESCHICAGO RESEARCHDALLAS ! ACCOUNTINGNEW YORK éûõïé( ¸¸˜ÍL¹&&EY3indexsqlite_autoindex_COMP_KEY_DEPARTMENT_2COMP_KEY_DEPARTMENT �]!!ƒtableDEPARTMENTDEPARTMENTCREATE TABLE DEPARTMENT(DEPARTMENT_ID I�]!!ƒtableDEPARTMENTDEPARTMENTCREATE TABLE DEPARTMENT(DEPARTMENT_ID INTEGER NOT NULL PRIMARY KEY, DEPARTMENT_NO INTEGER NOT NULL UNIQUE,DEPARTMENT_NAME VARCHAR(20),LOCATION VARCHAR(20) DEFAULT 'TOKYO', VERSION INTEGER)3G!indexsqlite_autoindex_DEPARTMENT_1DEPARTMENT}�QtableADDRESSADDRESSCREATE TABLE ADDRESS(ADDRESS_ID INTEGER NOT NULL PRIMARY KEY, STREET VARCHAR(20), VERSION INTEGER)ƒ1†5tableEMPLOYEEEMPLOYEECREATE TABLE EMPLOYEE(EMPLOYEE_ID INTEGER NOT NULL PRIMARY KEY, EMPLOYEE_NO INTEGER NOT NULL ,EMPLOYEE_NAME VARCHAR(20),MANAGER_ID INTEGER,HIREDATE DATE,SALARY NUMERIC(7,2),DEPARTMENT_ID INTEGER,ADDRESS_ID INTEGER,VERSION INTEGER, CONSTRAINT FK_DEPARTMENT_ID FOREIGN KEY(DEPARTMENT_ID) REFERENCES DEPARTMENT(DEPARTMENT_ID), CONSTRAINT FK_ADDRESS_ID FOREIGN KEY(ADDRESS_ID) REFERENCES ADDRESS(ADDRESS_ID)) ãûóëã ÝÝ=„Ë¿––A U/indexsqlite_autoindex_COMP_KEY_EMPLOYEE_1COMP_KEY_EMPLOYEE�q‚]33„atableCOMP_KEY_DEPARTMENTCOMP_KEY_DEPARTMENTCREATE TABLE COMP_KEY_DEPARTMENT(DEPARTMENT_ID1 INTEGER NOT NULL, DEPARTMENT_ID2 INTEGER NOT NULL, DEPARTMENT_NO INTEGER NOT NULL UNIQUE,DEPARTMENT_NAME VARCHAR(20),LOCATION VARCHAR(20) DEFAULT 'TOKYO', VERSION INTEGER, CONSTRAINT PK_COMP_KEY_DEPARTMENT PRIMARY KEY(DEPARTMENT_ID1, DEPARTMENT_ID2))EY3indexsqlite_autoindex_COMP_KEY_DEPARTMENT_1COMP_KEY_DEPARTMENTEY3indexsqlite_autoindex_COMP_KEY_DEPARTMENT_2COMP_KEY_DEPARTMENT �q--ƒtableCOMP_KEY_ADDRESSCOMP_KEY_ADDRESS CREATE TABLE COMP_KEY_ADDRESS(ADDRESS_ID1 INTEGER NOT NULL, ADDRESS_ID2 INTEGER NOT NULL, STREET VARCHAR(20), VERSION INTEGER, CONSTRAINT PK_COMP_KEY_ADDRESS PRIMARY KEY(ADDRESS_ID1, ADDRESS_ID2))? S-indexsqlite_autoindex_COMP_KEY_ADDRESS_1COMP_KEY_ADDRESS ñàϾ­œ‹ziWE3! STREET 14  STREET 13  STREET 12  STREET 11  STREET 10  STREET 9 STREET 8 STREET 7 STREET 6 STREET 5 STREET 4 STREET 3 STREET 2   STREET 1 “ûóëãÛÓËû³«£›“      ²Ù®„Y-Ù®ˆ\1ܲ(!  þMILLER1982-01-23( ! ÞFORD1981-12-03 ¸ ) ! ÜJAMES1981-12-03¶ ) ! ÄADAMS1983-01-12L * ! ¤TURNER1981-09-08Ü $ !  ŸKING1981-11-17ˆ )! lSCOTT1982-12-09 ¸'!  fCLARK 1981-06-09 ’)! BLAKE 1981-05-01 "*! æMARTIN1981-09-28â)! ŽJONES 1981-04-02 Ÿ(! aWARD1981-02-22â)! KALLEN1981-02-20@% ! ÉSMITH 1980-12-17  “ûóëãÛÓËû³«£›“      ))ù<°…M //ŠItableCOMP_KEY_EMPLOYEECOMP_KEY_EMPLOYEE CREATE TABLE 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, CONSTRAINT PK_COMP_KEY_EMPLOYEE PRIMARY KEY(EMPLOYEE_ID1, EMPLOYEE_ID2), CONSTRAINT FK_COMP_KEY_DEPARTMENT_ID FOREIGN KEY(DEPARTMENT_ID1, DEPARTMENT_ID2) REFERENCES COMP_KEY_DEPARTMENT(DEPARTMENT_ID1, DEPARTMENT_ID2), CONSTRAINT FK_COMP_KEY_ADDRESS_ID FOREIGN KEY(ADDRESS_ID1, ADDRESS_ID2) REFERENCES COMP_KEY_ADDRESS(ADDRESS_ID1, ADDRESS_ID2))A U/indexsqlite_autoindex_COMP_KEY_EMPLOYEE_1COMP_KEY_EMPLOYEE�A %%‚EtableLARGE_OBJECTLARGE_OBJECTCREATE TABLE LARGE_OBJECT(ID NUMERIC(8) NOT NULL PRIMARY KEY, NAME VARCHAR(20), LARGE_NAME CLOB, BYTES BINARY, LARGE_BYTES BLOB, DTO BINARY, LARGE_DTO BLOB)   DD}iÆ7‚¹¹9|))�3tableOWNER_OF_NO_IDOWNER_OF_NO_IDCREATE TABLE OWNER_OF_NO_ID (ID INTEGER NOT NULL PRIMARY KEY, NO_ID_VALUE1 INTEGER)IstableNO_IDNO_IDCREATE TABLE NO_ID (VALUE1 INTEGER, VA7 K�A %%‚EtableLARGE_OBJECTLARGE_OBJECTCREATE TABLE LARGE_OBJECT(ID N7 K%indexsqlite_autoindex_LARGE_OBJECT_1LARGE_OBJECT�iƒ1tableTENSETENSECREATE TABLE TENSE (ID INTEGER PRIMARY KEY,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)[�tableJOBJOBCREATE TABLE JOB (ID INTEGER NOT NULL PRIMARY KEY, JOB_TYPE VARCHAR(20))o�-tableAUTHORITYAUTHORITYCREATE TABLE AUTHORITY (ID INTEGER NOT NULL PRIMARY KEY, AUTHORITY_TYPE INTEGER)IstableNO_IDNO_IDCREATE TABLE NO_ID (VALUE1 INTEGER, VALUE2 INTEGER)|))�3tableOWNER_OF_NO_IDOWNER_OF_NO_IDCREATE TABLE OWNER_OF_NO_ID (ID INTEGER NOT NULL PRIMARY KEY, NO_ID_VALUE1 INTEGER) „„z !3!3!32005-02-1412:11:102005-02-14 12:11:102005-02-1412:11:102005-02-14 12:11:102005-02-1412:11:102005-02-14 12:11:10 ÙóçÙ PRESIDENT MANAGER SALESMAN îúôî öûö     ��ó:~û4Áu''�)tableAUTO_STRATEGYAUTO_STRATEGY CREATE TABLE AUTO_STRATEGY(ID INTEGER NOT NULL PRIMARY KEY, VALUE VARCHAR(10))‚`33„gtableCONSTRAINT_CHECKINGCONSTRAINT_CHECKINGCREATE TABLE CONSTRAINT_CHECKING (PRIMARY_KEY INTEGER PRIMARY KEY, UNIQUE_KEY INTEGER UNIQUE, FOREIGN_KEY INTEGER, CHECK_CONSTRAINT INTEGER, NOT_NULL INTEGER NOT NULL, CONSTRAINT CK_CONSTRAINT_CHECKING_1 CHECK (CHECK_CONSTRAINT > 0), CONSTRAINT FK_JOB_ID FOREIGN KEY (FOREIGN_KEY) REFERENCES JOB (ID))EY3indexsqlite_autoindex_CONSTRAINT_CHECKING_1CONSTRAINT_CHECKINGB]tablePATTERNPATTERNCREATE TABLE PATTERN (VALUE VARCHAR(10)){%%�9tableID_GENERATORID_GENERATORCREATE TABLE ID_GENERATOR(PK VARCHAR(20) NOT NULL PRIMARY KEY, VALUE INTEGER NOT NULL)7K%indexsqlite_autoindex_ID_GENERATOR_1ID_GENERATOR� ++�KtableMY_ID_GENERATORMY_ID_GENERATORCREATE TABLE MY_ID_GENERATOR(MY_PK VARCHAR(20) NOT NULL PRIMARY KEY, MY_VALUE INTEGER NOT NULL)=Q+indexsqlite_autoindex_MY_ID_GENERATOR_1MY_ID_GENERATOR  êê/ TABLE_STRATEGY_ID ëë/ TABLE_STRATEGY_ID íí) TableStrategy2 îî) TableStrategy2   zþ‚ ƒñwüx))�+tableTABLE_STRATEGYTABLE_STRATEGY%CREATE TABLE TABLE_STRATEGY(ID INTEGER NOT NULL PRIMARY KEY, VALUE VARCHAR(10))�11�3tableSEQu''�)tableAUTO_STRATEGYAUTO_STRATEGY CREATE TABLE AUTO_STRATEGY(ID INTEGER NOT NULL PRIMARY KEY, VALUE VARCHAR(10))�//�1tableIDENTITY_STRATEGYIDENTITY_STRATEGY!CREATE TABLE IDENTITY_STRATEGY(ID INTEGER NOT NULL PRIMARY KEY, VALUE VARCHAR(10))�//�1tableSEQUENCE_STRATEGYSEQUENCE_STRATEGY#CREATE TABLE SEQUENCE_STRATEGY(ID INTEGER NOT NULL PRIMARY KEY, VALUE VARCHAR(10))�11�3tableSEQUENCE_STRATEGY2SEQUENCE_STRATEGY2$CREATE TABLE SEQUENCE_STRATEGY2(ID INTEGER NOT NULL PRIMARY KEY, VALUE VARCHAR(10))x))�+tableTABLE_STRATEGYTABLE_STRATEGY%CREATE TABLE TABLE_STRATEGY(ID INTEGER NOT NULL PRIMARY KEY, VALUE VARCHAR(10)){++�-tableTABLE_STRATEGY2TABLE_STRATEGY2&CREATE TABLE TABLE_STRATEGY2(ID INTEGER NOT NULL PRIMARY KEY, VALUE VARCHAR(10))