File: /home/posscale/www/printmanager/database/migrations/2025_09_16_131007_update_modal_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.
*/
public function up(): void
{
Schema::table('model', function (Blueprint $table) {
$table->enum('type', ['MFP', 'Printer', '3D_Printer', 'Production'])->nullable();
$table->enum('colour', ['Colour', 'BW_Mono'])->nullable();
$table->enum('pagesize', ['A4', 'A3', 'A2', 'A1', 'Other'])->nullable();
$table->enum('tonerorink', ['Toner', 'Ink'])->nullable();
$table->integer('numslots')->nullable();
$table->text('tonerinkcolors')->nullable();
$table->text('optionalaccessories')->nullable();
});
}
/**
* Reverse the migrations.
*/
public function down(): void
{
Schema::table('model', function (Blueprint $table) {
$table->dropColumn([
'type',
'colour',
'pagesize',
'tonerorink',
'numslots',
'tonerinkcolors',
'optionalaccessories'
]);
});
}
};