-- Migration: Add paid_nights column to bookings table
-- Date: 2026-01-28
-- Description: Track partial payment by nights

ALTER TABLE `bookings` 
ADD COLUMN `paid_nights` INT NOT NULL DEFAULT 0 
AFTER `total_price`;