<?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('orders', function (Blueprint $table) { $table->id(); $table->foreignId('user_id')->constrained()->cascadeOnDelete(); $table->string('order_no')->unique(); $table->unsignedInteger('subtotal_cents')->default(0); $table->unsignedInteger('total_cents')->default(0); $table->string('status')->default('pending'); // pending | payment_pending | paid | failed | cancelled // simple customer data collection $table->string('customer_name')->nullable(); $table->string('customer_phone')->nullable(); $table->timestamps(); }); } /** * Reverse the migrations. */ public function down(): void { Schema::dropIfExists('orders'); } };