/**
* 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();
}
}
