Welcome to OCS Inventory NG community support, where you can ask questions and receive answers from other members of the community.

Please ask questions only in English or French.

Release 2.12.3 available

The official documentation can be found on https://wiki.ocsinventory-ng.org. Read it before asking your question.

modification to a table in the DB

Actually, I would like to up all the softwares+ (name, link, caterories...) ID from INT to UNSIGNED BIGINT...

How can I propose that,. and to who ?
in OCS Inventory NG server for Windows by (310 points)

1 Answer

+1 vote
 
Best answer

in files/updates/7053.sql you have (part of)

ALTER TABLE software MODIFY COLUMN ID BIGINT(20) NOT NULL AUTO_INCREMENT;

ALTER TABLE software_link MODIFY COLUMN ID BIGINT(20) NOT NULL AUTO_INCREMENT;

ALTER TABLE software_categories_link MODIFY COLUMN ID BIGINT(20) NOT NULL AUTO_INCREMENT;

This upgrade of database is for 2.9.2 (2.9.1 = 7051 and 2.9.2 = 7057).

These modifications are made by development team aka FactorFX ...

by (20.1k points)
selected by
 
Powered by Question2Answer
...