Skip to content
Source
Sign inSign up
Open History to see the last commit

0001_savings.sql

16 lines541 Bytes

1CREATE TABLE receipts (id TEXT PRIMARY KEY, recorded_at INTEGER NOT NULL) WITHOUT ROWID;
2CREATE TABLE savings (
3 developer TEXT NOT NULL,
4 host TEXT NOT NULL,
5 platform TEXT NOT NULL,
6 arch TEXT NOT NULL,
7 ci INTEGER NOT NULL,
8 local_ms INTEGER NOT NULL,
9 remote_ms INTEGER NOT NULL,
10 local_hits INTEGER NOT NULL,
11 remote_hits INTEGER NOT NULL,
12 executed INTEGER NOT NULL,
13 restore_failures INTEGER NOT NULL,
14 PRIMARY KEY (developer, host, platform, arch, ci)
15) WITHOUT ROWID;
16CREATE INDEX receipts_age ON receipts(recorded_at);