gitfor/platform

-- platform: squashed from 1800_artifacts_health.sql.

CREATE TABLE artifacts_call_stats (
  hour INTEGER NOT NULL,
  operation TEXT NOT NULL,
  calls INTEGER NOT NULL DEFAULT 0,
  failures INTEGER NOT NULL DEFAULT 0,
  PRIMARY KEY (hour, operation)
);

CREATE TABLE artifacts_failures (
  id TEXT PRIMARY KEY,
  operation TEXT NOT NULL,
  target TEXT NOT NULL,
  reference TEXT,
  message TEXT NOT NULL,
  attempts INTEGER NOT NULL DEFAULT 1,
  created_at INTEGER NOT NULL
);

CREATE INDEX artifacts_failures_created ON artifacts_failures (created_at DESC);

CREATE INDEX artifacts_failures_operation ON artifacts_failures (operation, created_at DESC);