"""Add insta category

Revision ID: 6573d11f3986
Revises: 8fdc7b3cb64d
Create Date: 2017-10-12 17:23:50.439914

"""

# revision identifiers, used by Alembic.
revision = '6573d11f3986'
down_revision = '8fdc7b3cb64d'
branch_labels = None
depends_on = None

from alembic import op
import sqlalchemy as sa


def upgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.add_column('in_user', sa.Column('active', sa.Boolean(), server_default=sa.text('true'), nullable=False))
    op.add_column('in_user', sa.Column('category', sa.String(), nullable=True))
    op.add_column('in_user', sa.Column('is_influencer', sa.Boolean(), server_default=sa.text('false'), nullable=False))
    op.drop_index('spy_tracks_primary_artist_spyid_idx', table_name='spy_tracks')
    ### end Alembic commands ###


def downgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.create_index('spy_tracks_primary_artist_spyid_idx', 'spy_tracks', ['primary_artist_spyid'], unique=False)
    op.drop_column('in_user', 'is_influencer')
    op.drop_column('in_user', 'category')
    op.drop_column('in_user', 'active')
    ### end Alembic commands ###