CosmicRadioTV\Podcast\updates\CreateEpisodesTable

Complexity

Total Complexity

2

Size/Duplication

Total Lines	39
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	0

Importance

Changes	1
Bugs	0	Features	0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	up()	0	22	1
A	down()	0	6	1

<?php

namespace CosmicRadioTV\Podcast\updates;

use DB;
use Illuminate\Database\Schema\Blueprint;
use October\Rain\Database\Updates\Migration;
use Schema;

class CreateEpisodesTable extends Migration
{

    /**
     * Migration
     */
    public function up()
    {
        DB::transaction(function () {
            Schema::create('cosmicradiotv_podcast_episodes', function (Blueprint $table) {
                $table->engine = 'InnoDB';
                $table->increments('id');
                $table->unsignedInteger('show_id');
                $table->string('title');
                $table->string('slug');
                $table->text('summary')->nullable();
                $table->text('content')->nullable();
                $table->integer('length');
                $table->dateTime('release')->nullable();
                $table->boolean('published')->default(false);
                $table->timestamps();

                $table->foreign('show_id')->references('id')->on('cosmicradiotv_podcast_shows')
                      ->onUpdate('cascade');
                $table->unique(['show_id', 'slug']);
            });
        });
    }

    /**
     * Rollback
     */
    public function down()
    {
        DB::transaction(function () {
            Schema::drop('cosmicradiotv_podcast_episodes');
        });
    }
}