CREATE TABLE products (
    id INT AUTO_INCREMENT PRIMARY KEY,
    digikey_part_number VARCHAR(100) UNIQUE,
    manufacturer VARCHAR(255),
    product_name VARCHAR(255),
    description TEXT,
    image_url VARCHAR(500),
    stock INT,
    created_at DATETIME DEFAULT CURRENT_TIMESTAMP
);