increments('id')->unsigned(); $table->integer('gameId')->unsigned(); $table->foreign('gameId')->references('id')->on('games'); $table->string('title', 127)->unique(); $table->mediumText('description')->nullable(); $table->integer('competition_type')->unsigned(); $table->foreign('competition_type')->references('type')->on('competition_types'); $table->dateTime('start'); $table->dateTime('end'); $table->mediumInteger('max_players')->unsigned(); $table->timestamps(); }); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::drop('competitions'); } }