"""add bot_sub_code to meetings

Revision ID: 20260619_0013
Revises: 1553d3f245fd
Create Date: 2026-06-19 12:00:00
"""
from __future__ import annotations

from alembic import op
import sqlalchemy as sa


revision = "20260619_0013"
down_revision = "1553d3f245fd"
branch_labels = None
depends_on = None


def upgrade() -> None:
    bind = op.get_bind()
    inspector = sa.inspect(bind)
    columns = {column["name"] for column in inspector.get_columns("meetings")}

    if "bot_sub_code" not in columns:
        op.add_column("meetings", sa.Column("bot_sub_code", sa.String(), nullable=True))


def downgrade() -> None:
    bind = op.get_bind()
    inspector = sa.inspect(bind)
    columns = {column["name"] for column in inspector.get_columns("meetings")}

    if "bot_sub_code" in columns:
        op.drop_column("meetings", "bot_sub_code")