"""Query to CREATE a table for input tracking."""

create_input_log = """

create or replace TABLE {snowflake_database}.{snowflake_schema}.{table_name} (
    RELEASE_NAME VARCHAR(255),
    RELEASE_META_LANGUAGE VARCHAR(255),
    ORCHARD_ARTIST VARCHAR(255),
    ARTIST_COUNTRY VARCHAR(255),
    SUBACCOUNT_NAME VARCHAR(255),
    ARTIST_URL VARCHAR(255),
    RELEASE_ARTISTS_PRIMARY_ARTIST VARCHAR(255),
    RELEASE_ARTISTS_FEATURINGS VARCHAR(255),
    RELEASE_ARTISTS_REMIXERS VARCHAR(255),
    RELEASE_ARTISTS_PRODUCERS VARCHAR(255),
    RELEASE_ARTISTS_COMPOSERS VARCHAR(255),
    RELEASE_ARTISTS_ORCHESTRAS VARCHAR(255),
    RELEASE_ARTISTS_ENSEMBLES VARCHAR(255),
    RELEASE_ARTISTS_CONDUCTORS VARCHAR(255),
    RELEASE_DATE VARCHAR(255),
    SALE_START_DATE VARCHAR(10),
    ITUNES_PREORDER VARCHAR(12),
    ITUNES_PREORDER_DATE VARCHAR(10),
    PREORDER_PREVIEW VARCHAR(255),
    ALBUM_PRICING VARCHAR(255),
    FORMAT_FULL_LENGTH_EP_SINGLE VARCHAR(255),
    IMPRINT VARCHAR(255),
    GENRE VARCHAR(255),
    SUB_GENRE VARCHAR(255),
    C_INFORMATION VARCHAR(255),
    P_LINE VARCHAR(16777216),
    DIGITAL_UPC VARCHAR(15),
    MANUFACTURERS_UPC VARCHAR(15),
    FOLDER_NAME_PROJECT_CODE NUMBER(38,0),
    PRODUCT_CODE VARCHAR(128),
    RELEASE_VERSION VARCHAR(128),
    FILE_NAME VARCHAR(255),
    VOLUME NUMBER(38,0),
    TRACK_NO NUMBER(38,0),
    TRACK_NAME VARCHAR(255),
    TRACK_AUDIO_LANGUAGE VARCHAR(255),
    VERSION VARCHAR(255),
    TRACK_ARTIST VARCHAR(255),
    TRACK_ARTISTS_FEATURINGS VARCHAR(255),
    TRACK_ARTISTS_REMIXERS VARCHAR(255),
    TRACK_ARTISTS_PRODUCERS VARCHAR(255),
    TRACK_ARTISTS_COMPOSERS VARCHAR(255),
    TRACK_ARTISTS_ORCHESTRAS VARCHAR(255),
    TRACK_ARTISTS_ENSEMBLES VARCHAR(255),
    TRACK_ARTISTS_CONDUCTORS VARCHAR(255),
    TRACK_PRICING VARCHAR(255),
    EXPLICIT VARCHAR(10),
    ISRC VARCHAR(25),
    THIRD_PARTY_PUBLISHER VARCHAR(5),
    P_INFORMATION VARCHAR(255),
    OWNERSHIP_FOR_THIS_SOUND_RECORDING VARCHAR(255),
    COUNTRY_OF_RECORDING VARCHAR(255),
    NATIONALITY_OF_ORIGINAL_COPYRIGHT_OWNER VARCHAR(255),
    TRACK_LYRICS VARCHAR(255),
    SONGWRITERS VARCHAR(255),
    PUBLISHERS VARCHAR(255),
    PERFORMER_1_TYPE VARCHAR(255),
    PERFORMER_1_LEGAL_NAME VARCHAR(255),
    PERFORMER_1_MAIN_ROLE VARCHAR(255),
    PERFORMER_2_TYPE VARCHAR(255),
    PERFORMER_2_LEGAL_NAME VARCHAR(255),
    PERFORMER_2_MAIN_ROLE VARCHAR(255),
    PERFORMER_3_TYPE VARCHAR(255),
    PERFORMER_3_LEGAL_NAME VARCHAR(255),
    PERFORMER_3_MAIN_ROLE VARCHAR(255),
    PERFORMER_4_TYPE VARCHAR(255),
    PERFORMER_4_LEGAL_NAME VARCHAR(255),
    PERFORMER_4_MAIN_ROLE VARCHAR(255),
    PERFORMER_5_TYPE VARCHAR(255),
    PERFORMER_5_LEGAL_NAME VARCHAR(255),
    PERFORMER_5_MAIN_ROLE VARCHAR(255),
    ONLY_INCLUDE_ONLY_EXCLUDE VARCHAR(12),
    TERRITORIES_ISO_CODES VARCHAR(255),
    CATALOG_INGEST VARCHAR(255),
    COMPID NUMBER(38,0),
    COMPNM VARCHAR(255),
    COMPACTIVE BOOLEAN,
    ORCHLABELID NUMBER(38,0),
    RELID NUMBER(38,0),
    RELACTIVE BOOLEAN,
    TRKID NUMBER(38,0),
    TRKACTIVE BOOLEAN,
    _UPC VARCHAR(255),
    _ISCR VARCHAR(255),
    UPCEXISTS VARCHAR(255),
    TRACK_SEQUENCE_ISSUE VARCHAR(255),
    RELARTISTCNT VARCHAR(255),
    RELARTISTNM VARCHAR(255),
    BU_ACTION VARCHAR(255),
    BU_RESPONSE VARCHAR(255),
    BU_TRACK_ERROR VARCHAR(255),
    VAL_MET_ERROR VARCHAR(255),
    ORIGINAL_VALUE1 VARCHAR(255),
    ORIGINAL_VALUE2 VARCHAR(255),
    TAKEN_FROM_VALUE VARCHAR(255),
    SUGGESTED_VALUE1 VARCHAR(255),
    SUGGESTED_VALUE2 VARCHAR(255),
    VAL_MET_ERROR_COUNT NUMBER(19,0),
    ERROR_TYPE VARCHAR(21),
    ORCHARD_RELEASE_ID NUMBER(38,0)
);
"""