← back to Jill Website

src/migrations/004_add_rating_to_activities.sql

10 lines

-- Add rating column to activities table
ALTER TABLE activities
ADD COLUMN IF NOT EXISTS rating DECIMAL(2, 1) CHECK (rating >= 0 AND rating <= 5);

-- Create index for rating queries
CREATE INDEX IF NOT EXISTS idx_activities_rating ON activities(rating);

-- Add comment for documentation
COMMENT ON COLUMN activities.rating IS 'Google Reviews rating (0-5 scale)';