diff --git a/src/database/migrations/2019_11_12_220840_drop_groups_table.php b/src/database/migrations/2019_11_12_220840_drop_groups_table.php
index <HASH>..<HASH> 100644
--- a/src/database/migrations/2019_11_12_220840_drop_groups_table.php
+++ b/src/database/migrations/2019_11_12_220840_drop_groups_table.php
@@ -215,14 +215,15 @@ class DropGroupsTable extends Migration
             'updated_at'        => carbon(),
         ]);
 
-        $id = 0;
-        DB::table('users')->get()->each(function ($user) use (&$id) {
-            //$id++;
-            DB::table('users')
-                ->where('main_character_id', $user->main_character_id)
-                ->update([
-                    'id' => ++$id,
-                ]);
+        DB::table('users')
+            ->whereNull('id')
+            ->get()
+            ->each(function ($user, $key) {
+                DB::table('users')
+                    ->where('main_character_id', $user->main_character_id)
+                    ->update([
+                        'id' => ($key + 2),
+                    ]);
         });
 
         // switch id field from simple integer to auto-increment field
fix: ensure users table is starting with ID 2