Files
simply-dvb/migrations/0004_sessions_history.sql
Mateusz Gruszczyński 528017b0e6
build / test (push) Waiting to run
v0.1.10
2026-11-16 22:48:34 +01:00

19 lines
804 B
SQL

-- Device details of panel sessions (Profile → Signed-in devices).
ALTER TABLE sessions ADD COLUMN user_agent TEXT NOT NULL DEFAULT '';
ALTER TABLE sessions ADD COLUMN last_seen INTEGER NOT NULL DEFAULT 0;
-- Finished viewing sessions (statistics: most watched channels, who watched how long).
CREATE TABLE IF NOT EXISTS watch_history (
id INTEGER PRIMARY KEY AUTOINCREMENT,
channel_id INTEGER,
channel_name TEXT NOT NULL,
kind TEXT NOT NULL,
who TEXT NOT NULL DEFAULT '',
ip TEXT NOT NULL DEFAULT '',
device TEXT NOT NULL DEFAULT '',
started INTEGER NOT NULL,
ended INTEGER NOT NULL,
bytes INTEGER NOT NULL DEFAULT 0
);
CREATE INDEX IF NOT EXISTS watch_history_started ON watch_history(started);