-- Run this once in phpMyAdmin (select the database, then SQL tab).
-- Needed for the "سرورها" section — stores multiple panel connections (PasarGuard, Marzban, Sanaei, X-UI).
CREATE TABLE IF NOT EXISTS servers (
    id         INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    type       VARCHAR(20) NOT NULL,
    name       VARCHAR(100) NOT NULL,
    base_url   VARCHAR(255) NOT NULL,
    username   VARCHAR(100) NULL,
    password   VARCHAR(255) NULL,
    enabled    TINYINT(1) NOT NULL DEFAULT 1,
    created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;