Файловый менеджер - Редактировать - /home/clickysoft/public_html/furfotos.clickysoft.net/database/migrations/2021_09_04_174301_create_family_table.php
Назад
<?php use App\Models\Family; use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; class CreateFamilyTable extends Migration { public function up() { Schema::create('families', function (Blueprint $table) { $table->bigIncrements('id'); $table->foreignId('owner_user_id') ->nullable() ->references('id') ->on('users') ->cascadeOnDelete(); $table->string('name'); $table->timestamps(); $table->softDeletes(); }); Schema::create('user_families', function (Blueprint $table) { $table->foreignId('user_id') ->references('id') ->on('users') ->cascadeOnDelete(); $table->foreignId('family_id') ->references('id') ->on('families') ->cascadeOnDelete(); $table->enum('family_type', [ Family::TYPE_FAMILY, Family::TYPE_FRIEND, ]) ->default(Family::TYPE_FRIEND); $table->boolean('accepted')->default(false); }); Schema::table('users', function (Blueprint $table) { $table->foreignId('selected_family_id') ->nullable() ->references('id') ->on('families') ->cascadeOnDelete(); }); } public function down() { Schema::dropIfExists('user_families'); Schema::dropIfExists('families'); Schema::table('users', function (Blueprint $table) { $table->dropForeign(['selected_family_id']); $table->dropColumn('selected_family_id'); }); } }
| ver. 1.4 |
Github
|
.
| PHP 8.1.29 | Генерация страницы: 0 |
proxy
|
phpinfo
|
Настройка