ocsinventoryng
ocsinventoryng copied to clipboard
Winupdate import : Adapt database model to the new plugin version
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
Hi
I applied your changes and the plugin imports only one item (exactly the first on the list in ocs) windows update.