-- Streamhut AppView Schema (SQLite/Turso)
-- This is auto-created by calling the /init endpoint

CREATE TABLE IF NOT EXISTS creators (
  did TEXT PRIMARY KEY,
  added_at TEXT DEFAULT (datetime('now')),
  last_synced_at TEXT
);

CREATE TABLE IF NOT EXISTS videos (
  uri TEXT PRIMARY KEY,
  creator_did TEXT NOT NULL,
  title TEXT NOT NULL,
  duration INTEGER NOT NULL,  -- nanoseconds
  created_at TEXT NOT NULL,
  indexed_at TEXT DEFAULT (datetime('now'))
);

CREATE INDEX IF NOT EXISTS idx_videos_creator ON videos(creator_did);
CREATE INDEX IF NOT EXISTS idx_videos_created_at ON videos(created_at DESC);