#!/bin/bash
set -euo pipefail
DB="$1"
sqlite3 "$DB" <<SQL
PRAGMA journal_mode=WAL;
PRAGMA busy_timeout=5000;
CREATE TABLE IF NOT EXISTS shards (
  id INTEGER PRIMARY KEY,
  file TEXT NOT NULL,
  size_bytes INTEGER NOT NULL,
  hash TEXT NOT NULL,
  started_at TEXT NOT NULL,
  completed_at TEXT NOT NULL,
  profile TEXT NOT NULL,
  compressor TEXT NOT NULL,
  throughput_mb_s REAL NOT NULL
);
CREATE INDEX IF NOT EXISTS idx_shards_completed_at ON shards(completed_at);
SQL
echo "DB ready: $DB"