File "2024_01_01_000030_create_users_table.php"

Full Path: /home/trinadezambia/public_html/gambling/database/migrations/2024_01_01_000030_create_users_table.php
File size: 2.29 KB
MIME-type: text/x-php
Charset: utf-8

<?php

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

return new class extends Migration
{
    public function up(): void
    {
        Schema::create('users', function (Blueprint $table) {
            $table->id();
            $table->string('firstname', 40)->nullable();
            $table->string('lastname', 40)->nullable();
            $table->string('username', 40)->nullable();
            $table->string('email', 40);
            $table->string('dial_code', 40)->nullable();
            $table->string('country_code', 40)->nullable();
            $table->string('mobile', 40)->nullable();
            $table->string('image')->nullable();
            $table->unsignedInteger('ref_by')->nullable();
            $table->decimal('balance', 28, 8)->default('0.00000000');
            $table->decimal('demo_balance', 28, 8)->default('0.00000000');
            $table->string('password');
            $table->string('country_name')->nullable();
            $table->string('city')->nullable();
            $table->string('state')->nullable();
            $table->string('zip')->nullable();
            $table->text('address')->nullable();
            $table->tinyInteger('status')->default(1);
            $table->tinyInteger('ev')->default(0);
            $table->tinyInteger('sv')->default(0);
            $table->string('ver_code', 40)->nullable();
            $table->dateTime('ver_code_send_at')->nullable();
            $table->tinyInteger('ts')->default(0);
            $table->tinyInteger('tv')->default(1);
            $table->string('tsc')->nullable();
            $table->string('remember_token')->nullable();
            $table->string('provider', 40)->nullable();
            $table->string('provider_id')->nullable();
            $table->text('kyc_data')->nullable();
            $table->string('kyc_rejection_reason')->nullable();
            $table->tinyInteger('kv')->default(0);
            $table->tinyInteger('profile_complete')->default(0);
            $table->string('ban_reason')->nullable();
            $table->string('login_by', 40)->nullable();
            $table->timestamps();

            $table->unique(['username', 'email']);
        });
    }

    public function down(): void
    {
        Schema::dropIfExists('users');
    }
};