| 12345678910111213141516171819202122232425262728293031323334353637383940 |
- """Reviewer in case
- Revision ID: 65168cb6cc90
- Revises: e33dd011fb87
- Create Date: 2023-07-09 09:01:39.243870
- """
- from alembic import op
- import sqlalchemy as sa
- from app.alembic.alembic_utils import _table_has_column
- # revision identifiers, used by Alembic.
- revision = '65168cb6cc90'
- down_revision = 'e33dd011fb87'
- branch_labels = None
- depends_on = None
- def upgrade():
- if not _table_has_column('cases', 'reviewer_id'):
- op.add_column('cases',
- sa.Column('reviewer_id', sa.Integer(), nullable=True)
- )
- op.create_foreign_key('fkey_cases_reviewer_id', 'cases', 'user', ['reviewer_id'], ['id'])
- if not _table_has_column('cases', 'review_status_id'):
- op.add_column('cases',
- sa.Column('review_status_id', sa.Integer(), nullable=True)
- )
- op.create_foreign_key('fkey_cases_review_status_id', 'cases', 'review_status', ['review_status_id'], ['id'])
- pass
- def downgrade():
- pass
|
