From da5cc01782f2247feb08a3c2117dbe933ba7924f Mon Sep 17 00:00:00 2001
From: Daniel Karbach <daniel.karbach@localhorst.tv>
Date: Tue, 7 May 2024 15:08:41 +0200
Subject: [PATCH] merge old twitch zelda category into new

---
 ..._07_130124_replace_old_zelda_twitch_id.php | 26 +++++++++++++++++++
 1 file changed, 26 insertions(+)
 create mode 100644 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
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
+	{
+		//
+	}
+};
-- 
2.39.2