/ database / migrations / 2022_01_03_114309_create_validation_requirement_statuses_table.php
2022_01_03_114309_create_validation_requirement_statuses_table.php
 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 CreateValidationRequirementStatusesTable extends Migration
 9  {
10      /**
11       * Run the migrations.
12       *
13       * @return void
14       */
15      public function up()
16      {
17          Schema::create('validation_requirement_statuses', function (Blueprint $table) {
18              $table->id();
19              $table->string('name')->unique();
20              $table->timestamps();
21              $table->softDeletes();
22          });
23  
24          DB::table('validation_requirement_statuses')->insert([
25              [
26                  'id' => 1,
27                  'name' => 'No pass',
28              ],
29              [
30                  'id' => 2,
31                  'name' => 'Pass',
32              ],
33          ]);
34      }
35  
36      /**
37       * Reverse the migrations.
38       *
39       * @return void
40       */
41      public function down()
42      {
43          Schema::dropIfExists('validation_requirement_statuses');
44      }
45  }