"""Create the template table which matches the Bulk Upload Template"""

CREATE_BULK_UPLOAD_TEMPLATE_TABLE = """

CREATE OR REPLACE TABLE {snowflake_database}.{snowflake_schema}.BULK_UPLOAD_TEMPLATE (
    ROW_NUMBER INT DEFAULT NULL,
    RELEASE_NAME VARCHAR(16777216),
    RELEASE_META_LANGUAGE VARCHAR(16777216),
    ORCHARD_ARTIST VARCHAR(16777216),
    ARTIST_COUNTRY VARCHAR(16777216),
    SUBACCOUNT_NAME VARCHAR(16777216),
    ARTIST_URL VARCHAR(16777216),
    RELEASE_ARTISTS_PRIMARY_ARTIST VARCHAR(16777216),
    RELEASE_ARTISTS_FEATURINGS VARCHAR(16777216),
    RELEASE_ARTISTS_REMIXERS VARCHAR(16777216),
    RELEASE_ARTISTS_PRODUCERS VARCHAR(16777216),
    RELEASE_ARTISTS_COMPOSERS VARCHAR(16777216),
    RELEASE_ARTISTS_ORCHESTRAS VARCHAR(16777216),
    RELEASE_ARTISTS_ENSEMBLES VARCHAR(16777216),
    RELEASE_ARTISTS_CONDUCTORS VARCHAR(16777216),
    RELEASE_DATE VARCHAR(16777216),
    SALE_START_DATE VARCHAR(16777216),
    ITUNES_PREORDER VARCHAR(16777216),
    ITUNES_PREORDER_DATE VARCHAR(16777216),
    PREORDER_PREVIEW VARCHAR(16777216),
    ALBUM_PRICING VARCHAR(16777216),
    FORMAT_FULL_LENGTH_EP_SINGLE VARCHAR(16777216),
    IMPRINT VARCHAR(16777216),
    GENRE VARCHAR(16777216),
    SUB_GENRE VARCHAR(16777216),
    C_INFORMATION VARCHAR(16777216),
    P_LINE VARCHAR(16777216),
    DIGITAL_UPC VARCHAR(16777216),
    MANUFACTURERS_UPC VARCHAR(16777216),
    FOLDER_NAME_PROJECT_CODE VARCHAR(16777216),
    PRODUCT_CODE VARCHAR(16777216),
    RELEASE_VERSION VARCHAR(16777216),
    FILE_NAME VARCHAR(16777216),
    VOLUME NUMBER(38,0),
    TRACK_NO NUMBER(38,0),
    TRACK_NAME VARCHAR(16777216),
    TRACK_AUDIO_LANGUAGE VARCHAR(16777216),
    VERSION VARCHAR(16777216),
    TRACK_ARTIST VARCHAR(16777216),
    TRACK_ARTISTS_FEATURINGS VARCHAR(16777216),
    TRACK_ARTISTS_REMIXERS VARCHAR(16777216),
    TRACK_ARTISTS_PRODUCERS VARCHAR(16777216),
    TRACK_ARTISTS_COMPOSERS VARCHAR(16777216),
    TRACK_ARTISTS_ORCHESTRAS VARCHAR(16777216),
    TRACK_ARTISTS_ENSEMBLES VARCHAR(16777216),
    TRACK_ARTISTS_CONDUCTORS VARCHAR(16777216),
    TRACK_PRICING VARCHAR(16777216),
    EXPLICIT VARCHAR(16777216),
    ISRC VARCHAR(16777216),
    THIRD_PARTY_PUBLISHER VARCHAR(16777216),
    P_INFORMATION VARCHAR(16777216),
    OWNERSHIP_FOR_THIS_SOUND_RECORDING VARCHAR(16777216),
    COUNTRY_OF_RECORDING VARCHAR(16777216),
    NATIONALITY_OF_ORIGINAL_COPYRIGHT_OWNER VARCHAR(16777216),
    TRACK_LYRICS VARCHAR(16777216),
    SONGWRITERS VARCHAR(16777216),
    PUBLISHERS VARCHAR(16777216),
    PERFORMER_1_TYPE VARCHAR(16777216),
    PERFORMER_1_LEGAL_NAME VARCHAR(16777216),
    PERFORMER_1_MAIN_ROLE VARCHAR(16777216),
    PERFORMER_2_TYPE VARCHAR(16777216),
    PERFORMER_2_LEGAL_NAME VARCHAR(16777216),
    PERFORMER_2_MAIN_ROLE VARCHAR(16777216),
    PERFORMER_3_TYPE VARCHAR(16777216),
    PERFORMER_3_LEGAL_NAME VARCHAR(16777216),
    PERFORMER_3_MAIN_ROLE VARCHAR(16777216),
    PERFORMER_4_TYPE VARCHAR(16777216),
    PERFORMER_4_LEGAL_NAME VARCHAR(16777216),
    PERFORMER_4_MAIN_ROLE VARCHAR(16777216),
    PERFORMER_5_TYPE VARCHAR(16777216),
    PERFORMER_5_LEGAL_NAME VARCHAR(16777216),
    PERFORMER_5_MAIN_ROLE VARCHAR(16777216),
    ONLY_INCLUDE_ONLY_EXCLUDE VARCHAR(16777216),
    TERRITORIES_ISO_CODES VARCHAR(16777216),
    ORCHLABELID NUMBER(38,0),
    PROGRESS VARCHAR(255) DEFAULT 'Started'
)
;
"""
# flake8: noqa