CREATE TABLE IF NOT EXISTS `llx_avimm_constante` (
  `rowid` int(11) NOT NULL AUTO_INCREMENT,
  `libelle` varchar(100) NOT NULL,
  `valeur` varchar(255) NOT NULL,
  `dependance_sql` mediumtext DEFAULT NULL,
  `description` mediumtext DEFAULT NULL,
  `debase` tinyint(1) NOT NULL DEFAULT 0,
  `cahier_des_charges` mediumtext DEFAULT NULL,
  `tarif` double(24,8) NOT NULL,
  PRIMARY KEY (`rowid`),
  UNIQUE KEY `llx_contanteliste_unique` (`libelle`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;