CREATE TABLE `llx_rendez_vous_historique` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `fk_rendez_vous` int(11) DEFAULT NULL,
  `ancienne_date` datetime DEFAULT NULL,
  `nouvelle_date` datetime DEFAULT NULL,
  `motif` mediumtext DEFAULT NULL,
  `date_modification` datetime DEFAULT NULL,
  PRIMARY KEY (`rowid`),
  KEY `historique_rdv_rendez_vous_FK` (`fk_rendez_vous`),
  CONSTRAINT `historique_rdv_rendez_vous_FK` FOREIGN KEY (`fk_rendez_vous`) REFERENCES `llx_rendez_vous` (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;