"""soundcloud_last_stats_columns

Revision ID: ebdfcd2ee64a
Revises: beb30b34cd71
Create Date: 2019-09-13 11:11:24.280338

"""

# revision identifiers, used by Alembic.
revision = 'ebdfcd2ee64a'
down_revision = 'beb30b34cd71'
branch_labels = None
depends_on = None

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

def upgrade():
    op.add_column('sc_tracks', sa.Column('last_comment_count', sa.Integer(), autoincrement=False, nullable=True))
    op.add_column('sc_tracks', sa.Column('last_download_count', sa.Integer(), autoincrement=False, nullable=True))
    op.add_column('sc_tracks', sa.Column('last_favoritings_count', sa.Integer(), autoincrement=False, nullable=True))
    op.add_column('sc_tracks', sa.Column('last_playback_count', sa.Integer(), autoincrement=False, nullable=True))
    op.add_column('sc_users', sa.Column('last_followers_count', sa.Integer(), autoincrement=False, nullable=True))
    op.add_column('sc_users', sa.Column('last_followings_count', sa.Integer(), autoincrement=False, nullable=True))
    op.add_column('sc_users', sa.Column('last_playlist_count', sa.Integer(), autoincrement=False, nullable=True))
    op.add_column('sc_users', sa.Column('last_public_favorites_count', sa.Integer(), autoincrement=False, nullable=True))
    op.add_column('sc_users', sa.Column('last_track_count', sa.Integer(), autoincrement=False, nullable=True))


def downgrade():
    op.drop_column('sc_users', 'last_track_count')
    op.drop_column('sc_users', 'last_public_favorites_count')
    op.drop_column('sc_users', 'last_playlist_count')
    op.drop_column('sc_users', 'last_followings_count')
    op.drop_column('sc_users', 'last_followers_count')
    op.drop_column('sc_tracks', 'last_playback_count')
    op.drop_column('sc_tracks', 'last_favoritings_count')
    op.drop_column('sc_tracks', 'last_download_count')
    op.drop_column('sc_tracks', 'last_comment_count')