Differential D2239 Diff 6781 src/database/migrations/2021_02_23_084157_payment_table_add_currency_columns.php

Changeset View

Standalone View

				<?php

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

				// phpcs:ignore
				class PaymentTableAddCurrencyColumns extends Migration
				{
				/**
				* Run the migrations.
				*
				* @return void
				*/
				public function up()
				{
				Schema::table(
				'payments',
				function (Blueprint $table) {
				$table->string('currency')->nullable();
				$table->integer('currency_amount')->nullable();
				}
				machniakUnsubmitted Done Inline Actions Should we make an update query to fill the new columns with proper data? machniak: Should we make an update query to fill the new columns with proper data?
				mollekopfAuthorUnsubmitted Done Inline Actions Not sure if necessary, but I suppose would make future queries simpler? Just fill with currency=CHF and currency_amount=amount? mollekopf: Not sure if necessary, but I suppose would make future queries simpler? Just fill with…
				machniakUnsubmitted Done Inline Actions Yes. machniak: Yes.
				);

				DB::table('payments')->update([
				'currency' => 'CHF',
				'currency_amount' => DB::raw("`amount`")
				]);

				Schema::table(
				'payments',
				function (Blueprint $table) {
				$table->string('currency')->nullable(false)->change();
				$table->integer('currency_amount')->nullable(false)->change();
				}
				);
				}

				/**
				* Reverse the migrations.
				*
				* @return void
				*/
				public function down()
				{
				Schema::table(
				'payments',
				function (Blueprint $table) {
				$table->dropColumn('currency');
				$table->dropColumn('currency_amount');
				}
				);
				}
				}