streams

10,538 rows

This data as json, CSV (advanced)

Suggested facets: kind, addedAt (date), updatedAt (date)

Next page

CREATE TABLE streams (
  id         INTEGER PRIMARY KEY,
  v_uid      TEXT NOT NULL REFERENCES videos(uid) ON DELETE CASCADE,
  source     TEXT NOT NULL,
  sourceUrl  TEXT,
  embedUrl   TEXT,
  proxyUrl   TEXT,
  directLink TEXT,
  kind       TEXT NOT NULL DEFAULT 'embed'
               CHECK (kind IN ('embed', 'm3u8', 'mp4', 'webm', 'ts')),
  addedAt    TEXT NOT NULL DEFAULT (datetime('now')),
  updatedAt  TEXT NOT NULL DEFAULT (datetime('now')),

  dedupe TEXT GENERATED ALWAYS AS (
    source || char(10) || coalesce(embedUrl, proxyUrl, directLink, sourceUrl, '')
  ) STORED,
  UNIQUE (v_uid, dedupe)
);
CREATE INDEX idx_streams_video  ON streams(v_uid);
CREATE INDEX idx_streams_source ON streams(source);