"""Add sc and yt active and cat

Revision ID: 84b3d8b6ce92
Revises: 48e19a431abd
Create Date: 2017-10-08 10:18:06.562147

"""

# revision identifiers, used by Alembic.
revision = '84b3d8b6ce92'
down_revision = '48e19a431abd'
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('sc_users', sa.Column('active', sa.Boolean(), nullable=False, server_default=sa.text('true')))
    op.add_column('sc_users', sa.Column('category', sa.String(), nullable=True))
    op.add_column('yt_channels', sa.Column('active', sa.Boolean(), nullable=False, server_default=sa.text('true')))
    op.add_column('yt_channels', sa.Column('category', sa.String(), nullable=True))
    ### end Alembic commands ###


def downgrade():
    ### commands auto generated by Alembic - please adjust! ###
    op.drop_column('yt_channels', 'category')
    op.drop_column('yt_channels', 'active')
    op.drop_column('sc_users', 'category')
    op.drop_column('sc_users', 'active')
    ### end Alembic commands ###