"""Add priorities

Revision ID: 496f7a700f2e
Revises: 4cae55a80a42
Create Date: 2016-03-24 12:19:34.298752

"""

# revision identifiers, used by Alembic.
revision = '496f7a700f2e'
down_revision = '4cae55a80a42'

from alembic import op
import sqlalchemy as sa


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

    op.add_column(
        'issues',
        sa.Column('priority', sa.Integer, nullable=True, default=None)
    )


def downgrade():
    ''' Drop the column _priorities from the table projects
    and the column priority from the table issues.
    '''
    op.drop_column('projects', '_priorities')
    op.drop_column('issues', 'priority')