-- 1-on-1 coaching applications
CREATE TABLE IF NOT EXISTS coaching_applications (
    id              INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    user_id         INT UNSIGNED NOT NULL,
    full_name       VARCHAR(180) NOT NULL,
    email           VARCHAR(255) NOT NULL,
    phone           VARCHAR(40)  DEFAULT NULL,
    country         VARCHAR(120) DEFAULT NULL,
    timezone        VARCHAR(80)  DEFAULT NULL,
    age_range       VARCHAR(40)  DEFAULT NULL,
    current_work    VARCHAR(255) DEFAULT NULL,
    why_now         TEXT,
    break_free_from TEXT,
    tried_before    TEXT,
    success_6mo     TEXT,
    biggest_fear    TEXT,
    hours_per_week  VARCHAR(60)  DEFAULT NULL,
    investment      VARCHAR(80)  DEFAULT NULL,
    start_when      VARCHAR(60)  DEFAULT NULL,
    preferred_times TEXT,
    anything_else   TEXT,
    consent_contact TINYINT(1)   NOT NULL DEFAULT 0,
    status          VARCHAR(40)  NOT NULL DEFAULT 'submitted',
    created_at      TIMESTAMP    DEFAULT CURRENT_TIMESTAMP,
    updated_at      TIMESTAMP    DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    INDEX idx_user (user_id),
    INDEX idx_created (created_at)
);
