BEGIN TRANSACTION;
CREATE TABLE events (category TEXT, id INTEGER PRIMARY KEY, ts NUMERIC, value NUMERIC);
CREATE UNIQUE INDEX pk_id ON events(id ASC);
COMMIT;