File: /var/www/admin.javaapp.co.uk/database/migrations/2023_01_19_050613_create_cafe_requests_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('cafe_requests', function (Blueprint $table) {
$table->id();
// $table->uuid('uuid');
$table->string('email')->unique()->default('');
$table->string('cafe_name')->default('');
$table->string('phone')->default('');
$table->tinyInteger('cafe_type')->default(0)->comment('"1 = mobile cart , 0 = cafe"');
$table->string('address')->default('');
$table->string('postcode')->default('');
$table->string('latitude')->default('');
$table->string('longitude')->default('');
$table->string('website')->default('');
$table->string('password')->default('');
$table->tinyInteger('is_active')->default(0)->comment('1 = active, 0 = inactive');
$table->tinyInteger('approved')->default(0)->comment('1 = approved, 0 = rejected');
$table->tinyInteger('signup_completed')->default(0)->comment('1 = approved, 0 = rejected');
$table->tinyInteger('is_open')->default(0)->comment('1 = open, 0 = close');
$table->unsignedInteger('created_at')->default(0);
$table->unsignedInteger('updated_at')->default(0);
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('cafe_requests');
}
};