New field created is located in which table?

Question

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!

Answer 1

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 ...