CREATE TABLE IF NOT EXISTS segments (
  idx INTEGER PRIMARY KEY,
  name TEXT NOT NULL,
  size_bytes INTEGER NOT NULL,
  checksum TEXT NOT NULL,
  event_count INTEGER NOT NULL,
  block_count INTEGER NOT NULL,
  min_seq INTEGER NOT NULL,
  max_seq INTEGER NOT NULL,
  min_witnessed_at INTEGER NOT NULL,
  max_witnessed_at INTEGER NOT NULL,
  ingested_at INTEGER NOT NULL
);

CREATE TABLE IF NOT EXISTS segment_collections (
  idx INTEGER NOT NULL REFERENCES segments(idx),
  nsid TEXT NOT NULL,
  ns TEXT NOT NULL,
  count INTEGER NOT NULL,
  PRIMARY KEY (idx, nsid)
);

CREATE INDEX IF NOT EXISTS segment_collections_nsid ON segment_collections (nsid, idx);
CREATE INDEX IF NOT EXISTS segment_collections_ns ON segment_collections (ns, idx);

CREATE TABLE IF NOT EXISTS meta (
  key TEXT PRIMARY KEY,
  value INTEGER NOT NULL,
  updated_at INTEGER NOT NULL
);