CREATE TABLE IF NOT EXISTS settings ( key TEXT PRIMARY KEY, value TEXT NOT NULL ); CREATE TABLE IF NOT EXISTS users ( id INTEGER PRIMARY KEY AUTOINCREMENT, username TEXT NOT NULL UNIQUE, password_hash TEXT NOT NULL, role TEXT NOT NULL DEFAULT 'admin', created_at INTEGER NOT NULL ); CREATE TABLE IF NOT EXISTS sessions ( token_hash TEXT PRIMARY KEY, user_id INTEGER NOT NULL REFERENCES users(id) ON DELETE CASCADE, created_at INTEGER NOT NULL, expires_at INTEGER NOT NULL, ip TEXT NOT NULL DEFAULT '' ); CREATE TABLE IF NOT EXISTS adapters ( id TEXT PRIMARY KEY, enabled INTEGER NOT NULL DEFAULT 1, priority INTEGER NOT NULL DEFAULT 0 ); CREATE TABLE IF NOT EXISTS muxes ( id INTEGER PRIMARY KEY AUTOINCREMENT, delsys TEXT NOT NULL, frequency_hz INTEGER NOT NULL UNIQUE, bandwidth_hz INTEGER NOT NULL DEFAULT 8000000, plp_id INTEGER, onid INTEGER, ts_id INTEGER, network_name TEXT NOT NULL DEFAULT '', enabled INTEGER NOT NULL DEFAULT 1, last_scan INTEGER, last_epg INTEGER ); CREATE TABLE IF NOT EXISTS services ( id INTEGER PRIMARY KEY AUTOINCREMENT, mux_id INTEGER NOT NULL REFERENCES muxes(id) ON DELETE CASCADE, sid INTEGER NOT NULL, name TEXT NOT NULL, provider TEXT NOT NULL DEFAULT '', service_type INTEGER NOT NULL DEFAULT 0, kind TEXT NOT NULL DEFAULT 'tv', lcn INTEGER, pmt_pid INTEGER NOT NULL, pcr_pid INTEGER NOT NULL DEFAULT 8191, streams TEXT NOT NULL DEFAULT '[]', scrambled INTEGER NOT NULL DEFAULT 0, last_seen INTEGER NOT NULL, UNIQUE (mux_id, sid) ); CREATE TABLE IF NOT EXISTS channels ( id INTEGER PRIMARY KEY AUTOINCREMENT, number INTEGER NOT NULL, name TEXT NOT NULL, service_id INTEGER REFERENCES services(id) ON DELETE SET NULL, enabled INTEGER NOT NULL DEFAULT 1, grp TEXT NOT NULL DEFAULT '', icon TEXT NOT NULL DEFAULT '', epg_id TEXT NOT NULL DEFAULT '', share_token TEXT UNIQUE, share_enabled INTEGER NOT NULL DEFAULT 0, created_at INTEGER NOT NULL ); CREATE INDEX IF NOT EXISTS channels_number ON channels(number); CREATE TABLE IF NOT EXISTS epg_events ( id INTEGER PRIMARY KEY AUTOINCREMENT, channel_id INTEGER NOT NULL REFERENCES channels(id) ON DELETE CASCADE, start INTEGER NOT NULL, stop INTEGER NOT NULL, title TEXT NOT NULL, summary TEXT NOT NULL DEFAULT '', description TEXT NOT NULL DEFAULT '', genre TEXT NOT NULL DEFAULT '', rating INTEGER, source TEXT NOT NULL DEFAULT 'ota', UNIQUE (channel_id, start) ); CREATE INDEX IF NOT EXISTS epg_channel_stop ON epg_events(channel_id, stop); CREATE INDEX IF NOT EXISTS epg_stop ON epg_events(stop); CREATE TABLE IF NOT EXISTS recordings ( id INTEGER PRIMARY KEY AUTOINCREMENT, channel_id INTEGER REFERENCES channels(id) ON DELETE SET NULL, channel_name TEXT NOT NULL DEFAULT '', title TEXT NOT NULL, description TEXT NOT NULL DEFAULT '', start INTEGER NOT NULL, stop INTEGER NOT NULL, pre_padding INTEGER NOT NULL DEFAULT 0, post_padding INTEGER NOT NULL DEFAULT 0, status TEXT NOT NULL DEFAULT 'scheduled', error TEXT NOT NULL DEFAULT '', file TEXT NOT NULL DEFAULT '', size INTEGER NOT NULL DEFAULT 0, duration REAL NOT NULL DEFAULT 0, created_at INTEGER NOT NULL ); CREATE INDEX IF NOT EXISTS recordings_status ON recordings(status, start); CREATE TABLE IF NOT EXISTS access_tokens ( id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT NOT NULL, token TEXT NOT NULL UNIQUE, allow_cidrs TEXT NOT NULL DEFAULT '', enabled INTEGER NOT NULL DEFAULT 1, created_at INTEGER NOT NULL, last_used INTEGER );