![]() Server : Apache/2.4.62 (Unix) OpenSSL/1.0.2k-fips System : Linux server1.richineiserver.com 3.10.0-1160.119.1.el7.x86_64 #1 SMP Tue Jun 4 14:43:51 UTC 2024 x86_64 User : fdshops ( 1003) PHP Version : 8.2.21 Disable Function : NONE Directory : /home/fdshops/old.fdshops.com.ng/database/migrations/ |
<?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; return new class extends Migration { /** * Run the migrations. * * @return void */ public function up() { Schema::create('business', function (Blueprint $table) { $table->engine = 'InnoDB'; $table->increments('id'); $table->string('name'); $table->integer('currency_id')->unsigned(); $table->date('start_date')->nullable(); $table->string('tax_number_1', 100); $table->string('tax_label_1', 10); $table->string('tax_number_2', 100)->nullable(); $table->string('tax_label_2', 10)->nullable(); $table->float('default_profit_percent', 5, 2)->default(0); $table->integer('owner_id')->unsigned(); $table->foreign('owner_id')->references('id')->on('users')->onDelete('cascade'); $table->string('time_zone')->default('Asia/Kolkata'); $table->tinyInteger('fy_start_month')->default(1); $table->enum('accounting_method', ['fifo', 'lifo', 'avco'])->default('fifo'); $table->decimal('default_sales_discount', 5, 2)->nullable(); $table->enum('sell_price_tax', ['includes', 'excludes'])->default('includes'); $table->foreign('currency_id')->references('id')->on('currencies'); $table->string('logo')->nullable(); $table->string('sku_prefix')->nullable(); $table->boolean('enable_tooltip')->default(1); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('business'); } };