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 }