Error Installing OCSinventory Plugin SQL STRING

[jmldsilva]

Hello, when installing this plugin I received this error:

• Erro durante a consulta da base de dados: INSERT INTO glpi_notificationtemplates VALUES (NULL, 'Computers not imported', 'PluginOcsinventoryngNotimportedcomputer', NOW(), '', NULL, NOW()); - Erro é Incorrect integer value: 'Computers not imported' for column 'id' at row 1

• The version of the plugin :2.0.2

• The version of your GLPI: 10.0.3

[joaoarquimedes]

Adjust the column sequence in the glpi_notificationtemplates table:

ALTER TABLE glpi_notificationtemplates MODIFY COLUMN id int(10) unsigned NOT NULL AUTO_INCREMENT FIRST;
ALTER TABLE glpi_notificationtemplates MODIFY COLUMN name varchar(255) AFTER id;
ALTER TABLE glpi_notificationtemplates MODIFY COLUMN itemtype varchar(100) NOT NULL AFTER name;
ALTER TABLE glpi_notificationtemplates MODIFY COLUMN date_mod timestamp AFTER itemtype;
ALTER TABLE glpi_notificationtemplates MODIFY COLUMN comment text AFTER date_mod;
ALTER TABLE glpi_notificationtemplates MODIFY COLUMN css text AFTER comment;
ALTER TABLE glpi_notificationtemplates MODIFY COLUMN date_creation timestamp AFTER css;