-- example schema and sample data for a mysql database backend
CREATE TABLE tickets (
    ticket_hash VARCHAR(32) NOT NULL,
		ts INT NOT NULL,
		PRIMARY KEY (ticket_hash)
);

CREATE TABLE myusers (
    usename VARCHAR(8) NOT NULL,
		passwd  VARCHAR(8) NOT NULL,
		PRIMARY KEY (usename)
);

CREATE TABLE ticket_secrets (
    sec_version INT AUTO_INCREMENT PRIMARY KEY,
		sec_data TEXT
);

INSERT INTO ticket_secrets (sec_data)
VALUES ('mvkj39vek@#$R*njdea9@#');

INSERT INTO myusers (usename, passwd)
VALUES ('testuser', 'testpass');