/ database / migrations / 2021_08_11_114303_create_meet_statuses_table.php
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  }