CREATE TABLE IF NOT EXISTS creator_pages (
    id INT AUTO_INCREMENT PRIMARY KEY,
    user_id INT NOT NULL,
    slug VARCHAR(120) NOT NULL UNIQUE,
    statut ENUM('draft','published','unlisted') NOT NULL DEFAULT 'draft',
    titre VARCHAR(200) NOT NULL DEFAULT '',
    accroche VARCHAR(220) DEFAULT '',
    bio TEXT,
    savoir_faire TEXT,
    metier ENUM('artisan','designer','artiste','createur') DEFAULT 'artisan',
    domaine VARCHAR(100) DEFAULT '',
    localisation VARCHAR(100) DEFAULT '',
    site_web VARCHAR(255) DEFAULT '',
    instagram VARCHAR(100) DEFAULT '',
    hero_image VARCHAR(500) DEFAULT '',
    atelier_label VARCHAR(100) DEFAULT '',
    collection_titre VARCHAR(150) DEFAULT '',
    collection_description TEXT,
    collection_note VARCHAR(200) DEFAULT '',
    collection_images JSON,
    book_images JSON,
    specs JSON,
    recherche_types JSON,
    recherche_description TEXT,
    ordre_sections JSON,
    contact_visible TINYINT(1) NOT NULL DEFAULT 1,
    contact_email VARCHAR(200) DEFAULT '',
    contact_message_placeholder TEXT,
    created_at DATETIME NOT NULL,
    updated_at DATETIME NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE IF NOT EXISTS creator_page_visits (
    id INT AUTO_INCREMENT PRIMARY KEY,
    page_id INT NOT NULL,
    visitor_ip VARCHAR(64) DEFAULT '',
    referrer VARCHAR(255) DEFAULT '',
    created_at DATETIME NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE IF NOT EXISTS creator_contact_requests (
    id INT AUTO_INCREMENT PRIMARY KEY,
    page_id INT NOT NULL,
    expediteur_nom VARCHAR(200) DEFAULT '',
    expediteur_email VARCHAR(200) DEFAULT '',
    expediteur_metier VARCHAR(100) DEFAULT '',
    type_demande VARCHAR(50) DEFAULT 'autre',
    message TEXT,
    lu TINYINT(1) NOT NULL DEFAULT 0,
    created_at DATETIME NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;