Completed
Push — master ( 04b5b1...93006a )
by Ben
02:22
created

CreateProductsTable::up()   A

Complexity

Conditions 1
Paths 1

Size

Total Lines 11
Code Lines 9

Duplication

Lines 0
Ratio 0 %

Importance

Changes 0
Metric Value
cc 1
eloc 9
nc 1
nop 0
dl 0
loc 11
rs 9.4285
c 0
b 0
f 0
1
<?php
2
3
use Illuminate\Support\Facades\Schema;
4
use Illuminate\Database\Schema\Blueprint;
5
use Illuminate\Database\Migrations\Migration;
6
7
class CreateProductsTable extends Migration
8
{
9
    /**
10
     * Run the migrations.
11
     *
12
     * @return void
13
     */
14
    public function up()
15
    {
16
        Schema::create('products', function (Blueprint $table) {
17
            $table->increments('id');
18
            $table->string('title');
19
            $table->string('description')->nullable();
20
            $table->string('seo_title')->nullable();
21
            $table->string('seo_description')->nullable();
22
            $table->timestamp('published_at')->nullable();
23
            $table->timestamp('deleted_at')->nullable();
24
            $table->timestamps();
25
        });
26
    }
27
28
    /**
29
     * Reverse the migrations.
30
     *
31
     * @return void
32
     */
33
    public function down()
34
    {
35
        if(DB::getDriverName() == 'sqlite'){
36
            $off = 'PRAGMA foreign_keys = OFF';
37
            $on = 'PRAGMA foreign_keys = ON';
38
        }
39
        else{
40
            $off = 'SET FOREIGN_KEY_CHECKS = 0';
41
            $on = 'SET FOREIGN_KEY_CHECKS = 1';
42
        }
43
44
        DB::statement($off);
45
        Schema::dropIfExists('products');
46
        DB::statement($on);
47
    }
48
}
49