Check user status type to be varchar(255) ACTIVE

caleeli · caleeli · commit bbb131b35725 · 2023-12-22T19:25:05.000-04:00
diff --git a/database/migrations/2023_12_18_104245_check_fix_status_at_users_table.php b/database/migrations/2023_12_18_104245_check_fix_status_at_users_table.php
@@ -0,0 +1,32 @@
+<?php
+
+use Illuminate\Database\Migrations\Migration;
+use Illuminate\Support\Facades\DB;
+
+return new class extends Migration {
+    /**
+     * Run the migrations.
+     */
+    public function up(): void
+    {
+        $isMysql = DB::getDriverName() === 'mysql';
+        if (!$isMysql) {
+            return;
+        }
+        // check if the column status is of type enum
+        $column = DB::selectOne('SHOW COLUMNS FROM users WHERE Field = "status"');
+        $isEnum = substr($column->Type, 0, 4) === 'enum';
+        if (!$isEnum) {
+            return;
+        }
+        // change the column status to varchar
+        DB::statement('ALTER TABLE users MODIFY COLUMN status VARCHAR(255) NOT NULL DEFAULT "ACTIVE"');
+    }
+
+    /**
+     * Reverse the migrations.
+     */
+    public function down(): void
+    {
+    }
+};
