Files
Mateusz Gruszczyński c30064b531
build / test (push) Canceled after 0s
build / deb (amd64) (push) Canceled after 0s
build / deb (arm64) (push) Canceled after 0s
build / deb (armhf) (push) Canceled after 0s
first commit
2026-11-16 16:19:21 +01:00

11 lines
352 B
SQL

CREATE TABLE IF NOT EXISTS autorec (
id INTEGER PRIMARY KEY AUTOINCREMENT,
name TEXT NOT NULL,
pattern TEXT NOT NULL,
channel_id INTEGER REFERENCES channels(id) ON DELETE CASCADE,
enabled INTEGER NOT NULL DEFAULT 1,
created_at INTEGER NOT NULL
);
ALTER TABLE recordings ADD COLUMN autorec_id INTEGER;