"""Add the closed_by column to pull_requests

Revision ID: abc71fd60fa

Revises: 298891e63039

Create Date: 2015-06-08 16:06:18.017110

"""

# revision identifiers, used by Alembic.

revision = 'abc71fd60fa'

down_revision = '298891e63039'

from alembic import op

import sqlalchemy as sa

def upgrade():

    ''' Add the column merge_status to the table pull_requests.

    '''

    op.add_column(

        'pull_requests',

        sa.Column(

            'closed_by_id',

            sa.Integer,

            sa.ForeignKey('users.id', onupdate='CASCADE'),

        )

    )

def downgrade():

    ''' Remove the column merge_status from the table pull_requests.

    '''

    op.drop_column('pull_requests', 'closed_by_id')