Файловый менеджер - Редактировать - /home/clickysoft/public_html/assets.clickysoft.net/database/migrations/2024_12_20_095106_create_tickets_table.php
Назад
<?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('tickets', function (Blueprint $table) { $table->id(); $table->foreignId('organization_id')->constrained("organizations")->onDelete('cascade')->onUpdate('cascade'); $table->foreignId('user_id')->constrained("users")->onDelete('cascade')->onUpdate('cascade'); $table->foreignId('tag_id')->nullable()->constrained("asset_tags")->onDelete('cascade')->onUpdate('cascade'); $table->string('subject'); $table->text('message'); $table->enum('status', ['open', 'pending', 'closed'])->comment('open, pending, closed')->default('open'); $table->enum('priority', ['low', 'medium', 'high'])->comment('low, medium, high')->default('medium'); $table->foreignId('assigned_to')->nullable()->constrained("users")->onDelete('set null')->onUpdate('cascade'); $table->string('attachment')->nullable(); $table->timestamps(); }); } /** * Reverse the migrations. */ public function down(): void { Schema::dropIfExists('tickets'); } };
| ver. 1.4 |
Github
|
.
| PHP 8.1.29 | Генерация страницы: 0 |
proxy
|
phpinfo
|
Настройка