Файловый менеджер - Редактировать - /home/clickysoft/public_html/benchexc.clickysoft.net/database/migrations/2024_09_27_133324_create_opportunities_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('opportunities', function (Blueprint $table) { $table->id(); $table->unsignedBigInteger('user_id'); $table->unsignedBigInteger('company_id'); $table->unsignedBigInteger('city_id'); $table->string('title'); $table->integer('years_of_experience'); $table->string('pay_scale', 100); $table->string('opportunity_type',100); $table->string('working_model',100); $table->enum('rate_type', ['Hourly', 'Fixed', 'TBD'])->default('Hourly'); $table->string('rate', 100)->nullable(); $table->longText('description'); $table->date('application_deadline'); $table->boolean('status')->default(1); $table->timestamps(); $table->foreign('user_id')->references('id')->on('users')->onDelete('cascade'); $table->foreign('company_id')->references('id')->on('companies')->onDelete('cascade'); $table->foreign('city_id')->references('id')->on('cities')->onDelete('cascade'); }); } /** * Reverse the migrations. */ public function down(): void { Schema::dropIfExists('opportunities'); } };
| ver. 1.4 |
Github
|
.
| PHP 8.1.29 | Генерация страницы: 0 |
proxy
|
phpinfo
|
Настройка