CREATE TABLE device_info (
    id INT AUTO_INCREMENT PRIMARY KEY,
    user_agent VARCHAR(255) NOT NULL,
    browser_name VARCHAR(50) NOT NULL,
    browser_version VARCHAR(50) NOT NULL,
    browser_major_version INT NOT NULL,
    os_name VARCHAR(50) NOT NULL,
    os_version VARCHAR(50) NOT NULL,
    engine_name VARCHAR(50) NOT NULL,
    engine_version VARCHAR(50) NOT NULL,
    cpu_architecture VARCHAR(50) NOT NULL,
    device_model VARCHAR(50) NOT NULL,
    device_type VARCHAR(50) NOT NULL,
    device_vendor VARCHAR(50) NOT NULL
);