How to insert a new column into mysql field data table?
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