diff --git a/src/database/migrations/2021_03_25_144555_create_auth_attempts_table.php b/src/database/migrations/2021_03_25_144555_create_auth_attempts_table.php index 009fa335..d42c5e75 100644 --- a/src/database/migrations/2021_03_25_144555_create_auth_attempts_table.php +++ b/src/database/migrations/2021_03_25_144555_create_auth_attempts_table.php @@ -1,46 +1,50 @@ uuid('id')->primary(); - $table->bigInteger('user_id'); - $table->string('ip', 36); - $table->string('status', 36)->default('NEW'); - $table->string('reason', 36)->nullable(); - $table->datetime('expires_at')->nullable(); - $table->datetime('last_seen')->nullable(); - $table->timestamps(); + Schema::create( + 'auth_attempts', + function (Blueprint $table) { + $table->string('id', 36); + $table->bigInteger('user_id'); + $table->string('ip', 36); + $table->string('status', 36)->default('NEW'); + $table->string('reason', 36)->nullable(); + $table->datetime('expires_at')->nullable(); + $table->datetime('last_seen')->nullable(); + $table->timestamps(); - $table->index('updated_at'); - $table->unique(['user_id', 'ip']); + $table->primary('id'); + $table->index('updated_at'); + $table->unique(['user_id', 'ip']); - $table->foreign('user_id') - ->references('id')->on('users') - ->onDelete('cascade') - ->onUpdate('cascade'); - }); + $table->foreign('user_id') + ->references('id')->on('users') + ->onDelete('cascade') + ->onUpdate('cascade'); + } + ); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('auth_attempts'); } }