Fix. Migration didn't work when adding the foreign key 'role_id' in the users table. The column 'role_id' should be added as an unsigned integer in the user table.