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