CreateMovieEarningsTable

Complexity

Total Complexity

2

Size/Duplication

Total Lines	44
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	2

Test Coverage

Coverage

70%

Importance

Changes

0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	up()	0	20	1
A	down()	0	9	1

<?php

use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class CreateMovieEarningsTable extends Migration {

PSR1 recommends that each class must be in a namespace of at least one level to avoid collisions.

	/**
	 * Run the migrations.
	 *
	 * @return void
	 */
	public function up() {
		DB::transaction(function () {
			Schema::create('movie_earnings', function (Blueprint $table) {
				$table->increments('id');
				$table->unsignedInteger('movie_id');
				$table->date('date');
				$table->unsignedBigInteger('domestic')->nullable();
				$table->unsignedBigInteger('worldwide')->nullable();
				$table->timestamps();

				$table->foreign('movie_id')->references('id')->on('movies')->onUpdate('cascade')->onDelete('cascade');
			});

			Schema::table('movies', function (Blueprint $table) {
				$table->foreign('latest_earnings_id')->references('id')->on('movie_earnings')->onUpdate('set null')
				      ->onDelete('cascade');
			});

		});
	}

	/**
	 * Reverse the migrations.
	 *
	 * @return void
	 */
	public function down() {
		DB::transaction(function () {
			Schema::table('movies', function (Blueprint $table) {
				$table->dropForeign('movies_latest_earnings_id_foreign');
			});

			Schema::drop('movie_earnings');
		});
	}

}