123456789101112131415161718192021222324252627282930313233343536373839404142434445464748 |
- """Add PR tags table
- Revision ID: a13967424130
- Revises: 01e58ee9eccb
- Create Date: 2017-11-05 16:56:01.164976
- """
- import datetime
- from alembic import op
- import sqlalchemy as sa
- # revision identifiers, used by Alembic.
- revision = 'a13967424130'
- down_revision = '01e58ee9eccb'
- def upgrade():
- """ Create the tags_pull_requests to store the tags of pull-requests.
- """
- op.create_table(
- 'tags_pull_requests',
- sa.Column(
- 'tag_id',
- sa.Integer,
- sa.ForeignKey(
- 'tags_colored.id', ondelete='CASCADE', onupdate='CASCADE',
- ),
- primary_key=True),
- sa.Column(
- 'request_uid',
- sa.String(32),
- sa.ForeignKey(
- 'pull_requests.uid', ondelete='CASCADE', onupdate='CASCADE',
- ),
- primary_key=True),
- sa.Column(
- 'date_created',
- sa.DateTime,
- nullable=False,
- default=datetime.datetime.utcnow),
- )
- def downgrade():
- """ Delete the tags_pull_requests table. """
- op.drop_table('tags_pull_requests')
|