<?php
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;
return new class extends Migration
{
/**
* Run the migrations.
*/
public function up(): void
{
Schema::create('contacts', function (Blueprint $table) {
$table->id();
$table->string('firstname');
$table->string('middlename')->nullable();
$table->string('lastname')->nullable();
$table->string('email')->nullable();
$table->string('secondary_email')->nullable();
$table->string('phone')->nullable();
$table->string('telegram')->nullable();
$table->string('preferred_contact_method')->nullable();
$table->string('other_contact_details')->nullable();
$table->string('name_and_contact_details')->virtualAs("CONCAT(firstname, \" \", lastname, \", \", email)");
$table->text('remarks')->nullable();
$table->timestamps();
});
}
/**
* Reverse the migrations.
*/
public function down(): void
{
Schema::dropIfExists('contacts');
}
};
Editor is loading...