CreateRedirectsTable::down()   A
last analyzed

Complexity

Conditions 1
Paths 1

Size

Total Lines 3
Code Lines 1

Duplication

Lines 0
Ratio 0 %

Importance

Changes 0
Metric Value
cc 1
eloc 1
nc 1
nop 0
dl 0
loc 3
rs 10
c 0
b 0
f 0
1
<?php
2
3
use Illuminate\Database\Migrations\Migration;
4
use Illuminate\Database\Schema\Blueprint;
5
use Illuminate\Support\Facades\Schema;
6
7
class CreateRedirectsTable extends Migration
8
{
9
    /**
10
     * Run the migrations.
11
     *
12
     * @return void
13
     */
14
    public function up()
15
    {
16
        Schema::create('redirects', function (Blueprint $table) {
17
            $table->bigIncrements('id');
18
19
            $connection = config('database.default');
20
21
            $collation = explode('_', $table->collation ?: config("database.connections.{$connection}.collation", 'utf8mb4_unicode_ci'), 2)[0] ?: 'utf8mb4';
22
23
            $table->string('old_url')->collation($collation.'_bin')->unique();
24
            $table->string('new_url')->collation($collation.'_bin')->nullable();
25
            $table->smallInteger('status')->default(301)->index();
26
27
            $table->timestamps();
28
        });
29
    }
30
31
    /**
32
     * Reverse the migrations.
33
     *
34
     * @return void
35
     */
36
    public function down()
37
    {
38
        Schema::dropIfExists('redirects');
39
    }
40
}
41