Page MenuHomePhorge
Differential D2572 Diff 7258 src/database/migrations/2019_12_10_100355_create_package_skus_table.php

Changeset View

Standalone View

View Options

src/database/migrations/2019_12_10_100355_create_package_skus_table.php

Show All 15 Linesclass CreatePackageSkusTable extends Migration
{ {
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->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 13 Lines