Something went wrong. Try again.
An entry for the streamplace vod showcase
Something went wrong. Try again.
609 B · 20 lines
SQL
at main
123456789101112131415161718192021-- 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);