2021_12_02_170506_create_task_comments_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 CreateTaskCommentsTable extends Migration 8 { 9 /** 10 * Run the migrations. 11 * 12 * @return void 13 */ 14 public function up() 15 { 16 Schema::create('task_comments', function (Blueprint $table) { 17 $table->id(); 18 $table->foreignId('user_id')->nullable()->constrained('users')->cascadeOnUpdate()->nullOnDelete(); 19 $table->foreignId('task_id')->nullable()->constrained('tasks')->cascadeOnUpdate()->nullOnDelete(); 20 $table->text('comment'); 21 $table->timestamps(); 22 $table->softDeletes(); 23 }); 24 } 25 26 /** 27 * Reverse the migrations. 28 * 29 * @return void 30 */ 31 public function down() 32 { 33 Schema::dropIfExists('task_comments'); 34 } 35 }