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

<?php

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

return new class extends Migration {
    public function up(): void
    {
        Schema::create('site_realtime_events', function (Blueprint $t) {
            $t->id(); $t->string('module', 16); $t->unsignedBigInteger('resource_id');
            $t->string('action', 16); $t->dateTime('available_at'); $t->dateTime('dispatched_at')->nullable();
            $t->dateTime('created_at');
            $t->index(['dispatched_at', 'available_at'], 'site_realtime_pending');
            $t->index(['module', 'resource_id'], 'site_realtime_resource');
        });
    }

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