switch email to a primary key (#6064)

browner12 · web-flow · commit 091aa7d8823c · 2023-01-02T08:45:35.000-06:00
switching from a normal index here to a primary index works the same except for adding a `UNIQUE` constraint. The `DatabaseTokenRepository` deletes existing records with an email first, before creating a new one, so this additional constraint will be okay. https://github.com/laravel/framework/blob/9.x/src/Illuminate/Auth/Passwords/DatabaseTokenRepository.php#L88
diff --git a/database/migrations/2014_10_12_100000_create_password_resets_table.php b/database/migrations/2014_10_12_100000_create_password_resets_table.php
@@ -14,7 +14,7 @@
     public function up()
     {
         Schema::create('password_resets', function (Blueprint $table) {
-            $table->string('email')->index();
+            $table->string('email')->primary();
             $table->string('token');
             $table->timestamp('created_at')->nullable();
         });

Original file line number	Diff line number	Diff line change
`@@ -14,7 +14,7 @@`
`14`	`14`	`public function up()`
`15`	`15`	`{`
`16`	`16`	`Schema::create('password_resets', function (Blueprint $table) {`
`17`		`- $table->string('email')->index();`
	`17`	`+ $table->string('email')->primary();`
`18`	`18`	`$table->string('token');`
`19`	`19`	`$table->timestamp('created_at')->nullable();`
`20`	`20`	`});`