la-huasca-ts/MIGRATION_NOTES.md

Migration script to fix missing columns in existing tables

We've identified that the init-db.sh script in the repository already includes the correct schema with all the necessary columns, but when it was run on the database, it skipped adding new columns to existing tables because they already existed.

To fix this issue, we've created a migration script that adds the missing columns to existing tables:

1. Added photos and featured_photo columns to the rooms table
2. Added photos and featured_photo columns to the places table
3. Added photos and featured_photo columns to the menu_items table
4. Added first_name and last_name columns to the users table
5. Added comments_disabled column to the users table
6. Added featured_photo column to the reservations table
7. Added featured_photo column to the social_events table
8. Added featured_photo column to the reviews table
9. Added featured_photo column to the social_event_reservations table
10. Added featured_photo column to the calendar_events table
11. Added featured_photo column to the room_comments table
12. Added featured_photo column to the offers table
13. Added featured_photo column to the coupons table
14. Added featured_photo column to the benefits table
15. Added featured_photo column to the slides table
16. Added featured_photo column to the config table

This migration script should be run on any existing database to ensure all tables have the correct schema.