"""tiktok_influencers

Revision ID: a45c7d9b2d15
Revises: 23ff054eda5c
Create Date: 2019-11-25 11:55:01.428344

"""

# revision identifiers, used by Alembic.
revision = 'a45c7d9b2d15'
down_revision = '23ff054eda5c'
branch_labels = None
depends_on = None

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

def upgrade():
    op.create_table('tiktok_influencers',
    sa.Column('unique_id', sa.String(), nullable=False),
    sa.Column('added', sa.DateTime(), server_default=sa.text('CURRENT_TIMESTAMP'), nullable=False),
    sa.PrimaryKeyConstraint('unique_id')
    )
    op.add_column('tiktok_users', sa.Column('is_influencer', sa.Boolean(), server_default=sa.text('false'), nullable=False))
    op.create_index(op.f('ix_tiktok_users_unique_id'), 'tiktok_users', ['unique_id'], unique=False)


def downgrade():
    op.drop_index(op.f('ix_tiktok_users_unique_id'), table_name='tiktok_users')
    op.drop_column('tiktok_users', 'is_influencer')
    op.drop_table('tiktok_influencers')
    ### end Alembic commands ###