-- sample database shema for PostgreSQL

CREATE TABLE tickets (
    ticket_hash VARCHAR(32) NOT NULL,
		ts INT NOT NULL,
		PRIMARY KEY (ticket_hash)
);

GRANT ALL ON tickets TO PUBLIC;
GRANT ALL ON myusers TO PUBLIC;
GRANT ALL ON ticket_secrets TO PUBLIC;
GRANT ALL ON ticket_secrets_sec_version_seq TO PUBLIC;
