   `type` int(11) NOT NULL,
   `create_date` datetime NOT NULL,
   `plugin_fusioninventory_deploypackages_id` int(11) NOT NULL,
-  `json` TEXT DEFAULT NULL,
+  `json` text DEFAULT NULL,
   PRIMARY KEY (`id`),
   KEY `type` (`type`),
   KEY `create_date` (`create_date`),

CREATE TABLE `glpi_plugin_fusioninventory_deploymirrors` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `entities_id` int(11) NOT NULL,
  `is_recursive` tinyint(1) NOT NULL DEFAULT 0,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `url` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `comment` text DEFAULT NULL,

  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `comment` text DEFAULT NULL,
  `entities_id` int(11) NOT NULL,
  `is_recursive` tinyint(1) NOT NULL DEFAULT '0',
  `date_mod` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `entities_id` (`entities_id`),
