2019_12_10_105942_create_plan_packages_table.php
No OneTemporary
Actions

Size

1 KB

Referenced Files

None

Subscribers

None

2019_12_10_105942_create_plan_packages_table.php
View Options

	<?php

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

	// phpcs:ignore
	class CreatePlanPackagesTable extends Migration
	{
	/**
	* Run the migrations.
	*
	* @return void
	*/
	public function up()
	{
	Schema::create(
	'plan_packages',
	function (Blueprint $table) {
	$table->bigIncrements('id');
	$table->string('plan_id', 36);
	$table->string('package_id', 36);

	$table->integer('qty')->default(1);
	$table->integer('qty_min')->default(0);
	$table->integer('qty_max')->default(0);

	$table->integer('discount_qty')->default(0);
	$table->integer('discount_rate')->default(0);

	$table->foreign('plan_id')->references('id')->on('plans')
	->onDelete('cascade')->onUpdate('cascade');

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

	/**
	* Reverse the migrations.
	*
	* @return void
	*/
	public function down()
	{
	Schema::dropIfExists('plan_packages');
	}
	}