source: database/migrations/2019_10_17_152805_create_comments_table.php@ 0924b6c

Last change on this file since 0924b6c was 0924b6c, checked in by Özkan İliyaz <iliyaz_96@…>, 4 years ago

initial commit

  • Property mode set to 100644
File size: 988 bytes
Line 
1<?php
2
3use Illuminate\Support\Facades\Schema;
4use Illuminate\Database\Schema\Blueprint;
5use Illuminate\Database\Migrations\Migration;
6
7class CreateCommentsTable extends Migration
8{
9 /**
10 * Run the migrations.
11 *
12 * @return void
13 */
14 public function up()
15 {
16 Schema::create('comments', function (Blueprint $table) {
17 $table->increments('id');
18 $table->integer("post_id")->unsigned();
19 $table->foreign("post_id")->references("id")->on("posts")->onDelete("cascade")->onUpdate("cascade");
20 $table->string("name");
21 $table->string("email");
22 $table->text("comment");
23 $table->boolean("is_active")->default(false);
24 $table->dateTime("confirmed_date")->nullable();
25 $table->timestamps();
26 });
27 }
28
29 /**
30 * Reverse the migrations.
31 *
32 * @return void
33 */
34 public function down()
35 {
36 Schema::dropIfExists('comments');
37 }
38}
Note: See TracBrowser for help on using the repository browser.