database/migrations/2018_06_30_203940_create_messages_table.php


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34

<?php

use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class CreateMessagesTable extends Migration
{
     /**
      * Run the migrations.
      *
      * @return void
      */
     public function up()
     {
         Schema::create('messages', function (Blueprint $table) {
             $table->increments('id');
             $table->integer('user_id')->unsigned();
             $table->text('message');
             $table->timestamps();

            $table->foreign('user_id')->references('id')->on('users');
         });
     }

    /**
      * Reverse the migrations.
      *
      * @return void
      */
     public function down()
     {
         Schema::drop('messages');
     }
}