CREATE TABLE IF NOT EXISTS `llx_avimm_constante_module` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `libelle` varchar(100) NOT NULL,
  `fk_logiciel` int(11) NOT NULL,
  `constante` varchar(100) DEFAULT NULL,
  `tarif` double(24,8) NOT NULL,
  `cahier_des_charges` mediumtext NOT NULL,
  `synthese_cdc` mediumtext NOT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `llx_avimm_constantemodules_unique` (`libelle`),
  KEY `llx_avimm_constante_module_llx_avimm_constante_logiciel_FK` (`fk_logiciel`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;