"""drop spy official chart fk


Revision ID: cca7a93560b5
Revises: a4063bb5b990
Create Date: 2019-01-23 17:48:03.113836

"""

# revision identifiers, used by Alembic.
revision = 'cca7a93560b5'
down_revision = 'a4063bb5b990'
branch_labels = None
depends_on = None

from alembic import op
import sqlalchemy as sa


def upgrade():

    op.execute('''alter table spy_official_charts drop constraint spy_official_chart_spyid_fkey''')
    op.execute('''create index spy_official_charts_spyid on spy_official_charts (spyid)''')


def downgrade():
    pass