"""updates in table schema and new fields

Revision ID: 68cf2ea012e7
Revises: 7256e11aa2ee
Create Date: 2026-07-17 16:28:44.627146

"""
from typing import Sequence, Union

from alembic import op
import sqlalchemy as sa


# revision identifiers, used by Alembic.
revision: str = '68cf2ea012e7'
down_revision: Union[str, None] = '7256e11aa2ee'
branch_labels: Union[str, Sequence[str], None] = None
depends_on: Union[str, Sequence[str], None] = None


def upgrade() -> None:
    # ### commands auto generated by Alembic - please adjust! ###
    op.add_column('cart', sa.Column('selected_day', sa.String(length=10), nullable=True))
    op.add_column('course', sa.Column('is_bookable', sa.Boolean(), server_default=sa.text('true'), nullable=False))
    op.add_column('course', sa.Column('is_day_selection_required', sa.Boolean(), server_default=sa.text('false'), nullable=False))
    op.add_column('participants', sa.Column('school_name', sa.String(length=255), nullable=True))
    op.add_column('payment_details', sa.Column('selected_day', sa.String(length=10), nullable=True))
    # ### end Alembic commands ###


def downgrade() -> None:
    # ### commands auto generated by Alembic - please adjust! ###
    op.drop_column('payment_details', 'selected_day')
    op.drop_column('participants', 'school_name')
    op.drop_column('course', 'is_day_selection_required')
    op.drop_column('course', 'is_bookable')
    op.drop_column('cart', 'selected_day')
    # ### end Alembic commands ###