| 12345678910111213141516171819202122232425262728293031 |
- """resolution status in alerts
- Revision ID: e33dd011fb87
- Revises: 00b43bc4e8ac
- Create Date: 2023-07-03 13:28:08.882759
- """
- from alembic import op
- import sqlalchemy as sa
- from app.alembic.alembic_utils import _table_has_column
- # revision identifiers, used by Alembic.
- revision = 'e33dd011fb87'
- down_revision = '00b43bc4e8ac'
- branch_labels = None
- depends_on = None
- def upgrade():
- if not _table_has_column('alerts', 'alert_resolution_status_id'):
- op.add_column('alerts', sa.Column('alert_resolution_status_id', sa.Integer(), nullable=True))
- op.create_foreign_key(None, 'alerts', 'alert_resolution_status',
- ['alert_resolution_status_id'], ['resolution_status_id'])
- pass
- def downgrade():
- pass
|