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');
}
};