質問編集履歴

マイグレーションのファイルです

2019/11/19 14:43

投稿

m2B

スコア20

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -328,6 +328,160 @@
+```ここに言語を入力
+<?php
+use Illuminate\Support\Facades\Schema;
+use Illuminate\Database\Schema\Blueprint;
+use Illuminate\Database\Migrations\Migration;
+class CreateMainTasksTable extends Migration
+{
+    /**
+     * Run the migrations.
+     *
+     * @return void
+     */
+    public function up()
+    {
+        Schema::create('main_tasks', function (Blueprint $table) {
+            $table->increments('id');
+            $table->string('title', 20);
+            $table->timestamps();
+        });
+    }
+    /**
+     * Reverse the migrations.
+     *
+     * @return void
+     */
+    public function down()
+    {
+        Schema::dropIfExists('main_tasks');
+    }
+}
+```
+```ここに言語を入力
+<?php
+use Illuminate\Support\Facades\Schema;
+use Illuminate\Database\Schema\Blueprint;
+use Illuminate\Database\Migrations\Migration;
+class CreateTaskstable extends Migration
+{
+    /**
+     * Run the migrations.
+     *
+     * @return void
+     */
+    public function up()
+    {
+        Schema::create('tasks', function (Blueprint $table) {
+            $table->increments('id');
+            $table->integer('main_task_id')->unsigned();
+            $table->string('title', 100);
+            $table->date('due_date');
+            $table->integer('status')->default(1);
+            $table->timestamps();
+            // 外部キーを設定する
+            $table->foreign('main_task_id')->references('id')->on('main_tasks');
+        });
+    }
+    /**
+     * Reverse the migrations.
+     *
+     * @return void
+     */
+    public function down()
+    {
+        Schema::dropIfExists('tasks');
+    }
+}
+```