"""add plan description

Revision ID: 07c695b8cd68
Revises: 7f36d08d4759
Create Date: 2018-12-20 09:39:42.527095

"""
from alembic import op
import sqlalchemy as sa


# revision identifiers, used by Alembic.
revision = '07c695b8cd68'
down_revision = '7f36d08d4759'
branch_labels = None
depends_on = None


def upgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.add_column('plan', sa.Column('description', sa.String(length=250), nullable=True))
    op.create_index(op.f('ix_plan_description'), 'plan', ['description'], unique=False)
    # ### end Alembic commands ###


def downgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.drop_index(op.f('ix_plan_description'), table_name='plan')
    op.drop_column('plan', 'description')
    # ### end Alembic commands ###
