CREATE SCHEMA PUBLIC AUTHORIZATION DBA
CREATE SEQUENCE SEQUENCE_STRATEGY_ID AS INTEGER START WITH 1 INCREMENT BY 100 
CREATE SEQUENCE MY_SEQUENCE_STRATEGY_ID AS INTEGER START WITH 1 INCREMENT BY 100 
CREATE MEMORY TABLE DEPARTMENT(DEPARTMENT_ID INTEGER NOT NULL PRIMARY KEY,DEPARTMENT_NO INTEGER NOT NULL,DEPARTMENT_NAME VARCHAR(20),LOCATION VARCHAR(20) DEFAULT 'TOKYO',VERSION INTEGER,CONSTRAINT UQ_DEPARTMENT UNIQUE(DEPARTMENT_NO))
CREATE MEMORY TABLE ADDRESS(ADDRESS_ID INTEGER NOT NULL PRIMARY KEY,STREET VARCHAR(20),VERSION INTEGER)
CREATE MEMORY 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))
CREATE MEMORY TABLE COMP_KEY_DEPARTMENT(DEPARTMENT_ID1 INTEGER NOT NULL,DEPARTMENT_ID2 INTEGER NOT NULL,DEPARTMENT_NO INTEGER NOT NULL,DEPARTMENT_NAME VARCHAR(20),LOCATION VARCHAR(20) DEFAULT 'TOKYO',VERSION INTEGER,CONSTRAINT PK_COMP_KEY_DEPARTMENT PRIMARY KEY(DEPARTMENT_ID1,DEPARTMENT_ID2),CONSTRAINT UQ_COMP_KEY_DEPARTMENT UNIQUE(DEPARTMENT_NO))
CREATE MEMORY 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))
CREATE MEMORY 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))
CREATE MEMORY TABLE LARGE_OBJECT(ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(20),LARGE_NAME LONGVARCHAR,BYTES VARBINARY,LARGE_BYTES LONGVARBINARY,DTO VARBINARY,LARGE_DTO LONGVARBINARY)
CREATE MEMORY TABLE TENSE(ID INTEGER NOT NULL 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)
CREATE MEMORY TABLE JOB(ID INTEGER NOT NULL PRIMARY KEY,JOB_TYPE VARCHAR(20))
CREATE MEMORY TABLE AUTHORITY(ID INTEGER NOT NULL PRIMARY KEY,AUTHORITY_TYPE INTEGER)
CREATE MEMORY TABLE NO_ID(VALUE1 INTEGER,VALUE2 INTEGER)
CREATE MEMORY TABLE OWNER_OF_NO_ID(ID INTEGER NOT NULL PRIMARY KEY,NO_ID_VALUE1 INTEGER)
CREATE MEMORY TABLE CONSTRAINT_CHECKING(PRIMARY_KEY INTEGER NOT NULL PRIMARY KEY,UNIQUE_KEY INTEGER,FOREIGN_KEY INTEGER,CHECK_CONSTRAINT INTEGER,NOT_NULL INTEGER NOT NULL,CONSTRAINT CK_CONSTRAINT_CHECKING_1 CHECK(CONSTRAINT_CHECKING.CHECK_CONSTRAINT>0),CONSTRAINT FK_JOB_ID FOREIGN KEY(FOREIGN_KEY) REFERENCES JOB(ID),CONSTRAINT SYS_CT_68 UNIQUE(UNIQUE_KEY))
CREATE MEMORY TABLE PATTERN(VALUE VARCHAR(10))
CREATE MEMORY TABLE ID_GENERATOR(PK VARCHAR(20) NOT NULL PRIMARY KEY,VALUE INTEGER NOT NULL)
CREATE MEMORY TABLE MY_ID_GENERATOR(MY_PK VARCHAR(20) NOT NULL PRIMARY KEY,MY_VALUE INTEGER NOT NULL)
CREATE MEMORY TABLE AUTO_STRATEGY(ID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 1) NOT NULL PRIMARY KEY,VALUE VARCHAR(10))
CREATE MEMORY TABLE IDENTITY_STRATEGY(ID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 1) NOT NULL PRIMARY KEY,VALUE VARCHAR(10))
CREATE MEMORY TABLE SEQUENCE_STRATEGY(ID INTEGER NOT NULL PRIMARY KEY,VALUE VARCHAR(10))
CREATE MEMORY TABLE SEQUENCE_STRATEGY2(ID INTEGER NOT NULL PRIMARY KEY,VALUE VARCHAR(10))
CREATE MEMORY TABLE TABLE_STRATEGY(ID INTEGER NOT NULL PRIMARY KEY,VALUE VARCHAR(10))
CREATE MEMORY TABLE TABLE_STRATEGY2(ID INTEGER NOT NULL PRIMARY KEY,VALUE VARCHAR(10))
ALTER TABLE AUTO_STRATEGY ALTER COLUMN ID RESTART WITH 1
ALTER TABLE IDENTITY_STRATEGY ALTER COLUMN ID RESTART WITH 1
CREATE USER SA PASSWORD ""
GRANT DBA TO SA
SET WRITE_DELAY 60
SET SCHEMA PUBLIC
INSERT INTO DEPARTMENT VALUES(1,10,'ACCOUNTING','NEW YORK',1)
INSERT INTO DEPARTMENT VALUES(2,20,'RESEARCH','DALLAS',1)
INSERT INTO DEPARTMENT VALUES(3,30,'SALES','CHICAGO',1)
INSERT INTO DEPARTMENT VALUES(4,40,'OPERATIONS','BOSTON',1)
INSERT INTO ADDRESS VALUES(1,'STREET 1',1)
INSERT INTO ADDRESS VALUES(2,'STREET 2',1)
INSERT INTO ADDRESS VALUES(3,'STREET 3',1)
INSERT INTO ADDRESS VALUES(4,'STREET 4',1)
INSERT INTO ADDRESS VALUES(5,'STREET 5',1)
INSERT INTO ADDRESS VALUES(6,'STREET 6',1)
INSERT INTO ADDRESS VALUES(7,'STREET 7',1)
INSERT INTO ADDRESS VALUES(8,'STREET 8',1)
INSERT INTO ADDRESS VALUES(9,'STREET 9',1)
INSERT INTO ADDRESS VALUES(10,'STREET 10',1)
INSERT INTO ADDRESS VALUES(11,'STREET 11',1)
INSERT INTO ADDRESS VALUES(12,'STREET 12',1)
INSERT INTO ADDRESS VALUES(13,'STREET 13',1)
INSERT INTO ADDRESS VALUES(14,'STREET 14',1)
INSERT INTO EMPLOYEE VALUES(1,7369,'SMITH',13,'1980-12-17',800,2,1,1)
INSERT INTO EMPLOYEE VALUES(2,7499,'ALLEN',6,'1981-02-20',1600,3,2,1)
INSERT INTO EMPLOYEE VALUES(3,7521,'WARD',6,'1981-02-22',1250,3,3,1)
INSERT INTO EMPLOYEE VALUES(4,7566,'JONES',9,'1981-04-02',2975,2,4,1)
INSERT INTO EMPLOYEE VALUES(5,7654,'MARTIN',6,'1981-09-28',1250,3,5,1)
INSERT INTO EMPLOYEE VALUES(6,7698,'BLAKE',9,'1981-05-01',2850,3,6,1)
INSERT INTO EMPLOYEE VALUES(7,7782,'CLARK',9,'1981-06-09',2450,1,7,1)
INSERT INTO EMPLOYEE VALUES(8,7788,'SCOTT',4,'1982-12-09',3000.0,2,8,1)
INSERT INTO EMPLOYEE VALUES(9,7839,'KING',NULL,'1981-11-17',5000,1,9,1)
INSERT INTO EMPLOYEE VALUES(10,7844,'TURNER',6,'1981-09-08',1500,3,10,1)
INSERT INTO EMPLOYEE VALUES(11,7876,'ADAMS',8,'1983-01-12',1100,2,11,1)
INSERT INTO EMPLOYEE VALUES(12,7900,'JAMES',6,'1981-12-03',950,3,12,1)
INSERT INTO EMPLOYEE VALUES(13,7902,'FORD',4,'1981-12-03',3000,2,13,1)
INSERT INTO EMPLOYEE VALUES(14,7934,'MILLER',7,'1982-01-23',1300,1,14,1)
INSERT INTO COMP_KEY_DEPARTMENT VALUES(1,1,10,'ACCOUNTING','NEW YORK',1)
INSERT INTO COMP_KEY_DEPARTMENT VALUES(2,2,20,'RESEARCH','DALLAS',1)
INSERT INTO COMP_KEY_DEPARTMENT VALUES(3,3,30,'SALES','CHICAGO',1)
INSERT INTO COMP_KEY_DEPARTMENT VALUES(4,4,40,'OPERATIONS','BOSTON',1)
INSERT INTO COMP_KEY_ADDRESS VALUES(1,1,'STREET 1',1)
INSERT INTO COMP_KEY_ADDRESS VALUES(2,2,'STREET 2',1)
INSERT INTO COMP_KEY_ADDRESS VALUES(3,3,'STREET 3',1)
INSERT INTO COMP_KEY_ADDRESS VALUES(4,4,'STREET 4',1)
INSERT INTO COMP_KEY_ADDRESS VALUES(5,5,'STREET 5',1)
INSERT INTO COMP_KEY_ADDRESS VALUES(6,6,'STREET 6',1)
INSERT INTO COMP_KEY_ADDRESS VALUES(7,7,'STREET 7',1)
INSERT INTO COMP_KEY_ADDRESS VALUES(8,8,'STREET 8',1)
INSERT INTO COMP_KEY_ADDRESS VALUES(9,9,'STREET 9',1)
INSERT INTO COMP_KEY_ADDRESS VALUES(10,10,'STREET 10',1)
INSERT INTO COMP_KEY_ADDRESS VALUES(11,11,'STREET 11',1)
INSERT INTO COMP_KEY_ADDRESS VALUES(12,12,'STREET 12',1)
INSERT INTO COMP_KEY_ADDRESS VALUES(13,13,'STREET 13',1)
INSERT INTO COMP_KEY_ADDRESS VALUES(14,14,'STREET 14',1)
INSERT INTO COMP_KEY_EMPLOYEE VALUES(1,1,7369,'SMITH',13,13,'1980-12-17',800,2,2,1,1,1)
INSERT INTO COMP_KEY_EMPLOYEE VALUES(2,2,7499,'ALLEN',6,6,'1981-02-20',1600,3,3,2,2,1)
INSERT INTO COMP_KEY_EMPLOYEE VALUES(3,3,7521,'WARD',6,6,'1981-02-22',1250,3,3,3,3,1)
INSERT INTO COMP_KEY_EMPLOYEE VALUES(4,4,7566,'JONES',9,9,'1981-04-02',2975,2,2,4,4,1)
INSERT INTO COMP_KEY_EMPLOYEE VALUES(5,5,7654,'MARTIN',6,6,'1981-09-28',1250,3,3,5,5,1)
INSERT INTO COMP_KEY_EMPLOYEE VALUES(6,6,7698,'BLAKE',9,9,'1981-05-01',2850,3,3,6,6,1)
INSERT INTO COMP_KEY_EMPLOYEE VALUES(7,7,7782,'CLARK',9,9,'1981-06-09',2450,1,1,7,7,1)
INSERT INTO COMP_KEY_EMPLOYEE VALUES(8,8,7788,'SCOTT',4,4,'1982-12-09',3000.0,2,2,8,8,1)
INSERT INTO COMP_KEY_EMPLOYEE VALUES(9,9,7839,'KING',NULL,NULL,'1981-11-17',5000,1,1,9,9,1)
INSERT INTO COMP_KEY_EMPLOYEE VALUES(10,10,7844,'TURNER',6,6,'1981-09-08',1500,3,3,10,10,1)
INSERT INTO COMP_KEY_EMPLOYEE VALUES(11,11,7876,'ADAMS',8,8,'1983-01-12',1100,2,2,11,11,1)
INSERT INTO COMP_KEY_EMPLOYEE VALUES(12,12,7900,'JAMES',6,6,'1981-12-03',950,3,3,12,12,1)
INSERT INTO COMP_KEY_EMPLOYEE VALUES(13,13,7902,'FORD',4,4,'1981-12-03',3000,2,2,13,13,1)
INSERT INTO COMP_KEY_EMPLOYEE VALUES(14,14,7934,'MILLER',7,7,'1982-01-23',1300,1,1,14,14,1)
INSERT INTO TENSE VALUES(1,'2005-02-14','12:11:10','2005-02-14 12:11:10.0','2005-02-14','12:11:10','2005-02-14 12:11:10.0','2005-02-14','12:11:10','2005-02-14 12:11:10.0')
INSERT INTO JOB VALUES(1,'SALESMAN')
INSERT INTO JOB VALUES(2,'MANAGER')
INSERT INTO JOB VALUES(3,'PRESIDENT')
INSERT INTO AUTHORITY VALUES(1,10)
INSERT INTO AUTHORITY VALUES(2,20)
INSERT INTO AUTHORITY VALUES(3,30)
INSERT INTO NO_ID VALUES(1,1)
INSERT INTO NO_ID VALUES(1,1)
INSERT INTO ID_GENERATOR VALUES('TABLE_STRATEGY_ID',1)
INSERT INTO MY_ID_GENERATOR VALUES('TableStrategy2',1)