pluginsGLPI / ocsinventoryng

Plugin ocsinventoryng for GLPI
GNU General Public License v2.0
67 stars 52 forks source link

Winupdate import : Adapt database model to the new plugin version #280

Open RudyLaurent opened 3 years ago

RudyLaurent commented 3 years ago

Hi,

When I import my computer with Winupdate import activated, the winupdate data were not imported. There is a new version of Winupdate and the data in DB changed.

In this PR, I updated the files with the new data but I didn't implemented the migration.

You will find below the new table structure :

DROP TABLE IF EXISTS `glpi_plugin_ocsinventoryng_winupdates`;
CREATE TABLE `glpi_plugin_ocsinventoryng_winupdates` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `computers_id` int(11) NOT NULL DEFAULT '0',
  `kb` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `date` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `operation` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `status` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `supportlink` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `computers_id` (`computers_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

I remain available if you need anything else.

Regards, Rudy LAURENT

ajavor commented 2 years ago

Hi

I applied your changes and the plugin imports only one item (exactly the first on the list in ocs) windows update.