"""add_sc_tracks_created_at_index

Revision ID: 9b54f5809990
Revises: e6ccbc6f122f
Create Date: 2020-11-30 14:34:38.619492

"""

# revision identifiers, used by Alembic.
revision = '9b54f5809990'
down_revision = 'e6ccbc6f122f'
branch_labels = None
depends_on = None

from alembic import op
import sqlalchemy as sa


def upgrade():
    # used by the sync to elastic
    op.execute('''
    create index
      sc_tracks_500_created
      on sc_tracks (created_at)
      where last_playback_count >= 500;
    ''')


def downgrade():
    op.execute('''
    drop index sc_tracks_500_created
    ''')