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

  KEY `entities_id` (`entities_id`),
  KEY `date_mod` (`date_mod`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1;



DROP TABLE IF EXISTS `glpi_plugin_fusioninventory_deployfiles_mirrors`;

CREATE TABLE `glpi_plugin_fusioninventory_deployfiles_mirrors` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `plugin_fusioninventory_deployfiles_id` int(11) NOT NULL,
  `plugin_fusioninventory_deploymirrors_id` int(11) NOT NULL,
  `ranking` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `plugin_fusioninventory_deployfiles_id` (`plugin_fusioninventory_deployfiles_id`),
  KEY `plugin_fusioninventory_deploymirrors_id` (`plugin_fusioninventory_deploymirrors_id`)
) ENGINE = MYISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1;



DROP TABLE IF EXISTS `glpi_plugin_fusioninventory_deploymirrors`;

  PRIMARY KEY (`id`),
  KEY `entities_id` (`entities_id`),
  KEY `date_mod` (`date_mod`)
) ENGINE = MYISAM CHARACTER SET utf8 COLLATE utf8_unicode_ci AUTO_INCREMENT=1;


