"""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')