-- MySQL schema for prospects (v2)
CREATE TABLE IF NOT EXISTS prospects_sirene (
  siret CHAR(14) PRIMARY KEY,
  nom VARCHAR(255),
  ape VARCHAR(10),
  adresse VARCHAR(255),
  cp VARCHAR(10),
  ville VARCHAR(120),
  dep CHAR(2),
  date_creation DATE,
  score INT,
  source VARCHAR(30),
  first_seen DATETIME,
  last_seen DATETIME,
  contacted TINYINT DEFAULT 0,
  notes TEXT
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE INDEX idx_dep_date ON prospects_sirene (dep, date_creation);
CREATE INDEX idx_score ON prospects_sirene (score);
