Database Structure:

The main database is: fhpkenos_fitnessApp (with uppercase A in App)

Main tables:
1. workouts - Stores workout information
   - id (primary key)
   - user_id
   - route_id
   - title
   - name
   - description
   - workout_type (ENUM: 'Run', 'Ride', 'Swim', 'Walk', 'Hike', 'Kayak', 'weight-training')
   - duration (seconds)
   - distance
   - elevation_gain
   - date
   - status
   - route_data (JSON string of coordinates)
   - exercises (JSON string)
   - private_notes
   - how_it_felt
   - visibility
   - is_manual_entry
   - created_at
   - updated_at

2. users - Stores user information

3. goals - Stores user fitness goals

Note: workout_type in the database must match the case used in the iOS app's ActivityType.swift enum

-- Add starting_weight to goals table
ALTER TABLE goals ADD COLUMN starting_weight DOUBLE AFTER target_value;

-- Create weights table for weight logs
CREATE TABLE IF NOT EXISTS weights (
    id INT AUTO_INCREMENT PRIMARY KEY,
    user_id INT NOT NULL,
    date DATETIME NOT NULL,
    weight DOUBLE NOT NULL
);