| 123456789101112131415161718192021222324252627282930313233343536373839404142434445 |
- """add missing relation
- Revision ID: f7a9944a660c
- Revises: 285f2f9c840a
- Create Date: 2026-07-21 01:43:31.818040
- """
- from alembic import op
- import sqlalchemy as sa
- # revision identifiers, used by Alembic.
- revision = 'f7a9944a660c'
- down_revision = '285f2f9c840a'
- branch_labels = None
- depends_on = None
- def upgrade():
- op.add_column('slot_templates', sa.Column('commission_id', sa.UUID(as_uuid=False), nullable=True))
- op.create_foreign_key(
- 'fk_slot_templates_commission_id',
- 'slot_templates', 'commissions',
- ['commission_id'], ['id'],
- ondelete='SET NULL',
- )
- op.alter_column(
- "slot_templates",
- "responsible_contact",
- new_column_name="responsible_override",
- existing_type=sa.String(),
- nullable=True,
- )
- def downgrade():
- op.alter_column(
- "slot_templates",
- "responsible_override",
- new_column_name="responsible_contact",
- existing_type=sa.String(),
- nullable=False,
- )
- op.drop_constraint('fk_slot_templates_commission_id', 'slot_templates', type_='foreignkey')
- op.drop_column('slot_templates', 'commission_id')
|
