SQLite format 3@ a&a-'"15tableEMPLOYEEEMPLOYEECREATE 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 ( 7sdUF7  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 )zW5lK)  !  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)15tableEMPLOYEEEMPLOYEECREATE 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_EMPLOYEEq]33atableCOMP_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_EMPLOYEEA %%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}i79|))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 KA %%EtableLARGE_OBJECTLARGE_OBJECTCREATE TABLE LARGE_OBJECT(ID N7 K%indexsqlite_autoindex_LARGE_OBJECT_1LARGE_OBJECTi1tableTENSETENSECREATE 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       :~4u'')tableAUTO_STRATEGYAUTO_STRATEGY CREATE TABLE AUTO_STRATEGY(ID INTEGER NOT NULL PRIMARY KEY, VALUE VARCHAR(10))`33gtableCONSTRAINT_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 wx))+tableTABLE_STRATEGYTABLE_STRATEGY%CREATE TABLE TABLE_STRATEGY(ID INTEGER NOT NULL PRIMARY KEY, VALUE VARCHAR(10))113tableSEQu'')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))113tableSEQUENCE_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))