"""tiktok_influencers_pkey

Revision ID: ba3ec00b7f9c
Revises: 5bb5736a5cf5
Create Date: 2019-11-29 14:06:01.821610

"""

# revision identifiers, used by Alembic.
revision = 'ba3ec00b7f9c'
down_revision = '5bb5736a5cf5'
branch_labels = None
depends_on = None

from alembic import op
import sqlalchemy as sa


def upgrade():
    op.execute('''
    alter table tiktok_influencers drop constraint tiktok_influencers_pkey;
    create unique index tiktok_influencers_pkey on tiktok_influencers (unique_id, added_by);
    ALTER TABLE tiktok_influencers ADD PRIMARY KEY USING INDEX tiktok_influencers_pkey;

    ''')


def downgrade():
    pass