CREATE SEQUENCE MYSEQ AS INTEGER START WITH 49 
CREATE TABLE EMP(EMPNO NUMERIC(4) NOT NULL PRIMARY KEY,ENAME VARCHAR(10),JOB VARCHAR(9),MGR NUMERIC(4),HIREDATE DATE,SAL NUMERIC(7,2),COMM NUMERIC(7,2),DEPTNO NUMERIC(2),TSTAMP TIMESTAMP)
CREATE VIEW EMP_VIEW (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO,TSTAMP) AS SELECT EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO,TSTAMP FROM EMP;

CREATE TABLE DEPT(DEPTNO NUMERIC(2) NOT NULL PRIMARY KEY,DNAME VARCHAR(14),LOC VARCHAR(13),VERSIONNO NUMERIC(8),ACTIVE NUMERIC(1))
CREATE TABLE EMP2(EMPNO NUMERIC(4) NOT NULL PRIMARY KEY,ENAME VARCHAR(10),DEPTNUM NUMERIC(2))
CREATE TABLE DEPT2(DEPTNO NUMERIC(2) NOT NULL PRIMARY KEY,DNAME VARCHAR(14),ACTIVE NUMERIC(1))
CREATE TABLE IDENTITYTABLE(ID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0)  NOT NULL PRIMARY KEY,ID_NAME VARCHAR(20))
CREATE TABLE DUAL(DUMMY VARCHAR(1))
CREATE TABLE CHAR_TABLE(ID INTEGER NOT NULL PRIMARY KEY,AAA CHAR(1))
CREATE TABLE EMP3(EMPLOYEE_ID INTEGER NOT NULL PRIMARY KEY,EMPLOYEE_NAME VARCHAR(10),DEPARTMENT_ID INTEGER)
CREATE TABLE SEQTABLE(ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(20))
CREATE TABLE NO_PK_TABLE(AAA VARCHAR(10),BBB INTEGER)
CREATE TABLE PKONLYTABLE(AAA VARCHAR(10) NOT NULL PRIMARY KEY)
CREATE TABLE DEPT4(DEPTNO NUMERIC(2) NOT NULL PRIMARY KEY,DNAME VARCHAR(14),LOC VARCHAR(13),VERSIONNO NUMERIC(8),ACTIVE NUMERIC(1))
CREATE TABLE EMP4(EMPNO NUMERIC(4) NOT NULL PRIMARY KEY,ENAME VARCHAR(10),JOB VARCHAR(9),MGR NUMERIC(4),HIREDATE DATE,SAL NUMERIC(7,2),COMM NUMERIC(7,2),DEPTNO NUMERIC(2) NOT NULL,TSTAMP TIMESTAMP,CONSTRAINT SYS_FK_1 FOREIGN KEY(DEPTNO) REFERENCES DEPT4(DEPTNO))
CREATE TABLE BIN$EMP4(EMPNO NUMERIC(4) NOT NULL PRIMARY KEY,ENAME VARCHAR(10),JOB VARCHAR(9),MGR NUMERIC(4),HIREDATE DATE,SAL NUMERIC(7,2),COMM NUMERIC(7,2),DEPTNO NUMERIC(2) NOT NULL,TSTAMP TIMESTAMP,CONSTRAINT SYS_FK_2 FOREIGN KEY(DEPTNO) REFERENCES DEPT4(DEPTNO))

CREATE USER SA PASSWORD "" ADMIN
SET WRITE_DELAY 60
INSERT INTO EMP VALUES(7369,'SMITH','CLERK',7902,'1980-12-17',800,NULL,20,'2000-01-01 00:00:00.0')
INSERT INTO EMP VALUES(7499,'ALLEN','SALESMAN',7698,'1981-02-20',1600,300,30,'2000-01-01 00:00:00.0')
INSERT INTO EMP VALUES(7521,'WARD','SALESMAN',7698,'1981-02-22',1250,500,30,'2000-01-01 00:00:00.0')
INSERT INTO EMP VALUES(7566,'JONES','MANAGER',7839,'1981-04-02',2975,NULL,20,'2000-01-01 00:00:00.0')
INSERT INTO EMP VALUES(7654,'MARTIN','SALESMAN',7698,'1981-09-28',1250,1400,30,'2000-01-01 00:00:00.0')
INSERT INTO EMP VALUES(7698,'BLAKE','MANAGER',7839,'1981-05-01',2850,NULL,30,'2000-01-01 00:00:00.0')
INSERT INTO EMP VALUES(7782,'CLARK','MANAGER',7839,'1981-06-09',2450,NULL,10,'2000-01-01 00:00:00.0')
INSERT INTO EMP VALUES(7788,'SCOTT','ANALYST',7566,'1982-12-09',3000.0,NULL,20,'2005-01-18 13:09:32.213')
INSERT INTO EMP VALUES(7839,'KING','PRESIDENT',NULL,'1981-11-17',5000,NULL,10,'2000-01-01 00:00:00.0')
INSERT INTO EMP VALUES(7844,'TURNER','SALESMAN',7698,'1981-09-08',1500,0,30,'2000-01-01 00:00:00.0')
INSERT INTO EMP VALUES(7876,'ADAMS','CLERK',7788,'1983-01-12',1100,NULL,20,'2000-01-01 00:00:00.0')
INSERT INTO EMP VALUES(7900,'JAMES','CLERK',7698,'1981-12-03',950,NULL,30,'2000-01-01 00:00:00.0')
INSERT INTO EMP VALUES(7902,'FORD','ANALYST',7566,'1981-12-03',3000,NULL,20,'2000-01-01 00:00:00.0')
INSERT INTO EMP VALUES(7934,'MILLER','CLERK',7782,'1982-01-23',1300,NULL,10,'2000-01-01 00:00:00.0')
INSERT INTO DEPT VALUES(10,'ACCOUNTING','NEW YORK',0,1)
INSERT INTO DEPT VALUES(20,'RESEARCH','DALLAS',0,1)
INSERT INTO DEPT VALUES(30,'SALES','CHICAGO',0,1)
INSERT INTO DEPT VALUES(40,'OPERATIONS','BOSTON',0,1)
INSERT INTO EMP2 VALUES(7369,'SMITH',20)
INSERT INTO EMP2 VALUES(7499,'ALLEN',30)
INSERT INTO DEPT2 VALUES(20,'RESEARCH',1)
INSERT INTO DEPT2 VALUES(30,'SALES',0)
INSERT INTO DUAL VALUES('X')