"""Query to create asset source table."""

CREATE_NUMBERED_AUDIO_ASSET_RIPPER_TABLE = """
    create or replace TABLE ASSET_AUDIO_RIPPER_TABLE_{number} (
        SOURCE_RELID VARCHAR(16777216),
        VOLUME NUMBER(38,0),
        TRACK NUMBER(38,0),
        FILE_NAME VARCHAR(16777216),
        UPLOAD_DATE DATE,
        FILE_SIZE NUMBER(38,0),
        ORCH_UPC NUMBER(20,0),
        VENDOR_ID NUMBER(38,0)
    );
"""