# Production Deployment Notes

## Database Information
**Database Type:** SQLite  
**Database Location:** `data/yolo_charters.db`  
**Database File:** SQLite 3.x database file

## Important Notes
- This application uses SQLite, NOT MySQL or PostgreSQL
- Schema changes in `database/Database.php` only apply to fresh installs
- For existing databases, run migration scripts or manual ALTER TABLE commands
- Never use `sqlite3` command line tool - user doesn't have it installed
- Use PHP scripts or database management tools (phpLiteAdmin, DB Browser for SQLite)

## Migration Scripts
When adding new columns to existing tables, provide:
1. PHP migration script (e.g., `migrate_users_table.php`)
2. Manual SQL commands for database management tools
3. Clear instructions for running the migration

Example:
```sql
ALTER TABLE users ADD COLUMN first_name TEXT;
ALTER TABLE users ADD COLUMN last_name TEXT;
ALTER TABLE users ADD COLUMN phone TEXT;
```

## Testing Checklist
- [ ] Test on actual mobile device (not just desktop browser mobile viewport)
- [ ] Test all CRUD operations end-to-end in browser
- [ ] Test on LIVE site after deployment, not just locally
- [ ] Hard refresh browser to clear CSS/JS cache
- [ ] Check browser console for errors
- [ ] Verify API responses in Network tab

## Common Issues
1. **Mobile features not working:** Test on actual mobile device with hard refresh
2. **Admin API 401 errors:** Ensure `credentials: 'include'` in fetchAPI
3. **Database columns missing:** Run migration script on production database
4. **CSS/JS not updating:** Bump cache version in header.php

## Production Releases

### v20251117-1024 - Friends Boats Pricing & Extras Fix
**Download:** https://raw.githubusercontent.com/georgemargiolos/yolo-charters/manus/releases/yolo-charters-v20251117-1024-FRIENDS-BOATS-PRICING-EXTRAS-FIX-20251117-102509.zip

**SHA256:** `0909ad72a434de47defb832c6181d8621633c3ff65ee0acf4c62c23706b126ad`

**What's Fixed:**
- Friend's boats now show correct pricing in search results (fetched from Booking Manager API with date ranges)
- Extras display correctly for friend's boats on detail pages
- Fixed JavaScript error preventing page load (duplicate searchParams variable)
- Added "Price on request" fallback when pricing unavailable

**Technical Changes:**
- Modified `BookingManagerService::getOffers()` to skip YOLO filter for specific yacht IDs
- Updated `getFriendsBoats()` API to accept from/to params and return pricing
- Updated `getYachtDetailsFromBM()` to fetch extras with date ranges
- Fixed duplicate variable declaration in search-results.php

---
**Created:** 2025-11-17  
**Purpose:** Document critical production deployment information to avoid repeated mistakes