Differential D2440 Diff 6931 src/database/migrations/2021_04_08_160000_expires_at_column_fix.php

Changeset View

Standalone View

				<?php

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

				// phpcs:ignore
				class ExpiresAtColumnFix extends Migration
				{
				/**
				* Run the migrations.
				*
				* @return void
				*/
				public function up()
				{
				// This is to remove "ON UPDATE" clause from the column
				// There's no way to do this with Laravel schema migration tools,
				// we have to use raw queries.

				// Note: Whenever you create a table with custom timestamp() column don't forget to use
				// also one of nullable() or useCurrent() to make sure "ON UPDATE" is not added.

				DB::statement("ALTER TABLE `signup_codes` MODIFY `expires_at`"
				. " TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP");
				DB::statement("ALTER TABLE `verification_codes` MODIFY `expires_at`"
				. " TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP");
				}

				/**
				* Reverse the migrations.
				*
				* @return void
				*/
				public function down()
				{
				// empty
				}
				}