Differential D964 Diff 2503 src/database/migrations/2019_12_10_100355_create_package_skus_table.php

Changeset View

Standalone View

	<?php			<?php

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

				// phpcs:ignore
	class CreatePackageSkusTable extends Migration			class CreatePackageSkusTable extends Migration
	{			{
	/**			/**
	* Run the migrations.			* Run the migrations.
	*			*
	* @return void			* @return void
	*/			*/
	public function up()			public function up()
	{			{
	Schema::create(			Schema::create(
	'package_skus',			'package_skus',
	function (Blueprint $table) {			function (Blueprint $table) {
	$table->bigIncrements('id');			$table->bigIncrements('id');
	$table->string('package_id', 36);			$table->string('package_id', 36);
	$table->string('sku_id', 36);			$table->string('sku_id', 36);
	$table->integer('qty')->default(1);			$table->integer('qty')->default(1);

				$table->integer('cost')->default(0)->nullable();

	$table->foreign('package_id')->references('id')->on('packages')			$table->foreign('package_id')->references('id')->on('packages')
	->onDelete('cascade')->onUpdate('cascade');			->onDelete('cascade')->onUpdate('cascade');

	$table->foreign('sku_id')->references('id')->on('skus')			$table->foreign('sku_id')->references('id')->on('skus')
	->onDelete('cascade')->onUpdate('cascade');			->onDelete('cascade')->onUpdate('cascade');
	}			}
	);			);
	}			}
	Show All 11 Lines