mySQL errors

[mSnus]

Just had two errors:

1st) Migration failed because key types were not exactly the same (key and foreighn key).
Had to set correct type:
ALTER TABLEtbl_auth_assignmentCHANGEuser_id user_idint(11) NOT NULL AFTERitem_name;

2nd) Query failed because it was trying to compare keys with different collations, utf8_general and utf8_unicode. Fixed by casting to same type:
ALTER TABLEauth_item_groupCHANGEcode codevarchar(64) COLLATE 'utf8_unicode_ci' NOT NULL FIRST, CHANGEname namevarchar(255) COLLATE 'utf8_unicode_ci' NOT NULL AFTERcode;