Skip to content
TypeScript
541 B
Raw Blame
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);