9 lines
309 B
SQL
9 lines
309 B
SQL
CREATE TABLE known_episodes (
|
|
series_id TEXT NOT NULL REFERENCES subscriptions(series_id) ON DELETE CASCADE,
|
|
episode_id TEXT NOT NULL,
|
|
first_seen_at TIMESTAMPTZ NOT NULL DEFAULT now(),
|
|
PRIMARY KEY (series_id, episode_id)
|
|
);
|
|
|
|
CREATE INDEX download_jobs_series_idx ON download_jobs (series_id);
|