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

Complexity

Conditions	1
Paths	1

Size

Total Lines	32
Code Lines	22

Duplication

Lines	10
Ratio	31.25 %

Importance

Changes	1
Bugs	0	Features	0

<?php
    public function up()
    {
        DB::transaction(function() {
            Schema::create('cosmicradiotv_podcast_release_types', function (Blueprint $table) {
                $table->engine = 'InnoDB';
                $table->increments('id');
                $table->string('name');
                $table->string('slug');
                $table->string('type');
                $table->string('filetype');

                $table->unique('slug');
            });

            Schema::create('cosmicradiotv_podcast_releases', function (Blueprint $table) {
                $table->engine = 'InnoDB';
                $table->increments('id');
                $table->unsignedInteger('episode_id');
                $table->unsignedInteger('release_type_id');
                $table->text('url');
                $table->bigInteger('size');
                $table->timestamps();

                $table->foreign('episode_id')->references('id')->on('cosmicradiotv_podcast_episodes')
                      ->onUpdate('cascade');
                $table->foreign('release_type_id')->references('id')->on('cosmicradiotv_podcast_release_types')
                      ->onUpdate('cascade');

            });
        });

    }

}