CreateUsersOauthTable::down()   A
last analyzed

Complexity

Conditions 1
Paths 1

Size

Total Lines 7
Code Lines 4

Duplication

Lines 0
Ratio 0 %

Importance

Changes 0
Metric Value
dl 0
loc 7
rs 9.4285
c 0
b 0
f 0
cc 1
eloc 4
nc 1
nop 0
1
<?php
2
3
use Illuminate\Database\Schema\Blueprint;
4
use Illuminate\Database\Migrations\Migration;
5
6
class CreateUsersOauthTable extends Migration
7
{
8
    /**
9
     * Run the migrations.
10
     *
11
     * @return void
12
     */
13
    public function up()
14
    {
15
        Schema::create('users_oauth', function (Blueprint $table) {
16
            $table->increments('id');
17
            $table->unsignedInteger('user_id');
18
            $table->string('remote_provider', 32);
19
            $table->string('remote_id', 255);
20
            $table->string('nickname')->nullable();
21
            $table->string('name')->nullable();
22
            $table->string('email')->nullable();
23
            $table->string('avatar', 255)->nullable();
24
            $table->timestamps();
25
26
            $table->foreign('user_id')->references('id')->on('users')->onUpdate('cascade')->onDelete('cascade');
27
        });
28
    }
29
30
    /**
31
     * Reverse the migrations.
32
     *
33
     * @return void
34
     */
35
    public function down()
36
    {
37
        Schema::table('users_oauth', function (Blueprint $table) {
38
            $table->dropForeign('users_oauth_user_id_foreign');
39
        });
40
        Schema::drop('users_oauth');
41
    }
42
}
43