Sebastiaan de Schaetzen
a27ca2c828
All checks were successful
Build / build (push) Successful in 1m55s
17 lines
727 B
SQL
17 lines
727 B
SQL
CREATE TABLE IF NOT EXISTS videos (
|
|
id INTEGER PRIMARY KEY AUTOINCREMENT,
|
|
title TEXT,
|
|
url TEXT NOT NULL UNIQUE,
|
|
inserted_on TEXT DEFAULT CURRENT_TIMESTAMP,
|
|
upload_date TEXT,
|
|
cast TEXT,
|
|
description TEXT,
|
|
year INTEGER,
|
|
episode INTEGER,
|
|
run INTEGER,
|
|
state TEXT NOT NULL DEFAULT 'pending',
|
|
thumbnail TEXT
|
|
);
|
|
|
|
INSERT INTO videos (url, run, thumbnail) values ('/supporters/videos/81886', 0, 'https://imgproxy.fourthwall.com/ymbpbC7b9fO7tWlsg3e8sEdv8b3TuqXDGjr5FNM-uIg/rs:fill:607:342:0/sm:1/enc/N2U3ODcwN2I3Y2Iw/ZTZlYgoXdyrvsfaC/wje2R4f5TYcCwB4Y/ilNrHvoVDCjpBH8z/xnY0ho0FU6HlR9bX/Pk1pfFXOIFCqKnm6/2SKEU7hk5GgZTVXP/vDclApaRvgHzNXsF/pT8enEz076L7hSD-/0rENKD99989AC33R/5ZkKjg1ZZSc.webp');
|