File: /home/posscale/.trash/1database.1/migrations/tenant/2024_04_12_110820_printer_job.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.
*/
public function up(): void
{
Schema::create('printer_job', function (Blueprint $table) {
$table->id();
$table->string('model_name');
$table->string('serial_number');
$table->integer('printed_copier');
$table->integer('printed_printer');
$table->integer('printed_total');
$table->integer('scanned_copier');
$table->integer('scanned_printer');
$table->integer('scanned_total');
$table->integer('paper_size_a4');
$table->integer('paper_size_b5');
$table->integer('paper_size_a5');
$table->integer('paper_size_folio');
$table->integer('paper_size_legal');
$table->integer('paper_size_letter');
$table->integer('paper_size_statement');
$table->integer('paper_size_other_double');
$table->integer('paper_size_other_single');
$table->integer('paper_duplex_1_side');
$table->integer('paper_duplex_2_side');
$table->integer('paper_combine_none');
$table->integer('paper_combine_2_in_1');
$table->integer('paper_combine_4_in_1');
$table->integer('paper_combine_total');
$table->softDeletes();
$table->timestamps();
$table->foreignId('printer_id');
});
}
/**
* Reverse the migrations.
*/
public function down(): void
{
Schema::dropIfExists('printer_job');
}
};