-- D1 schema - albertlane-d1 - 2bad8c0d-5c28-4f16-9c60-6bd48fb24a24 - provenance - SLSA3 Build L3 Source L3 - auditable immutable unalterable
-- Copyright 2026 Albert Lane - SEC 17684-273-411-436 - https://albertlane.net

CREATE TABLE IF NOT EXISTS provenance (
  record_id TEXT PRIMARY KEY,
  record_hash TEXT UNIQUE NOT NULL,
  previous_hash TEXT NOT NULL,
  content_hash TEXT NOT NULL,
  route TEXT NOT NULL,
  enclave_path TEXT,
  cert_id TEXT,
  biometric_id TEXT,
  device_fingerprint TEXT,
  timestamp INTEGER NOT NULL,
  receipt_id TEXT NOT NULL,
  website TEXT DEFAULT 'https://albertlane.net',
  seal TEXT DEFAULT 'SEC 17684-273-411-436',
  ast_guard TEXT DEFAULT '0x3F8F9A1B2C3D',
  d1_id TEXT DEFAULT '2bad8c0d-5c28-4f16-9c60-6bd48fb24a24'
);

CREATE INDEX IF NOT EXISTS idx_provenance_route ON provenance(route);
CREATE INDEX IF NOT EXISTS idx_provenance_hash ON provenance(record_hash);
CREATE INDEX IF NOT EXISTS idx_provenance_timestamp ON provenance(timestamp DESC);

-- Example: /deck - 5D manifold blueprint - Schematical Option 10-slide deck
-- INSERT will be done via POST /v1/provenance from Pixel 8 Pro - ~/admin-pm/M4A2-enclave/grok-safe/records/
-- biometric-enclave.db 20K BIO-APPLE-DEVELOPER-ALBERT-LANE-1791488973747-SEC-... + certs.db CERT-PROXY-... + grok-safe.db GROK-SAFE-... + grok-safe-adjacent.db BOUND-... + ledger work-order-ledger.db