+global\CreateNotificationsTable::up()

Complexity

Conditions	1
Paths	1

Size

Total Lines	18
Code Lines	14

Duplication

Lines	0
Ratio	0 %

Importance

Changes	2
Bugs	1	Features	1

<?php
    public function up()
    {
        Schema::create('notifications', function (Blueprint $table) {
            $table->increments('id');
            $table->bigInteger('from_id')->index()->unsigned();
            $table->string('from_type')->index()->nullable();
            $table->bigInteger('to_id')->index()->unsigned();
            $table->string('to_type')->index()->nullable();
            $table->integer('category_id')->index()->unsigned();
            $table->string('url');
            $table->string('extra')->nullable();
            $table->tinyInteger('read')->default(0);
            $table->timestamps();

            $table->foreign('category_id')->references('id')
                  ->on('notification_categories');
        });
    }