2022_10_10_100000_signup_codes_user_id.php
No OneTemporary
Actions

Size

1 KB

Referenced Files

None

Subscribers

None

2022_10_10_100000_signup_codes_user_id.php
View Options

	<?php

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

	return new class extends Migration
	{
	/**
	* Run the migrations.
	*
	* @return void
	*/
	public function up()
	{
	Schema::table(
	'signup_codes',
	function (Blueprint $table) {
	$table->string('verify_ip_address')->index()->nullable();
	$table->string('submit_ip_address')->index()->nullable();

	$table->bigInteger('user_id')->index()->nullable();
	$table->foreign('user_id')->references('id')->on('users')
	->onUpdate('cascade')->onDelete('cascade');
	}
	);
	}

	/**
	* Reverse the migrations.
	*
	* @return void
	*/
	public function down()
	{
	Schema::table(
	'signup_codes',
	function (Blueprint $table) {
	$table->dropForeign(['user_id']);
	$table->dropColumn('user_id');
	$table->dropColumn('verify_ip_address');
	$table->dropColumn('submit_ip_address');
	}
	);
	}
	};