-- Migration script to add beach design fields to beach_places table
-- This script adds the has_sea, sea_location, and background_photo fields needed for the Vue beach designer

-- Add has_sea column
ALTER TABLE beach_places 
ADD COLUMN IF NOT EXISTS has_sea BOOLEAN NOT NULL DEFAULT false;

-- Add sea_location column
ALTER TABLE beach_places 
ADD COLUMN IF NOT EXISTS sea_location VARCHAR(10) DEFAULT '';

-- Add background_photo column
ALTER TABLE beach_places 
ADD COLUMN IF NOT EXISTS background_photo VARCHAR(1000) DEFAULT '';

-- Add comments for documentation
COMMENT ON COLUMN beach_places.has_sea IS 'Indicates if the beach has a sea area in the design';
COMMENT ON COLUMN beach_places.sea_location IS 'Location of sea area: T for top, L for left';
COMMENT ON COLUMN beach_places.background_photo IS 'Background photo for the beach design interface';