Page MenuHomePhorge
Differential D1063 Diff 2890 src/database/migrations/2020_03_30_100000_create_discounts.php

Changeset View

Standalone View

View Options

src/database/migrations/2020_03_30_100000_create_discounts.php

  • This file was added.
<?php
use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
// phpcs:ignore
class CreateDiscounts extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create(
'discounts',
function (Blueprint $table) {
$table->string('id', 36);
$table->tinyInteger('discount')->unsigned();
$table->json('description');
$table->string('code', 32)->nullable();
$table->boolean('active')->default(false);
$table->timestamps();
$table->primary('id');
}
);
Schema::table(
'wallets',
function (Blueprint $table) {
$table->string('discount_id', 36)->nullable();
$table->foreign('discount_id')->references('id')
->on('discounts')->onDelete('set null');
}
);
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::table(
'wallets',
function (Blueprint $table) {
$table->dropForeign(['discount_id']);
$table->dropColumn('discount_id');
}
);
Schema::dropIfExists('discounts');
vanmeeuwenUnsubmitted
Not Done
Inline Actions

I've needed to apply;

diff --git a/src/database/migrations/2020_03_30_100000_create_discounts.php b/src/database/migrations/2020_03_30_100000_create_discounts.php
index 282b7de..b522449 100644
--- a/src/database/migrations/2020_03_30_100000_create_discounts.php
+++ b/src/database/migrations/2020_03_30_100000_create_discounts.php
@@ -4,6 +4,7 @@ use Illuminate\Support\Facades\Schema;
 use Illuminate\Database\Schema\Blueprint;
 use Illuminate\Database\Migrations\Migration;
 
+// phpcs:ignore
 class CreateDiscounts extends Migration
 {
     /**
@@ -29,7 +30,7 @@ class CreateDiscounts extends Migration
         Schema::table(
             'wallets',
             function (Blueprint $table) {
-                $table->integer('discount_id')->nullable();
+                $table->integer('discount_id')->unsigned()->nullable();
 
                 $table->foreign('discount_id')->references('id')
                     ->on('discounts')->onDelete('set null');
@@ -44,13 +45,14 @@ class CreateDiscounts extends Migration
      */
     public function down()
     {
-        Schema::dropIfExists('discounts');
-
         Schema::table(
             'wallets',
             function (Blueprint $table) {
+                $table->dropForeign(['discount_id']);
                 $table->dropColumn('discount_id');
             }
         );
+
+        Schema::dropIfExists('discounts');
     }
 }
vanmeeuwen: I've needed to apply; ``` diff --git a/src/database/migrations/2020_03_30_100000_create_discou…
}
}