CREATE TABLE IF NOT EXISTS t_profile (
    profile_id          INT AUTO_INCREMENT PRIMARY KEY,
    profile_full_name   VARCHAR(255) NOT NULL,
    profile_title       VARCHAR(255) NOT NULL COMMENT 'Ex: Chef de Projet • Marketing & Développement',
    profile_tagline     VARCHAR(500) NOT NULL COMMENT 'Phrase d''accroche home',
    profile_bio         TEXT NULL,
    profile_email       VARCHAR(255) NULL,
    profile_phone       VARCHAR(50) NULL,
    profile_location    VARCHAR(255) NULL,
    profile_age         TINYINT NULL,
    profile_photo_path  VARCHAR(500) NULL,
    profile_cv_path     VARCHAR(500) NULL,
    profile_linkedin    VARCHAR(255) NULL,
    profile_github      VARCHAR(255) NULL,
    profile_tiktok      VARCHAR(255) NULL,
    profile_instagram   VARCHAR(255) NULL,
    profile_updated_at  DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- DOWN

DROP TABLE IF EXISTS t_profile;
