How to insert a new column into mysql field data table?

Question

How would I insert a new column into mysql field data table? For example, if I have a field (myfield) with the mysql table field_data_field_myfield having the following columns'entity_type', 'entity_id', 'revision_id', 'bundle', 'delta', 'language', 'myfield_value' and 'myfield_format'...how could I add the column mynewcolumn as type varchar?

Answer 1

For adding new column in table, please check this discussion Correct way to add custom column to user table?.

Please check this discussion also https://www.drupal.org/node/2616250