"""add display_payer_ip and display_payer_location to hpp_sessions

Revision ID: hpp001_display_payer
Revises: chk001_auth_billing_cvv
Create Date: 2026-03-25

"""
from alembic import op
import sqlalchemy as sa

revision = 'hpp001_display_payer'
down_revision = 'chk001_auth_billing_cvv'
branch_labels = None
depends_on = None


def upgrade() -> None:
    op.add_column(
        'hpp_sessions',
        sa.Column('display_payer_ip', sa.Boolean(), nullable=True, server_default=sa.text('false'))
    )
    op.add_column(
        'hpp_sessions',
        sa.Column('display_payer_location', sa.Boolean(), nullable=True, server_default=sa.text('false'))
    )


def downgrade() -> None:
    op.drop_column('hpp_sessions', 'display_payer_location')
    op.drop_column('hpp_sessions', 'display_payer_ip')