CosmicRadioTV\Podcast\updates\CreateEpisodesTable::up()

Complexity

Conditions	1
Paths	1

Size

Total Lines	22
Code Lines	17

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

<?php
    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']);
            });
        });
    }

}