CREATE TABLE version ( version INTEGER NOT NULL DEFAULT 0, dirty BOOL NOT NULL DEFAULT false, _only_row BOOL NOT NULL UNIQUE CHECK(_only_row) DEFAULT true ); INSERT INTO version (version, dirty) VALUES (0, false); CREATE TABLE analytics( back_half_id INTEGER NOT NULL, start TIMESTAMP NOT NULL, netmask TEXT NOT NULL, ua_id INTEGER NOT NULL REFERENCES ua(id), count INTEGER NOT NULL DEFAULT 0, UNIQUE(back_half_id, start, netmask, ua_id) ); CREATE TABLE ua( id INTEGER PRIMARY KEY, name TEXT NOT NULL, UNIQUE(name) ); UPDATE version SET version=1, dirty=false; -- DOWN: -- DROP TABLE IF EXISTS analytics; -- DROP TABLE IF EXISTS ua; -- DROP TABLE IF EXISTS version;