| SET DATABASE UNIQUE NAME HSQLDB7B591E7E38 |
| SET DATABASE GC 0 |
| SET DATABASE DEFAULT RESULT MEMORY ROWS 0 |
| SET DATABASE EVENT LOG LEVEL 0 |
| SET DATABASE TRANSACTION CONTROL LOCKS |
| SET DATABASE DEFAULT ISOLATION LEVEL READ COMMITTED |
| SET DATABASE TRANSACTION ROLLBACK ON CONFLICT TRUE |
| SET DATABASE TEXT TABLE DEFAULTS '' |
| SET DATABASE SQL NAMES FALSE |
| SET DATABASE SQL REFERENCES FALSE |
| SET DATABASE SQL SIZE TRUE |
| SET DATABASE SQL TYPES FALSE |
| SET DATABASE SQL TDC DELETE TRUE |
| SET DATABASE SQL TDC UPDATE TRUE |
| SET DATABASE SQL CONCAT NULLS TRUE |
| SET DATABASE SQL UNIQUE NULLS TRUE |
| SET DATABASE SQL CONVERT TRUNCATE TRUE |
| SET DATABASE SQL AVG SCALE 0 |
| SET DATABASE SQL DOUBLE NAN TRUE |
| SET FILES WRITE DELAY 500 MILLIS |
| SET FILES BACKUP INCREMENT TRUE |
| SET FILES CACHE SIZE 10000 |
| SET FILES CACHE ROWS 50000 |
| SET FILES SCALE 32 |
| SET FILES LOB SCALE 32 |
| SET FILES DEFRAG 0 |
| SET FILES NIO TRUE |
| SET FILES NIO SIZE 256 |
| SET FILES LOG TRUE |
| SET FILES LOG SIZE 50 |
| CREATE USER SA PASSWORD DIGEST 'd41d8cd98f00b204e9800998ecf8427e' |
| ALTER USER SA SET LOCAL TRUE |
| CREATE SCHEMA PUBLIC AUTHORIZATION DBA |
| SET SCHEMA PUBLIC |
| CREATE SEQUENCE PUBLIC.DEP_ID_SEQUENCE AS INTEGER START WITH 1 |
| CREATE SEQUENCE PUBLIC.EMPLOYEE_ID_SEQUENCE AS INTEGER START WITH 1 |
| CREATE MEMORY TABLE PUBLIC.DEPARTMENTS(DEPARTMENT_ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(80) NOT NULL,HEAD VARCHAR(80),BUSINESS_UNIT VARCHAR(4) NOT NULL,UPDATE_TIMESTAMP TIMESTAMP NOT NULL) |
| CREATE UNIQUE INDEX DEPARTMENT_NAME_IDX ON PUBLIC.DEPARTMENTS(NAME) |
| CREATE MEMORY TABLE PUBLIC.EMPLOYEES(EMPLOYEE_ID INTEGER NOT NULL PRIMARY KEY,SALUTATION VARCHAR(20),FIRSTNAME VARCHAR(40) NOT NULL,LASTNAME VARCHAR(40) NOT NULL,DATE_OF_BIRTH DATE,DATE_WITH_TIME TIMESTAMP,DEPARTMENT_ID INTEGER NOT NULL,GENDER VARCHAR(1),PHONE_NUMBER VARCHAR(40),EMAIL VARCHAR(80),SALARY DECIMAL(10,2),RETIRED BIT(1) NOT NULL,UPDATE_TIMESTAMP TIMESTAMP NOT NULL,CONSTRAINT EMPLOYEES_DEPARTMENT_I_FK FOREIGN KEY(DEPARTMENT_ID) REFERENCES PUBLIC.DEPARTMENTS(DEPARTMENT_ID)) |
| CREATE UNIQUE INDEX EMPLOYEE_NAME_IDX ON PUBLIC.EMPLOYEES(FIRSTNAME,LASTNAME,DATE_OF_BIRTH) |
| ALTER SEQUENCE SYSTEM_LOBS.LOB_ID RESTART WITH 1 |
| ALTER SEQUENCE PUBLIC.DEP_ID_SEQUENCE RESTART WITH 3 |
| ALTER SEQUENCE PUBLIC.EMPLOYEE_ID_SEQUENCE RESTART WITH 4 |
| SET DATABASE DEFAULT INITIAL SCHEMA PUBLIC |
| GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.SQL_IDENTIFIER TO PUBLIC |
| GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.YES_OR_NO TO PUBLIC |
| GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.TIME_STAMP TO PUBLIC |
| GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.CARDINAL_NUMBER TO PUBLIC |
| GRANT USAGE ON DOMAIN INFORMATION_SCHEMA.CHARACTER_DATA TO PUBLIC |
| GRANT DBA TO SA |
| SET SCHEMA SYSTEM_LOBS |
| INSERT INTO BLOCKS VALUES(0,2147483647,0) |
| SET SCHEMA PUBLIC |
| INSERT INTO DEPARTMENTS VALUES(1,'Development',NULL,'ITTK','2021-08-18 13:59:17.120000') |
| INSERT INTO DEPARTMENTS VALUES(2,'Sales',NULL,'ITTK','2021-08-18 13:59:17.289000') |
| INSERT INTO EMPLOYEES VALUES(1,NULL,'Peter','Sharp',NULL,NULL,1,'M','+49-7531-457160',NULL,NULL,'0','2021-08-18 13:59:18.818000') |
| INSERT INTO EMPLOYEES VALUES(2,NULL,'Fred','Bloggs',NULL,NULL,1,'M','+49-5555-505050',NULL,NULL,'0','2021-08-18 13:59:19.830000') |
| INSERT INTO EMPLOYEES VALUES(3,NULL,'Emma','White',NULL,NULL,2,'F','+49-040-125486',NULL,NULL,'0','2021-08-18 13:59:19.559000') |
