Permalink
Switch branches/tags
Nothing to show
Find file Copy path
Fetching contributors…
Cannot retrieve contributors at this time
57 lines (56 sloc) 2.38 KB
SET DATABASE UNIQUE NAME HSQLDB2FA7144891
SET DATABASE GC 0
SET DATABASE DEFAULT RESULT MEMORY ROWS 0
SET DATABASE EVENT LOG LEVEL 0
SET DATABASE SQL REFERENCES FALSE
SET DATABASE SQL SIZE TRUE
SET DATABASE SQL NAMES FALSE
SET DATABASE TRANSACTION CONTROL LOCKS
SET DATABASE DEFAULT ISOLATION LEVEL READ COMMITTED
SET FILES WRITE DELAY 500 MILLIS
SET FILES BACKUP INCREMENT TRUE
SET FILES CACHE SIZE 10000
SET FILES CACHE ROWS 50000
SET FILES SCALE 8
SET FILES LOB SCALE 32
SET FILES DEFRAG 20
SET FILES NIO TRUE
SET FILES LOG TRUE
SET FILES LOG SIZE 50
SET DATABASE TEXT TABLE DEFAULTS ''
CREATE USER SA PASSWORD ''
CREATE SCHEMA PUBLIC AUTHORIZATION DBA
SET SCHEMA PUBLIC
CREATE MEMORY TABLE PUBLIC.ELEMENTS(ID INTEGER PRIMARY KEY,NAME VARCHAR(40) NOT NULL,IS_BASIC BIT(1) NOT NULL)
CREATE MEMORY TABLE PUBLIC.COMBINATIONS(FIRST INTEGER NOT NULL,SECOND INTEGER NOT NULL,RESULT INTEGER NOT NULL,PRIMARY KEY(FIRST,SECOND),FOREIGN KEY(FIRST) REFERENCES PUBLIC.ELEMENTS(ID),FOREIGN KEY(SECOND) REFERENCES PUBLIC.ELEMENTS(ID),FOREIGN KEY(RESULT) REFERENCES PUBLIC.ELEMENTS(ID))
ALTER SEQUENCE SYSTEM_LOBS.LOB_ID RESTART WITH 1
SET DATABASE DEFAULT INITIAL SCHEMA 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 USAGE ON DOMAIN INFORMATION_SCHEMA.SQL_IDENTIFIER TO PUBLIC
GRANT DBA TO SA
SET SCHEMA SYSTEM_LOBS
INSERT INTO BLOCKS VALUES(0,2147483647,0)
SET SCHEMA PUBLIC
INSERT INTO ELEMENTS VALUES(1,'air','1')
INSERT INTO ELEMENTS VALUES(2,'fire','1')
INSERT INTO ELEMENTS VALUES(3,'water','1')
INSERT INTO ELEMENTS VALUES(4,'earth','1')
INSERT INTO ELEMENTS VALUES(5,'energy','0')
INSERT INTO ELEMENTS VALUES(6,'steam','0')
INSERT INTO ELEMENTS VALUES(7,'dust','0')
INSERT INTO ELEMENTS VALUES(8,'alcohol','0')
INSERT INTO ELEMENTS VALUES(9,'lava','0')
INSERT INTO ELEMENTS VALUES(10,'swamp','0')
INSERT INTO ELEMENTS VALUES(11,'JavaMagazine','1')
INSERT INTO ELEMENTS VALUES(12,'VXCompany','1')
INSERT INTO ELEMENTS VALUES(13,'Alchemy','0')
INSERT INTO COMBINATIONS VALUES(1,2,5)
INSERT INTO COMBINATIONS VALUES(1,3,6)
INSERT INTO COMBINATIONS VALUES(1,4,7)
INSERT INTO COMBINATIONS VALUES(2,3,8)
INSERT INTO COMBINATIONS VALUES(2,4,9)
INSERT INTO COMBINATIONS VALUES(3,4,10)
INSERT INTO COMBINATIONS VALUES(11,12,13)