This is the schema after some changes in June 2014 for allowing different ID types and then changing to utf8mb4 due to data import problems
commented out drop and create statements for tables not used.  Removed the name fields from the new article_meshterm table