CREATE TABLE `daisy`.`geodae` (
  `id_geodae` INT NOT NULL,
  `lat_coor1` VARCHAR(45) NOT NULL,
  `long_coor1` VARCHAR(45) NOT NULL,
  `nom` VARCHAR(512) NULL,
  `adr_num` VARCHAR(512) NULL,
  `adr_voie` VARCHAR(512) NULL,
  `com_cp` VARCHAR(10) NULL,
  `com_nom` VARCHAR(512) NULL,
  `acc_complt` VARCHAR(512) NULL,
  `com_insee` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id_geodae`));