1#@!#!123s

ALWAYS HENGHENG888 1#@!#!123s
: / var / www / cdcdhaka.org / database / migrations /
Filename : 2023_12_31_143758_create_user_registration_table.php
back
<?php

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

class CreateUserRegistrationTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('user_registration', function (Blueprint $table) {
            $table->id();
            $table->string('uuid', 100)->index()->unique()->nullable();
            $table->string('email', 100)->index()->unique()->nullable();
            $table->string('phone', 100)->index()->unique()->nullable();
            $table->string('otp_code', 10)->index();
            $table->timestamp('otp_expired')->index();
            $table->enum('type', ['register', 'reset_password'])->default('register')->index()->nullable(); // will be flat or percentage
            $table->enum('status', ['new', 'resend', 'registered', 'blocked', 'checked'])->default('new')->index()->nullable(); // will be flat or percentage
            $table->tinyInteger('attempt_count')->nullable();
            $table->timestamps();
            $table->softDeletes();
        });

        // php artisan migrate:refresh --path='./database/migrations/2023_12_31_143758_create_user_registration_table.php'
    }

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