<?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; class CreateSessionTable extends Migration { /** * Run the migrations. * * @return void */ public function up() { Schema::connection('mysql')->create('sessions', function ($table) { $table->string('id')->primary(); $table->foreignId('user_id')->nullable()->index(); $table->string('ip_address', 45)->nullable(); $table->text('user_agent')->nullable(); $table->text('payload'); $table->integer('last_activity')->index(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('session'); } }