CREATE TABLE IF NOT EXISTS `login_attempts` (
    `id` INT AUTO_INCREMENT PRIMARY KEY,
    `ip_address` VARCHAR(45),
    `attempt_time` DATETIME,
    `status` VARCHAR(20)
);

CREATE TABLE IF NOT EXISTS `panels` (
    `id` INT AUTO_INCREMENT PRIMARY KEY,
    `panel_numeric_id` BIGINT UNIQUE NOT NULL,
    `panel_name` VARCHAR(100) UNIQUE NOT NULL,
    `panel_username` VARCHAR(100) UNIQUE NOT NULL,
    `panel_token` VARCHAR(255) UNIQUE NOT NULL,
    `dp_path` VARCHAR(255),
    `status` ENUM('online','offline') DEFAULT 'offline',
    `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

CREATE TABLE IF NOT EXISTS `admin_auth` (
    `id` INT AUTO_INCREMENT PRIMARY KEY,
    `password_hash` VARCHAR(255) NOT NULL
);

-- Default password is: admin123
INSERT INTO `admin_auth` (`password_hash`) VALUES ('$argon2id$v=19$m=65536,t=4,p=1$c2FsdHN0cmluZ2dlbmVyYXRl$uUvP+/U2E8+m+H8rM08l1a05/Z6+h0YxG7XoY');