2021_08_12_080107_add_document_to_tasks_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 class AddDocumentToTasksTable extends Migration 8 { 9 /** 10 * Run the migrations. 11 * 12 * @return void 13 */ 14 public function up() 15 { 16 Schema::table('tasks', function (Blueprint $table) { 17 $table->foreignId('revision_id')->nullable()->constrained('revisions')->cascadeOnUpdate()->nullOnDelete(); 18 }); 19 } 20 21 /** 22 * Reverse the migrations. 23 * 24 * @return void 25 */ 26 public function down() 27 { 28 Schema::table('tasks', function (Blueprint $table) { 29 $table->dropColumn('revision_id'); 30 }); 31 } 32 }