db3.log

CREATE USER SA PASSWORD "" ADMIN
/*C1*/SET SCHEMA PUBLIC
CONNECT USER SA
SET WRITE_DELAY FALSE
SET AUTOCOMMIT FALSE
CREATE TABLE messages(nick VARCHAR(255) NOT NULL,message VARCHAR(4096) NOT NULL,timeposted BIGINT NOT NULL)
CREATE TABLE statistics(key VARCHAR(255),value INT)
INSERT INTO STATISTICS VALUES('Total messages',0)
INSERT INTO STATISTICS VALUES('Total logins',0)
COMMIT
DELETE FROM STATISTICS WHERE KEY='Total logins' AND VALUE=0
INSERT INTO STATISTICS VALUES('Total logins',1)
COMMIT
INSERT INTO MESSAGES VALUES('Anonymous37228','Foo',1417001026952)
DELETE FROM STATISTICS WHERE KEY='Total messages' AND VALUE=0
INSERT INTO STATISTICS VALUES('Total messages',1)
COMMIT
INSERT INTO MESSAGES VALUES('Anonymous37228','Yo',1417001028928)
DELETE FROM STATISTICS WHERE KEY='Total messages' AND VALUE=1
INSERT INTO STATISTICS VALUES('Total messages',2)
COMMIT
INSERT INTO MESSAGES VALUES('Anonymous37228','',1417001030520)
DELETE FROM STATISTICS WHERE KEY='Total messages' AND VALUE=2
INSERT INTO STATISTICS VALUES('Total messages',3)
COMMIT
DELETE FROM STATISTICS WHERE KEY='Total logins' AND VALUE=1
INSERT INTO STATISTICS VALUES('Total logins',2)
COMMIT
INSERT INTO MESSAGES VALUES('Anonymous95688','Hi',1417001062318)
DELETE FROM STATISTICS WHERE KEY='Total messages' AND VALUE=3
INSERT INTO STATISTICS VALUES('Total messages',4)
COMMIT
INSERT INTO MESSAGES VALUES('SnoopDogg','Yo',1417001065811)
DELETE FROM STATISTICS WHERE KEY='Total messages' AND VALUE=4
INSERT INTO STATISTICS VALUES('Total messages',5)
COMMIT