12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061 |
- """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')
|