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