"""add handover/return name fields to borrow_requests

Revision ID: dddd_borrow_names
Revises: cccc_borrow_remake
Create Date: 2026-04-24
"""
from alembic import op
import sqlalchemy as sa

revision = 'dddd_borrow_names'
down_revision = 'cccc_borrow_remake'
branch_labels = None
depends_on = None


def upgrade() -> None:
    op.add_column('borrow_requests', sa.Column('handover_handed_by', sa.String(255), nullable=True))
    op.add_column('borrow_requests', sa.Column('return_handed_by',   sa.String(255), nullable=True))
    op.add_column('borrow_requests', sa.Column('return_recipient',   sa.String(255), nullable=True))


def downgrade() -> None:
    op.drop_column('borrow_requests', 'return_recipient')
    op.drop_column('borrow_requests', 'return_handed_by')
    op.drop_column('borrow_requests', 'handover_handed_by')