X-Git-Url: https://git.localhorst.tv/?a=blobdiff_plain;f=database%2Fmigrations%2F2024_04_09_122502_create_chat_bot_logs_table.php;fp=database%2Fmigrations%2F2024_04_09_122502_create_chat_bot_logs_table.php;h=3845b01ada0eb8c54cc330532088b6f21b8aa1a1;hb=ebdf8e5f6761de2abd85b01096a67dee62d7d4aa;hp=0000000000000000000000000000000000000000;hpb=bfc45b40d539431e465210e3ecf11367a42626ee;p=alttp.git

diff --git a/database/migrations/2024_04_09_122502_create_chat_bot_logs_table.php b/database/migrations/2024_04_09_122502_create_chat_bot_logs_table.php
new file mode 100644
index 0000000..3845b01
--- /dev/null
+++ b/database/migrations/2024_04_09_122502_create_chat_bot_logs_table.php
@@ -0,0 +1,31 @@
+<?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
+	{
+		Schema::create('chat_bot_logs', function (Blueprint $table) {
+			$table->id();
+			$table->timestamps();
+			$table->foreignId('channel_id')->constrained();
+			$table->foreignId('origin_id')->nullable()->default(null);
+			$table->string('origin_type')->nullable()->default(null);
+			$table->text('text');
+		});
+	}
+
+	/**
+	 * Reverse the migrations.
+	 */
+	public function down(): void
+	{
+		Schema::dropIfExists('chat_bot_logs');
+	}
+};