<commit_before>DROP TABLE IF EXISTS `glpi_plugin_fusinvinventory_computers`;

CREATE TABLE `glpi_plugin_fusinvinventory_computers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `items_id` int(11) NOT NULL default '0',
  `uuid` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `items_id` (`items_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `glpi_plugin_fusinvinventory_criterias`;

CREATE TABLE `glpi_plugin_fusinvinventory_criterias` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `comment` text COLLATE utf8_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `name` (`name`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `glpi_plugin_fusinvinventory_libserialization`;

CREATE TABLE `glpi_plugin_fusinvinventory_libserialization` (
  `internal_id` varchar(255) NOT NULL,
  `computers_id` int(50) DEFAULT NULL,
  `serialized_sections1` longtext,
  `serialized_sections2` longtext,
  `serialized_sections3` longtext,
  `hash` varchar(128) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `last_fusioninventory_update` datetime DEFAULT NULL,
  PRIMARY KEY (`internal_id`),
  KEY `computers_id` (`computers_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;



DROP TABLE IF EXISTS `glpi_plugin_fusinvinventory_blacklists`;

CREATE TABLE IF NOT EXISTS `glpi_plugin_fusinvinventory_blacklists` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `plugin_fusioninventory_criterium_id` int(11) NOT NULL DEFAULT '0',
  `value` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `glpi_plugin_fusinvinventory_antivirus`;

CREATE TABLE IF NOT EXISTS `glpi_plugin_fusinvinventory_antivirus` (
  `id` int(11) NOT NULL AUTO_INCREMENT,<commit_msg>Add index for fusioninventory last update<commit_after>DROP TABLE IF EXISTS `glpi_plugin_fusinvinventory_computers`;

CREATE TABLE `glpi_plugin_fusinvinventory_computers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `items_id` int(11) NOT NULL default '0',
  `uuid` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `items_id` (`items_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `glpi_plugin_fusinvinventory_criterias`;

CREATE TABLE `glpi_plugin_fusinvinventory_criterias` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `comment` text COLLATE utf8_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `name` (`name`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `glpi_plugin_fusinvinventory_libserialization`;

CREATE TABLE `glpi_plugin_fusinvinventory_libserialization` (
  `internal_id` varchar(255) NOT NULL,
  `computers_id` int(50) DEFAULT NULL,
  `serialized_sections1` longtext,
  `serialized_sections2` longtext,
  `serialized_sections3` longtext,
  `hash` varchar(128) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `last_fusioninventory_update` datetime DEFAULT NULL,
  PRIMARY KEY (`internal_id`),
  KEY `computers_id` (`computers_id`),
  KEY `last_fusioninventory_update` (`last_fusioninventory_update`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;



DROP TABLE IF EXISTS `glpi_plugin_fusinvinventory_blacklists`;

CREATE TABLE IF NOT EXISTS `glpi_plugin_fusinvinventory_blacklists` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `plugin_fusioninventory_criterium_id` int(11) NOT NULL DEFAULT '0',
  `value` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `glpi_plugin_fusinvinventory_antivirus`;

CREATE TABLE IF NOT EXISTS `glpi_plugin_fusinvinventory_antivirus` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
{'fraction_non_alphanumeric': 0.08982035928143713, 'fraction_numerical': 0.023952095808383235, 'mean_word_length': 7.020876826722338, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '1212935', 'n_tokens_mistral': 1559, 'n_tokens_neox': 1425, 'n_words': 327}