"""Add ci_job attribute to the hook_pagure_ci table

Revision ID: e18d5b78d782
Revises: 22fb5256f555
Create Date: 2018-03-16 11:51:04.613420

"""

# revision identifiers, used by Alembic.
revision = 'e18d5b78d782'
down_revision = '22fb5256f555'

from alembic import op
import sqlalchemy as sa


def upgrade():
    ''' Add ci_job column to projects table'''
    op.add_column(
        'hook_pagure_ci',
        sa.Column('ci_job', sa.String(255), nullable=True, unique=False)
    )


def downgrade():
    ''' Revert the ci_job column added'''
    op.drop_column('hook_pagure_ci', 'ci_job')