"""apollo_followers

Revision ID: 0dc47a6b9e33
Revises: 07a38708c8ce
Create Date: 2021-01-14 13:27:25.412664

"""

# revision identifiers, used by Alembic.
revision = '0dc47a6b9e33'
down_revision = '07a38708c8ce'
branch_labels = None
depends_on = None

from alembic import op
import sqlalchemy as sa
from sqlalchemy.dialects import postgresql

def upgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.create_table('spy_apollo_artist',
    sa.Column('spyid', sa.String(), nullable=False),
    sa.Column('created_at', sa.DateTime(), server_default=sa.text('CURRENT_TIMESTAMP'), nullable=False),
    sa.Column('last_seen', sa.DateTime(), server_default=sa.text('CURRENT_TIMESTAMP'), nullable=False),
    sa.Column('most_recent_album_copyright', sa.String(), nullable=False),
    sa.Column('most_recent_album_release_date', sa.Date(), nullable=False),
    sa.Column('name', sa.String(), nullable=False),
    sa.Column('most_recent_track_isrc', sa.String(), nullable=False),
    sa.Column('most_recent_track_id', sa.String(), nullable=False),
    sa.Column('country_iso2', sa.String(), nullable=False),
    sa.Column('major_label', sa.String(), nullable=True),
    sa.PrimaryKeyConstraint('spyid')
    )
    op.create_table('spy_apollo_followers',
    sa.Column('as_of', sa.Date(), nullable=False),
    sa.Column('artist_spyid', sa.String(), nullable=False),
    sa.Column('followers_count', sa.Integer(), nullable=False),
    sa.PrimaryKeyConstraint('as_of', 'artist_spyid')
    )


def downgrade():
    op.drop_table('spy_apollo_followers')
    op.drop_table('spy_apollo_artist')
    # ### end Alembic commands ###