-- #migration 2026_09_10_001
-- Pilotage hebdo (contacts/appels/signatures) et interviews artisans,
-- pour le point hebdo de croissance (plan 15 semaines).

CREATE TABLE IF NOT EXISTS pilotage_hebdo (
  id                    VARCHAR(40)  NOT NULL PRIMARY KEY,
  semaine_debut         DATE         NOT NULL,
  contacts_travailles   INT          NOT NULL DEFAULT 0,
  appels_tenus          INT          NOT NULL DEFAULT 0,
  signatures            INT          NOT NULL DEFAULT 0,
  notes                 TEXT         NULL,
  created_at            DATETIME     NOT NULL DEFAULT CURRENT_TIMESTAMP,
  updated_at            DATETIME     NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  UNIQUE KEY uq_ph_semaine (semaine_debut)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS interviews_artisans (
  id                    VARCHAR(40)  NOT NULL PRIMARY KEY,
  date_interview        DATE         NOT NULL,
  artisan_nom           VARCHAR(150) NOT NULL,
  niveau                TINYINT      NULL,
  cartes_alimentees     TEXT         NULL,
  posts_threads         TEXT         NULL,
  notes                 TEXT         NULL,
  created_at            DATETIME     NOT NULL DEFAULT CURRENT_TIMESTAMP,
  INDEX idx_ia_date (date_interview)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;