2023_03_05_100000_fs_relations_table.php
No OneTemporary
Actions

Size

1018 B

Referenced Files

None

Subscribers

None

2023_03_05_100000_fs_relations_table.php
View Options

	<?php

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

	return new class extends Migration
	{
	/**
	* Run the migrations.
	*
	* @return void
	*/
	public function up(): void
	{
	Schema::create(
	'fs_relations',
	function (Blueprint $table) {
	$table->bigIncrements('id');
	$table->string('item_id', 36);
	$table->string('related_id', 36);

	$table->foreign('item_id')->references('id')->on('fs_items')
	->onDelete('cascade');
	$table->foreign('related_id')->references('id')->on('fs_items')
	->onDelete('cascade');
	$table->unique(['item_id', 'related_id']);
	}
	);
	}

	/**
	* Reverse the migrations.
	*
	* @return void
	*/
	public function down(): void
	{
	Schema::dropIfExists('fs_relations');
	}
	};