"""Query for creating the tracking table."""
CREATE_BULK_UPLOAD_TRACKING_TABLE = """
CREATE TABLE IF NOT EXISTS bulk_upload.bulk_upload_tracking (
    bulk_upload_id INT NULL AUTO_INCREMENT,
    orchard_vendor_id INT NOT NULL,
    source_table varchar(255) NOT NULL,
    source_file_name varchar(255) NOT NULL,
    output_file_names varchar(8383) NULL,
    session_id varchar(100) NOT NULL,
    environment varchar(24) DEFAULT 'dev' NULL,
    start_time DATETIME DEFAULT NOW() NULL,
    end_time DATETIME DEFAULT NOW() NULL,
    succeeded INT DEFAULT 0,
    failed INT DEFAULT 0,
    requeue_succeeded INT DEFAULT 0,
    requeue_failed INT DEFAULT 0,
    total_requests INT DEFAULT 0,
    assets_ingested INT DEFAULT 0,
    CONSTRAINT bulk_upload_tracking_PK PRIMARY KEY (bulk_upload_id)
)
ENGINE=InnoDB
DEFAULT CHARSET=utf8mb4
COLLATE=utf8mb4_general_ci;
"""