merge old twitch zelda category into new

[alttp.git] / database / migrations / 2024_05_07_130124_replace_old_zelda_twitch_id.php

diff --git a/database/migrations/2024_05_07_130124_replace_old_zelda_twitch_id.php b/database/migrations/2024_05_07_130124_replace_old_zelda_twitch_id.php
new file mode 100644 (file)
index 0000000..eccd696
--- /dev/null
+++ b/database/migrations/2024_05_07_130124_replace_old_zelda_twitch_id.php
@@ -0,0 +1,26 @@
+<?php
+
+use Illuminate\Database\Migrations\Migration;
+use Illuminate\Database\Schema\Blueprint;
+use Illuminate\Support\Facades\Schema;
+
+return new class extends Migration
+{
+       /**
+        * Run the migrations.
+        */
+       public function up(): void
+       {
+               DB::table('chat_logs')
+                       ->where('twitch_category', '=', '899559811')
+                       ->update(['twitch_category' => '9435']);
+       }
+
+       /**
+        * Reverse the migrations.
+        */
+       public function down(): void
+       {
+               //
+       }
+};