CREATE TABLE IF NOT EXISTS sig_ant.ftth_smmn_preinscriptions (
  "id" int NOT NULL,
  "date" date NOT NULL,
  "nom" varchar(50) NOT NULL,
  "prenom" varchar(50) NOT NULL,
  "email" varchar(100) NOT NULL,
  "telephone_fixe" varchar(10) NOT NULL,
  "telephone_portable" varchar(10) NOT NULL,
  "numero_voie" varchar(10) NOT NULL,
  "type_voie" varchar(40) NOT NULL,
  "nom_voie" varchar(120) NOT NULL,
  "complement_addresse" varchar(250) NOT NULL,
  "batiment" varchar(30) NOT NULL,
  "cage_escalier" varchar(10) NOT NULL,
  "etage" varchar(10) NOT NULL,
  "numero_appartement" varchar(10) NOT NULL,
  "code_postal" varchar(5) NOT NULL,
  "ville" varchar(250) NOT NULL,
  "geo_code" varchar(250) NOT NULL,
  "vous_etes" varchar(250) NOT NULL,
  "ce_logement_est" varchar(250) NOT NULL,
  "accord" varchar(30) NOT NULL,
  "info_et_libertes" bool NOT NULL,
  "id_zapm_partielle" varchar(25) NOT NULL
);

ALTER TABLE sig_ant.ftth_smmn_preinscriptions
    ADD PRIMARY KEY (id);