table FK and indexes are case-sensitive, need to remove and re-add FK
for to messagetypes