Page MenuHomePhorge
Differential D949 Diff 2287 src/database/migrations/2019_12_10_105942_create_plan_packages_table.php

Changeset View

Standalone View

View Options

src/database/migrations/2019_12_10_105942_create_plan_packages_table.php

Show All 14 Linesclass CreatePlanPackagesTable extends Migration
{ {
Schema::create( Schema::create(
'plan_packages', 'plan_packages',
function (Blueprint $table) { function (Blueprint $table) {
$table->bigIncrements('id'); $table->bigIncrements('id');
$table->string('plan_id', 36); $table->string('plan_id', 36);
$table->string('package_id', 36); $table->string('package_id', 36);
$table->integer('qty')->default(1);
$table->integer('qty_min')->default(0); $table->integer('qty_min')->default(0);
$table->integer('qty_max')->default(0); $table->integer('qty_max')->default(0);
$table->integer('discount_qty')->default(0); $table->integer('discount_qty')->default(0);
$table->integer('discount_rate')->default(0); $table->integer('discount_rate')->default(0);
$table->foreign('plan_id')->references('id')->on('plans') $table->foreign('plan_id')->references('id')->on('plans')
->onDelete('cascade')->onUpdate('cascade'); ->onDelete('cascade')->onUpdate('cascade');
Show All 17 Lines