TFMS IPTV Panel v3.0.0

CREATE TABLE admins (
    username TEXT PRIMARY KEY, 
    password TEXT
);

CREATE TABLE users (
    id INTEGER PRIMARY KEY AUTOINCREMENT, 
    username TEXT UNIQUE, 
    password TEXT, 
    status TEXT DEFAULT 'active', 
    max_connections INTEGER DEFAULT 1, 
    exp_date TEXT
);

CREATE TABLE streams (
    id INTEGER PRIMARY KEY AUTOINCREMENT, 
    name TEXT, 
    url TEXT, 
    category TEXT, 
    type TEXT DEFAULT 'live'
);

CREATE TABLE connections (
    id INTEGER PRIMARY KEY AUTOINCREMENT, 
    username TEXT, 
    device_ip TEXT, 
    stream_id INTEGER, 
    last_active TEXT
);

INSERT INTO admins (username, password) 
VALUES ('admin', 'admin123');

CREATE TABLE IF NOT EXISTS connections (
    username TEXT, 
    device_ip TEXT, 
    last_active INTEGER
);

CREATE INDEX IF NOT EXISTS idx_conn 
ON connections(username, last_active);