+ """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

+         )

+     )

+ 

+ 

+ def downgrade():

+     """ Delete the hook_mirror table. """

+     op.drop_table('hook_mirror')