CreatePolarNotificationsTable

Complexity

Total Complexity

2

Size/Duplication

Total Lines	25
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	3

Importance

Changes

0

<?php
class CreatePolarNotificationsTable extends Migration
{
    public function up()
    {
        Schema::create('polar_notifications', function (Blueprint $table) {
            $table->bigIncrements('id');

            $table->integer('user_id', false, true);
            $table->string('from')->default('system');
            $table->string('status', 10)->defaul('info');
            $table->text('body');
            $table->string('url')->nullable();
            $table->json('extra');
            $table->tinyInteger('read')->default(0);

            $table->timestamps();
            $table->index(['user_id', 'created_at']);
        });
    }

    public function down()
    {
        Schema::dropIfExists('polar_notifications');
    }
}