1  <?php
 2  
 3  use Illuminate\Database\Migrations\Migration;
 4  use Illuminate\Database\Schema\Blueprint;
 5  use Illuminate\Support\Facades\DB;
 6  use Illuminate\Support\Facades\Schema;
 7  
 8  class CreateValidationStatusesTable extends Migration
 9  {
10      /**
11       * Run the migrations.
12       *
13       * @return void
14       */
15      public function up()
16      {
17          Schema::create('validation_statuses', function (Blueprint $table) {
18              $table->id();
19              $table->string('name')->unique();
20              $table->timestamps();
21              $table->softDeletes();
22          });
23  
24          DB::table('validation_statuses')->insert([
25              [
26                  'id' => 1,
27                  'name' => 'Pending',
28              ],
29              [
30                  'id' => 2,
31                  'name' => 'In process',
32              ],
33              [
34                  'id' => 3,
35                  'name' => 'No pass',
36              ],
37              [
38                  'id' => 4,
39                  'name' => 'Pass',
40              ],
41          ]);
42      }
43  
44      /**
45       * Reverse the migrations.
46       *
47       * @return void
48       */
49      public function down()
50      {
51          Schema::dropIfExists('validation_statuses');
52      }
53  }