You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
51 lines
2.3 KiB
51 lines
2.3 KiB
1 year ago
|
SET DATABASE UNIQUE NAME HSQLDB85437E32F0
|
||
|
|
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 MEMORY TABLE PUBLIC.PUNISHMENTS(ID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL PRIMARY KEY,NAME VARCHAR(16),UUID VARCHAR(35),REASON VARCHAR(100),OPERATOR VARCHAR(16),PUNISHMENTTYPE VARCHAR(16),START BIGINT,END BIGINT,CALCULATION VARCHAR(50))
|
||
|
|
ALTER TABLE PUBLIC.PUNISHMENTS ALTER COLUMN ID RESTART WITH 0
|
||
|
|
CREATE MEMORY TABLE PUBLIC.PUNISHMENTHISTORY(ID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL PRIMARY KEY,NAME VARCHAR(16),UUID VARCHAR(35),REASON VARCHAR(100),OPERATOR VARCHAR(16),PUNISHMENTTYPE VARCHAR(16),START BIGINT,END BIGINT,CALCULATION VARCHAR(50))
|
||
|
|
ALTER TABLE PUBLIC.PUNISHMENTHISTORY ALTER COLUMN ID RESTART WITH 1
|
||
|
|
ALTER SEQUENCE SYSTEM_LOBS.LOB_ID RESTART WITH 1
|
||
|
|
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 PUNISHMENTHISTORY VALUES(0,'_SAN5_SkeLet0n_','_san5_skelet0n_','none','CONSOLE','KICK',1671874711197,-1,'')
|