"""create hook_mirror table

Revision ID: ba538b2648b7

Revises: 19b67f4b9fe4

Create Date: 2018-09-27 12:47:21.975843

"""

# revision identifiers, used by Alembic.

revision = 'ba538b2648b7'

down_revision = '19b67f4b9fe4'

from alembic import op

import sqlalchemy as sa

def upgrade():

    """ Create the hook_mirror to store the tags of pull-requests.

    """

    op.create_table(

        'hook_mirror',

        sa.Column(

            'id',

            sa.Integer,

            primary_key=True),

        sa.Column(

            'project_id',

              sa.Integer,

              sa.ForeignKey(

                'projects.id', onupdate='CASCADE', ondelete='CASCADE'

              ),

              nullable=False,

              primary_key=True

        ),

        sa.Column(

            'active',

            sa.Boolean,

            nullable=False,

            default=False

        ),

        sa.Column(

            'public_key',

            sa.Text,

            nullable=True

        ),

        sa.Column(

            'target',

            sa.Text,

            nullable=True

        ),

        sa.Column(

            'last_log',

            sa.Text,

            nullable=True

        )

    )

def downgrade():

    """ Delete the hook_mirror table. """

    op.drop_table('hook_mirror')