bot-28/database/migrations/2026_10_31_160000_create_admin_realtime_events.php

<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

/** 后台实时推送事件表：bot-28 与 melbet_sport-api 均可写入，推送网关按 id 递增消费。 */
return new class extends Migration {
    public function up(): void
    {
        Schema::create('admin_realtime_events', function (Blueprint $t) {
            $t->id(); $t->string('resource', 32); $t->string('resource_id', 64);
            $t->string('action', 16); $t->string('source', 32)->default('bot-28');
            $t->dateTime('created_at');
            $t->index('created_at', 'admin_realtime_created');
        });
    }

    public function down(): void { Schema::dropIfExists('admin_realtime_events'); }
};