"""Table for no new branches hook

Revision ID: 131ad2dc5bbd

Revises: 5bb80aeb238d

Create Date: 2018-05-11 10:52:05.088806

"""

# revision identifiers, used by Alembic.

revision = '131ad2dc5bbd'

down_revision = '5bb80aeb238d'

from alembic import op

import sqlalchemy as sa

def upgrade():

    """ Create table for PagureNoNewBranchesHook. """

    op.create_table(

        'hook_pagure_no_new_branches',

        sa.Column('id', sa.INTEGER(), nullable=False),

        sa.Column('project_id', sa.INTEGER(), nullable=False),

        sa.Column('active', sa.BOOLEAN(), nullable=False),

        sa.ForeignKeyConstraint(

            ['project_id'],

            [u'projects.id'],

            name=u'hook_pagure_no_new_branches_project_id_fkey',

            onupdate=u'CASCADE',

            ondelete=u'CASCADE'

        ),

        sa.PrimaryKeyConstraint('id', name=u'hook_pagure_no_new_branches_pkey')

    )

def downgrade():

    """ Remove table for PagureNoNewBranchesHook. """

    op.drop_table('hook_pagure_no_new_branches')