You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
In a MySQL database, the id field type in the achievement_details table is UNSIGNED BIG INT because the $table->id(); command generates an unsigned big int field.
// This generates an UNSIGNED BIG INT column.$table->id();
In the achievement_progress table, the achievement_id field is created as:
$table->unsignedInteger('achievement_id');
That causes a mismatch and MySQL won't create the foreign key.
It should be:
$table->unsignedBigInteger('achievement_id');
The text was updated successfully, but these errors were encountered:
mstralka
added a commit
to mobilelocker/laravel-achievements
that referenced
this issue
Jul 25, 2022
In a MySQL database, the
id
field type in theachievement_details
table isUNSIGNED BIG INT
because the$table->id();
command generates an unsigned big int field.In the
achievement_progress table
, theachievement_id
field is created as:That causes a mismatch and MySQL won't create the foreign key.
It should be:
The text was updated successfully, but these errors were encountered: