All descriptions are coming from a dump "nodata"

The involved sequence :
DROP SEQUENCE IF EXISTS `id_suivi`;

CREATE SEQUENCE `id_suivi` start with 1756527024 minvalue 1 maxvalue 9223372036854775806 increment by 0 nocache nocycle ENGINE=InnoDB;
SELECT SETVAL(`id_suivi`, 1974543016, 0);
--
--  the first table
--
CREATE TABLE `SUIVI_V2` (
  `ID` bigint(20) NOT NULL DEFAULT nextval(`coyote`.`id_suivi`),
  `UUID` varchar(36) NOT NULL,
  `CREATION_DATE` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `LAST_CONFIRMATION_DATE` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `LAST_REJECTION_DATE` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `EXPIRATION_DATE` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `BROADCAST_END_DATE` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `EVENT_AT_THE_END` tinyint(4) NOT NULL,
  `CONFIRMATION_ASKED` tinyint(4) NOT NULL,
  `DEFAULT_LENGTH` int(11) NOT NULL,
  `AFFTAC_LENGTH` int(11) NOT NULL,
  `VR` varbinary(4096) DEFAULT NULL,
  `SOURCE_ID` int(11) NOT NULL,
  `FORECAST_DIRECTION` tinyint(4) NOT NULL,
  `CATEGORY` smallint(6) NOT NULL,
  `REVISION` bigint(20) NOT NULL,
  `UPDATE_DATE` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`ID`),
  KEY `UUID` (`UUID`),
  KEY `SUPPRESSION` (`SUPPRESSION`,`ID`),
  KEY `BROADCAST_END_DATE` (`BROADCAST_END_DATE`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- another table
--
CREATE TABLE `LOCAL_POI_ZONE_RT` (
  `ID_ZONE_RT` bigint(20) NOT NULL DEFAULT nextval(`coyote`.`id_suivi`),
  `ID_POI` bigint(20) DEFAULT NULL,
  `COD_PAYS` varchar(2) CHARACTER SET latin1 COLLATE latin1_general_cs DEFAULT NULL,
  `TYPE` int(11) NOT NULL,
  `STYPE` int(11) NOT NULL DEFAULT 0,
  `RC_REFERENCE` varchar(50) NOT NULL DEFAULT '',
  `ID_EVENT` varchar(50) NOT NULL DEFAULT '',
  `NB_REPORTS` int(11) NOT NULL DEFAULT 0,
  `LIFESPAN` int(11) NOT NULL DEFAULT 0,
  `WIDTH` int(11) unsigned NOT NULL,
  `REAL_LENGTH` int(11) unsigned NOT NULL,
  `DEFAULT_SUIVI_LENGTH` int(11) NOT NULL DEFAULT 0,
  `ID_CODIF_ERROR_CODE` int(3) NOT NULL,
  `SUPPRESSION` int(3) NOT NULL DEFAULT 0,
  `EVENT_AT_THE_END` int(3) NOT NULL,
  `CONFIRMATION_NEEDED` int(11) NOT NULL DEFAULT 1,
  `DATE_SIGN` datetime NOT NULL,
  `DATE_LAST_CONF` timestamp NULL DEFAULT NULL,
  `DATE_FIN` timestamp NULL DEFAULT NULL,
  `DATE_SUPP` datetime NOT NULL,
  `DATE_MAJ` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `NB_INTERRUPTS` int(11) NOT NULL DEFAULT 0,
  `DEFAULT_LIFESPAN` int(11) NOT NULL DEFAULT 0,
  `NEXT_SUIVI` varbinary(512) DEFAULT NULL,
  `VR` varbinary(4096) DEFAULT NULL,
  `GKEY` int(10) unsigned DEFAULT NULL,
  `ID_CODIF_SOURCE_POI` int(11) DEFAULT NULL,
  PRIMARY KEY (`ID_ZONE_RT`),
  KEY `ID_POI` (`ID_POI`),
  KEY `DATE_SIGN` (`DATE_SIGN`),
  KEY `DATE_FIN` (`DATE_FIN`),
  KEY `DATE_SUPP` (`DATE_SUPP`),
  KEY `DATE_MAJ` (`DATE_MAJ`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- The third table
--
CREATE TABLE `LOCAL_APPAREIL_M` (
  `ID_APPAREIL_M` bigint(20) NOT NULL DEFAULT nextval(`coyote`.`id_suivi`),
  `ID_CODIF_TYPE_POI` int(11) NOT NULL DEFAULT 21,
  `POI_ZONE` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `ID_CODIF_SOURCE_POI` int(11) NOT NULL DEFAULT 1,
  `REF_SOURCE_POI` int(11) DEFAULT NULL,
  `ZONE` int(11) NOT NULL DEFAULT 0,
  `DLAT` int(11) NOT NULL DEFAULT 0,
  `DLON` int(11) NOT NULL DEFAULT 0,
  `DATE_SIGN_APPAREIL_M` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `DATE_SUPP_APPAREIL_M` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `VOIE_APPAREIL_M` varchar(5) NOT NULL DEFAULT '',
  `PK` int(11) NOT NULL DEFAULT 0,
  `ID_LOCAL` int(11) NOT NULL DEFAULT 0,
  `ID_UTILISATEUR` int(11) NOT NULL DEFAULT 0,
  `ETAT_APPAREIL_M` tinyint(1) NOT NULL DEFAULT 1,
  `ID_APPAREIL_H_ATTENTE` int(10) unsigned DEFAULT NULL,
  `ID_APPAREIL_M_CONFIRME` bigint(20) DEFAULT NULL,
  `NB_CONFIRMATION` int(11) NOT NULL DEFAULT 0,
  `DUREE_VIE` int(11) NOT NULL DEFAULT 0,
  `ZONE_ID` int(10) unsigned NOT NULL DEFAULT 0,
  `ZONE_ID_CODIF_CAP_SIGN` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `DATE_MAJ` timestamp NOT NULL DEFAULT current_timestamp(),
  `TEMPS_RM` int(11) DEFAULT 0,
  `ID_SAUVEGARDE` int(11) DEFAULT 0,
  `DUREE_VIE_PAR_DEFAUT` int(11) DEFAULT 3600,
  `RAYON_ECL` int(11) NOT NULL DEFAULT -1,
  `NB_ECL_ZONE` int(11) NOT NULL DEFAULT -1,
  `NB_ECL_ROUTE` int(11) NOT NULL DEFAULT -1,
  `DATE_LAST_TYPE_UPDATE` timestamp NULL DEFAULT NULL,
  `LINK_ID` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`ID_APPAREIL_M`),
  KEY `DATE_LAST_TYPE_UPDATE` (`DATE_LAST_TYPE_UPDATE`),
  KEY `DATE_MAJ` (`DATE_MAJ`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
--