Page MenuHomePhorge

2019_09_17_132012_create_user_settings_table.php
No OneTemporary

Authored By
Unknown
Size
1 KB
Referenced Files
None
Subscribers
None

2019_09_17_132012_create_user_settings_table.php

<?php
use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
// phpcs:ignore
class CreateUserSettingsTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create(
'user_settings',
function (Blueprint $table) {
$table->bigIncrements('id');
$table->bigInteger('user_id');
$table->string('key');
$table->string('value');
$table->timestamp('created_at')->useCurrent();
$table->timestamp('updated_at')->useCurrent();
$table->foreign('user_id')->references('id')->on('users')
->onDelete('cascade')->onUpdate('cascade');
$table->unique(['user_id', 'key']);
}
);
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('user_settings');
}
}

File Metadata

Mime Type
text/x-php
Expires
Sat, Apr 4, 8:30 AM (2 w, 3 d ago)
Storage Engine
local-disk
Storage Format
Raw Data
Storage Handle
91/e0/c797ba96f7f6cac1b3e2acbdc8ff
Default Alt Text
2019_09_17_132012_create_user_settings_table.php (1 KB)

Event Timeline