+global\CreateBooks::up()

Complexity

Conditions	1
Paths	1

Size

Total Lines

25

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
    public function up()
    {
        Schema::create('books', function (Blueprint $table) {
            $table->increments('id');
            $table->unsignedInteger('author_id');
            $table->unsignedInteger('publisher_id');
            $table->timestamps();

            $table->text('description')->nullable();
            $table->dateTime('published_at');
            $table->string('title');
            $table->decimal('price')->default(0);

            $table->foreign('author_id')
                ->references('id')
                ->on('authors')
                ->onUpdate('CASCADE')
                ->onDelete('CASCADE');
            $table->foreign('publisher_id')
                ->references('id')
                ->on('publishers')
                ->onUpdate('CASCADE')
                ->onDelete('CASCADE');
        });
    }
}