id(); $table->foreignId('tenant_id')->nullable()->constrained()->cascadeOnDelete(); $table->foreignId('booking_id')->constrained()->cascadeOnDelete(); $table->string('field', 60); $table->text('value')->nullable(); $table->text('previous_value')->nullable(); $table->string('source', 30); $table->unsignedBigInteger('inbound_message_id')->nullable()->index(); $table->text('evidence')->nullable(); $table->decimal('confidence', 4, 3)->nullable(); $table->string('outcome', 20); $table->string('fingerprint', 64); $table->string('actor')->nullable(); $table->dateTime('created_at'); $table->index(['booking_id', 'field']); $table->index(['booking_id', 'fingerprint']); }); Schema::table('bookings', function (Blueprint $table) { $table->string('hold_purpose', 20)->default('offer')->after('hold_expires_at'); }); // B4: the country is never assumed. New guests have none until a source names it (existing values stay, they // cannot be told apart from confirmed ones). Schema::table('guests', function (Blueprint $table) { $table->string('country', 2)->nullable()->default(null)->change(); }); } public function down(): void { Schema::table('guests', function (Blueprint $table) { $table->string('country', 2)->default('DE')->change(); }); Schema::table('bookings', function (Blueprint $table) { $table->dropColumn('hold_purpose'); }); Schema::dropIfExists('case_facts'); } };