text: DROP TABLE BINARY_TABLE;
  DROP TABLE DEPT;
  DROP TABLE EMP;
  DROP TABLE TWO_PK_TABLE;
  DROP VIEW  EMP_VIEW;
  
  CREATE TABLE BINARY_TABLE (
        ID  INTEGER NOT NULL PRIMARY KEY
      , BIN VARBINARY(2048));
  
  CREATE TABLE DEPT
         (DEPTNO INTEGER NOT NULL PRIMARY KEY,
          DNAME TEXT,
          LOC TEXT,
          VERSIONNO INTEGER);
  
  CREATE TABLE EMP
         (EMPNO INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT,
          ENAME TEXT,
          JOB TEXT,
          MGR INTEGER,
          HIREDATE TIMESTAMP(4),
          SAL REAL,
          COMM REAL,
          DEPTNO INTEGER,
          TSTAMP TIMESTAMP(4),
          FOREIGN KEY(DEPTNO) REFERENCES DEPT(DEPTNO)
          );
  
  INSERT INTO DEPT VALUES (10, 'ACCOUNTING', 'NEW YORK', 0);
  INSERT INTO DEPT VALUES (20, 'RESEARCH',   'DALLAS', 0);
  INSERT INTO DEPT VALUES (30, 'SALES',      'CHICAGO', 0);
  INSERT INTO DEPT VALUES (40, 'OPERATIONS', 'BOSTON', 0);
  
  INSERT INTO EMP VALUES (7369, 'SMITH',  'CLERK',     7902, '1980-12-17',  800, NULL, 20, CURRENT_TIMESTAMP());
  INSERT INTO EMP VALUES (7499, 'ALLEN',  'SALESMAN',  7698, '1981-02-20', 1600,  300, 30, CURRENT_TIMESTAMP());
  INSERT INTO EMP VALUES (7521, 'WARD',   'SALESMAN',  7698, '1981-02-22', 1250,  500, 30, CURRENT_TIMESTAMP());
  INSERT INTO EMP VALUES (7566, 'JONES',  'MANAGER',   7839, '1981-04-02',  2975, NULL, 20, CURRENT_TIMESTAMP());
  INSERT INTO EMP VALUES (7654, 'MARTIN', 'SALESMAN',  7698, '1981-09-28', 1250, 1400, 30, CURRENT_TIMESTAMP());
  INSERT INTO EMP VALUES (7698, 'BLAKE',  'MANAGER',   7839, '1981-05-01',  2850, NULL, 30, CURRENT_TIMESTAMP());
  INSERT INTO EMP VALUES (7782, 'CLARK',  'MANAGER',   7839, '1981-06-09',  2450, NULL, 10, CURRENT_TIMESTAMP());
  INSERT INTO EMP VALUES (7788, 'SCOTT',  'ANALYST',   7566, '1982-12-09', 3000, NULL, 20, CURRENT_TIMESTAMP());
  INSERT INTO EMP VALUES (7839, 'KING',   'PRESIDENT', NULL, '1981-11-17', 5000, NULL, 10, CURRENT_TIMESTAMP());
  INSERT INTO EMP VALUES (7844, 'TURNER', 'SALESMAN',  7698, '1981-09-08',  1500,    0, 30, CURRENT_TIMESTAMP());
  INSERT INTO EMP VALUES (7876, 'ADAMS',  'CLERK',     7788, '1983-01-12', 1100, NULL, 20, CURRENT_TIMESTAMP());
  INSERT INTO EMP VALUES (7900, 'JAMES',  'CLERK',     7698, '1981-12-03',   950, NULL, 30, CURRENT_TIMESTAMP());
  INSERT INTO EMP VALUES (7902, 'FORD',   'ANALYST',   7566, '1981-12-03',  3000, NULL, 20, CURRENT_TIMESTAMP());
  INSERT INTO EMP VALUES (7934, 'MILLER', 'CLERK',     7782, '1982-01-23', 1300, NULL, 10, CURRENT_TIMESTAMP());
  
  CREATE TABLE TWO_PK_TABLE
         (PK1 INTEGER NOT NULL,
          PK2 INTEGER NOT NULL,
          CONSTRAINT TWO_PK PRIMARY KEY(PK1, PK2));
  
  CREATE VIEW EMP_VIEW AS
      SELECT * FROM EMP;
  