![]() 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('warranties', function (Blueprint $table) { $table->increments('id'); $table->string('name'); $table->integer('business_id'); $table->text('description')->nullable(); $table->integer('duration'); $table->enum('duration_type', ['days', 'months', 'years']); $table->timestamps(); }); Schema::table('products', function (Blueprint $table) { $table->integer('warranty_id')->nullable()->index()->after('created_by'); }); Schema::create('sell_line_warranties', function (Blueprint $table) { $table->integer('sell_line_id'); $table->integer('warranty_id'); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('warranties'); } };