Completed
Push — master ( 12e529...b07676 )
by Travis
02:18
created

CreateUserSocialTable::up()   A

Complexity

Conditions 1
Paths 1

Size

Total Lines 18
Code Lines 13

Duplication

Lines 0
Ratio 0 %

Importance

Changes 1
Bugs 0 Features 0
Metric Value
c 1
b 0
f 0
dl 0
loc 18
rs 9.4285
cc 1
eloc 13
nc 1
nop 0
1
<?php
2
3
use Illuminate\Database\Migrations\Migration;
4
use Illuminate\Database\Schema\Blueprint;
5
use Illuminate\Support\Facades\DB;
6
7
class CreateUserSocialTable extends Migration
8
{
9
    /**
10
     * Run the migrations.
11
     *
12
     * @return void
13
     */
14
    public function up()
15
    {
16
        Schema::create('user_socials', function (Blueprint $table) {
17
            $table->increments('id');
18
            $table->integer('user_id')->unsigned();
19
            $table->string('provider');
20
            $table->string('social_id')->index();
21
            $table->string('avatar')->nullable();
22
            $table->timestamps();
23
24
            $table->foreign('user_id')
25
                  ->references('id')
26
                  ->on('users')
27
                  ->onDelete('cascade');
28
        });
29
30
        DB::statement('ALTER TABLE `users` MODIFY `password` VARCHAR(64);');
31
    }
32
33
    /**
34
     * Reverse the migrations.
35
     *
36
     * @return void
37
     */
38
    public function down()
39
    {
40
        Schema::drop('user_socials');
41
42
        if (DB::table('users')->count() === 0) {
43
            DB::statement('ALTER TABLE `users` MODIFY `password` VARCHAR(64) NOT NULL;');
44
        }
45
    }
46
}
47