File: /var/www/admin.javaapp.co.uk/database/migrations/2023_02_20_103756_create_in_house_items_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('in_house_items', function (Blueprint $table) {
$table->id();
$table->string('item_name');
$table->string('item_image');
$table->tinyInteger('is_active')->default(0)->comment("0 = inactive, 1 = active");
$table->unsignedInteger('created_at')->default(0);
$table->unsignedInteger('updated_at')->default(0);
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('in_house_items');
}
};