Differential D1408 Diff 3739 src/database/migrations/2019_09_17_132012_create_user_settings_table.php

Changeset View

Standalone View

Show All 15 Lines	class CreateUserSettingsTable extends Migration
{		{
Schema::create(		Schema::create(
'user_settings',		'user_settings',
function (Blueprint $table) {		function (Blueprint $table) {
$table->bigIncrements('id');		$table->bigIncrements('id');
$table->bigInteger('user_id');		$table->bigInteger('user_id');
$table->string('key');		$table->string('key');
$table->string('value');		$table->string('value');
$table->timestamps();		$table->timestamp('created_at')->useCurrent();
		$table->timestamp('updated_at')->useCurrent();

$table->foreign('user_id')->references('id')->on('users')		$table->foreign('user_id')->references('id')->on('users')
->onDelete('cascade')->onUpdate('cascade');		->onDelete('cascade')->onUpdate('cascade');

$table->unique(['user_id', 'key']);		$table->unique(['user_id', 'key']);
}		}
);		);
}		}
Show All 11 Lines