/** * Run the migrations. * * @return void */ public function up() { Schema::create('bids', function (Blueprint $table) { $table->integer('bid_id', true)->unsigned(); $table->integer('item_id')->unsigned(); $table->integer('user_id')->unsigned(); $table->decimal('amount', 8, 2)->unsigned(); $table->integer('placed')->unsigned(); $table->foreign('item_id')->references('item_id')->on('items'); $table->foreign('user_id')->references('user_id')->on('users'); $table->unique(['item_id', 'user_id', 'amount']); }); Schema::create('bid_increments', function (Blueprint $table) { $table->mediumInteger('bid_increment_id', true)->unsigned(); $table->decimal('minimum', 8, 2)->unsigned(); $table->decimal('increment', 8, 2)->unsigned(); }); $increments = [0 => 0.01, 1 => 0.1, 10 => 1, 50 => 5, 100 => 10, 500 => 50, 1000 => 100]; foreach ($increments as $minimum => $increment) { $bid_increment = new BidIncrement(); $bid_increment->minimum = $minimum; $bid_increment->increment = $increment; $bid_increment->save(); } }