"""Add authorization_method, require_billing_address, require_cvv to checkouts

Revision ID: chk001_auth_billing_cvv
Revises: rbac007a8b9c0d
Create Date: 2026-03-24

"""
from alembic import op
import sqlalchemy as sa

revision: str = 'chk001_auth_billing_cvv'
down_revision: str = 'bd7e4ac6a3db'
branch_labels = None
depends_on = None


def upgrade() -> None:
    op.add_column('checkouts', sa.Column('authorization_method', sa.String(20), nullable=True))
    op.add_column('checkouts', sa.Column('require_billing_address', sa.Boolean(), nullable=False, server_default=sa.text('false')))
    op.add_column('checkouts', sa.Column('require_cvv', sa.Boolean(), nullable=False, server_default=sa.text('false')))


def downgrade() -> None:
    op.drop_column('checkouts', 'require_cvv')
    op.drop_column('checkouts', 'require_billing_address')
    op.drop_column('checkouts', 'authorization_method')