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 http://wiki.ocsinventory-ng.org. Read it before asking your question.

New field created is located in which table?

Hi,

When I add the new field through Manage -> Administrative data, in which table the new field/column is created?

If I try to look at the database through mysql terminal where will I find the new field/column?

Thank you!
in Core server development by (120 points)

1 Answer

0 votes
The fields of Administrative Data are registered in table 'accountinfo_config', with 'ID', 'name', 'type', 'comment', 'show_order', ...

For their values for each hardware, you have the table 'accountinfo' with fields named as 'fields_xx' where xx is the value of column 'ID' from 'accountinfo_config'.

NB : be carefull when you update values of Administrative Data directly using sql command ...
by (19.8k points)
edited by
 
Powered by Question2Answer
...