BookStack Code Mirror - bookstack/blob - database/migrations/2022_08_17_092941_create_references_table.php

   1 <?php
   2
   3 use Illuminate\Database\Migrations\Migration;
   4 use Illuminate\Database\Schema\Blueprint;
   5 use Illuminate\Support\Facades\Schema;
   6
   7 return new class extends Migration
   8 {
   9     /**
  10      * Run the migrations.
  11      */
  12     public function up(): void
  13     {
  14         Schema::create('references', function (Blueprint $table) {
  15             $table->id();
  16             $table->unsignedInteger('from_id')->index();
  17             $table->string('from_type', 25)->index();
  18             $table->unsignedInteger('to_id')->index();
  19             $table->string('to_type', 25)->index();
  20         });
  21     }
  22
  23     /**
  24      * Reverse the migrations.
  25      */
  26     public function down(): void
  27     {
  28         Schema::dropIfExists('references');
  29     }
  30 };