2021_03_26_080000_create_signup_invitations_table.php
No OneTemporary
Actions

Authored By

Unknown

Size

1 KB

Referenced Files

None

Subscribers

None

2021_03_26_080000_create_signup_invitations_table.php
View Options

	<?php

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

	// phpcs:ignore
	class CreateSignupInvitationsTable extends Migration
	{
	/**
	* Run the migrations.
	*
	* @return void
	*/
	public function up()
	{
	Schema::create(
	'signup_invitations',
	function (Blueprint $table) {
	$table->string('id', 36);
	$table->string('email');
	$table->smallInteger('status');
	$table->bigInteger('user_id')->nullable();
	$table->bigInteger('tenant_id')->unsigned()->nullable();
	$table->timestamps();

	$table->primary('id');

	$table->index('email');
	$table->index('created_at');

	$table->foreign('tenant_id')->references('id')->on('tenants')
	->onUpdate('cascade')->onDelete('set null');
	$table->foreign('user_id')->references('id')->on('users')
	->onUpdate('cascade')->onDelete('set null');
	}
	);
	}

	/**
	* Reverse the migrations.
	*
	* @return void
	*/
	public function down()
	{
	Schema::dropIfExists('signup_invitations');
	}
	}

Mime Type: text/x-php
Expires: Mon, Apr 6, 3:17 AM (3 w, 2 d ago)
Storage Engine: local-disk
Storage Format: Raw Data
Storage Handle: e8/9a/07792ace424d6c08e6f1c95e9ed2
Default Alt Text: 2021_03_26_080000_create_signup_invitations_table.php (1 KB)