"""Add reports field to project

Revision ID: 1640c7d75e5f
Revises: 1d18843a1994
Create Date: 2016-09-09 16:11:28.099423

"""

# revision identifiers, used by Alembic.
revision = '1640c7d75e5f'
down_revision = '1d18843a1994'

from alembic import op
import sqlalchemy as sa


def upgrade():
    ''' Add the column _reports to the table projects
    '''
    op.add_column(
        'projects',
        sa.Column('_reports', sa.Text, nullable=True)
    )


def downgrade():
    ''' Drop the column _reports from the table projects.
    '''
    op.drop_column('projects', '_reports')