HEX
Server: Apache/2.4.52 (Ubuntu)
System: Linux ip-10-0-8-47 6.8.0-1021-aws #23~22.04.1-Ubuntu SMP Tue Dec 10 16:31:58 UTC 2024 aarch64
User: ubuntu (1000)
PHP: 8.1.2-1ubuntu2.22
Disabled: NONE
Upload Files
File: /var/www/admin.javaapp.co.uk/database/migrations/2014_10_12_000000_create_users_table.php
<?php

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

return new class extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('users', function (Blueprint $table) {
            $table->id();
            $table->string('name');
            $table->string('email')->unique()->default('');
            // $table->timestamp('email_verified_at')->nullable();
            $table->string('password');
            $table->rememberToken();
            $table->string('device_id')->default('');
            $table->tinyInteger('device_type')->default(0)->comment('0 Default 1 Android 2 iOS');
            $table->text('fcm_token')->nullable();
            $table->integer('otp')->default(0);
            $table->unsignedInteger('otp_expired_at')->default(0);
            $table->unsignedInteger('otp_verified_at')->default(0);
            $table->string('profile_picture')->default('');
            $table->string('address')->default('');
            $table->double('user_latitude')->default(0);
            $table->double('user_longitude')->default(0);
            $table->tinyInteger('notification_status')->default(0)->comment('1 On 2 Off');
            $table->tinyInteger('is_active')->default(0)->comment('1 = active, 0 = inactive');
            $table->tinyInteger('is_verified')->default(0)->comment('0 = No, 1 = Yes');
            $table->tinyInteger('is_deleted')->default(0)->comment('1 = deleted, 0 = not deleted');
            $table->text('delete_reason')->nullable()->comment('Reason for delete account');
            // $table->timestamps();
            $table->unsignedInteger('created_at')->default(0);
            $table->unsignedInteger('updated_at')->default(0);
        });
    }

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