CREATE TABLE IF NOT EXISTS `sold_consoles` (
    `id` INT AUTO_INCREMENT PRIMARY KEY,
    `console_id` INT NOT NULL,
    `email` VARCHAR(255) NOT NULL,
    `rdp_ip` VARCHAR(50),
    `browser_name` VARCHAR(100),
    `snapshot_json` LONGTEXT NOT NULL,
    `admin_id` INT NOT NULL,
    `sold_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    FOREIGN KEY (`admin_id`) REFERENCES `admins`(`id`)
);