Skip to content

armgit / peach

Public Imported from GitHub
0

Peach: Local-first video metadata scraper and media manager.

469 B
Raw Blame
CREATE TABLE IF NOT EXISTS asset_quality_goal(
  profile_id TEXT NOT NULL REFERENCES profile(id) ON DELETE CASCADE,
  asset_id INTEGER NOT NULL REFERENCES asset(id) ON DELETE CASCADE,
  wanted INTEGER NOT NULL DEFAULT 1 CHECK(wanted IN (0,1)),
  reason TEXT NOT NULL DEFAULT '',
  updated_at TEXT NOT NULL,
  PRIMARY KEY(profile_id,asset_id)
);

CREATE INDEX IF NOT EXISTS idx_asset_quality_goal_profile_wanted
ON asset_quality_goal(profile_id,wanted,updated_at DESC);