mirror of
https://github.com/hanzoai/dev-desktop.git
synced 2026-11-22 00:14:30 +00:00
17 lines
541 B
SQL
17 lines
541 B
SQL
CREATE TABLE receipts (id TEXT PRIMARY KEY, recorded_at INTEGER NOT NULL) WITHOUT ROWID;
|
|
CREATE TABLE savings (
|
|
developer TEXT NOT NULL,
|
|
host TEXT NOT NULL,
|
|
platform TEXT NOT NULL,
|
|
arch TEXT NOT NULL,
|
|
ci INTEGER NOT NULL,
|
|
local_ms INTEGER NOT NULL,
|
|
remote_ms INTEGER NOT NULL,
|
|
local_hits INTEGER NOT NULL,
|
|
remote_hits INTEGER NOT NULL,
|
|
executed INTEGER NOT NULL,
|
|
restore_failures INTEGER NOT NULL,
|
|
PRIMARY KEY (developer, host, platform, arch, ci)
|
|
) WITHOUT ROWID;
|
|
CREATE INDEX receipts_age ON receipts(recorded_at);
|