-- Add price per night to rooms
ALTER TABLE app.room ADD COLUMN price_per_night NUMERIC(10,2);