| Server IP : 66.29.132.124 / Your IP : 3.15.223.129 Web Server : LiteSpeed System : Linux business141.web-hosting.com 4.18.0-553.lve.el8.x86_64 #1 SMP Mon May 27 15:27:34 UTC 2024 x86_64 User : wavevlvu ( 1524) PHP Version : 7.4.33 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /home/wavevlvu/book24.ng/database/migrations/ |
Upload File : |
<?php
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;
class UpdateUserTable extends Migration
{
public function up()
{
Schema::table('users', function (Blueprint $table) {
//
if (!Schema::hasColumn('users', 'stripe_customer_id')) {
$table->string('stripe_customer_id')->nullable();
}
if (!Schema::hasColumn('users', 'vendor_commission_amount')) {
$table->integer('vendor_commission_amount')->nullable();
}
if (!Schema::hasColumn('users', 'total_before_fees')) {
$table->decimal('total_before_fees', 10, 2)->nullable();
}
if (!Schema::hasColumn('users', 'vendor_commission_type')) {
$table->string('vendor_commission_type', 30)->nullable();
}
});
}
public function down()
{
Schema::table('users', function (Blueprint $table) {
//
$table->dropColumn('stripe_customer_id');
$table->dropColumn('total_before_fees');
$table->dropColumn('vendor_commission_type');
$table->dropColumn('vendor_commission_amount');
});
}
}