I find it strange that creating new tables using a script is not reflected in the connection view, regardless of refreshes (F5). If I disconnect and reconnect the changes are reflected.
I am a raw newbie with sql and databases, however, it seems odd that if I create a column with type INT that is reflected via the mySQL admin tool as INTEGER, and that this fact seems to cause problems when referring to a column as a foreign key. It appears to be type mismatch, even if the documentation seems to imply that INT and INTEGER are aliases.
The joys of learning a new system. Error reporting in SQL is as primitive as AWK and I have to say it could use some updating in that regard.