"""add hold_duration_minutes to dayrate_config

Revision ID: 000000000004
Revises: 000000000003
Create Date: 2026-02-11

Adds a configurable hold duration (in minutes) for pending dayrate bookings.
Previously hardcoded to 30 minutes. Defaults to 30 for backwards compatibility.
"""

from alembic import op

revision = "000000000004"
down_revision = "000000000003"
branch_labels = None
depends_on = None


def upgrade() -> None:
    op.execute("""
        ALTER TABLE dayrate_config
        ADD COLUMN IF NOT EXISTS hold_duration_minutes INTEGER NOT NULL DEFAULT 30;
    """)


def downgrade() -> None:
    op.execute("""
        ALTER TABLE dayrate_config
        DROP COLUMN IF EXISTS hold_duration_minutes;
    """)