"""Add bpi_applicable and bpi_treatment to interest_configurations

Revision ID: d4e2f9a1c8b6
Revises: c3a1f8e2d9b5
Create Date: 2026-06-18 14:10:00.000000

"""
from typing import Sequence, Union

from alembic import op
import sqlalchemy as sa

# revision identifiers, used by Alembic.
revision: str = 'd4e2f9a1c8b6'
down_revision: Union[str, None] = 'c3a1f8e2d9b5'
branch_labels: Union[str, Sequence[str], None] = None
depends_on: Union[str, Sequence[str], None] = None


def upgrade() -> None:
    op.add_column('interest_configurations',
        sa.Column('bpi_applicable', sa.Boolean(), nullable=True, server_default=sa.text('0')))
    op.add_column('interest_configurations',
        sa.Column('bpi_treatment', sa.String(length=50), nullable=True, server_default='ADD_TO_FIRST_EMI'))


def downgrade() -> None:
    op.drop_column('interest_configurations', 'bpi_treatment')
    op.drop_column('interest_configurations', 'bpi_applicable')