forged-plugs/tickets/database/migrations/002_create_ticket_messages_table.php
Pelican Installer Bot a43d377930 feat: forged-plugs — 17 plugins for Forge Panel
Separated from pelican-dev/plugins, rebranded for Forge.
Includes manifest.json for in-panel store browsing.
2026-05-17 13:43:33 +00:00

31 lines
872 B
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('ticket_messages', function (Blueprint $table) {
$table->increments('id');
$table->text('message')->nullable();
$table->boolean('hidden')->default(false);
$table->unsignedInteger('ticket_id');
$table->foreign('ticket_id')->references('id')->on('tickets')->cascadeOnDelete();
$table->unsignedInteger('author_id')->nullable();
$table->foreign('author_id')->references('id')->on('users')->nullOnDelete();
$table->timestamps();
});
}
public function down(): void
{
Schema::dropIfExists('ticket_messages');
}
};