"""Create the track log."""
CREATE_TRACK_RESPONSE_LOG = """
    CREATE TABLE IF NOT EXISTS
        {database}.INGESTION_TRACK_LOG
        (
            id INT AUTO_INCREMENT PRIMARY KEY,
            session_id VARCHAR(255),
            request_num INT,
            time_received DATETIME,
            orchard_vendor_id INT,
            product_code VARCHAR(255),
            project_code VARCHAR(255),
            track_num INT,
            vol_num INT,
            errors VARCHAR(255)
        );
"""
# flake8: noqa