Source identity
| Field | Recorded value |
|---|---|
| Source type | GitHub source |
| Original record | Janady13/AI_Brain_Control / scripts/init_db.sh |
| Date | Not specified in source |
| Repository | Janady13/AI_Brain_Control |
| Revision | 38c95c6b67d12a7096301e2eaa2892c027e411d7 |
| Branch | main |
| Path or archive member | scripts/init_db.sh |
| Original SHA-256 | 75cd4de1595ed5e6f4b989a3ab08dbcefe4ff3cd21382ee8e845197e8c57604f |
| Git blob SHA | f2fb010a754b9f6d6cf4171eb7a9a23665411352 |
| Reading-copy SHA-256 | 75cd4de1595ed5e6f4b989a3ab08dbcefe4ff3cd21382ee8e845197e8c57604f |
Recovered source transcript
Download complete source text ↓21 lines · 0.5 KB
#!/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"