/**
* Runs the migrations.
*
* @param Blueprint $table
*
* @return void
*/
public function up($table)
{
$table->increments('id');
$table->integer('match_id')->unsigned();
$table->foreign('match_id')->references('id')->on('matches')->onDelete('cascade');
$table->string('map')->default('de_dust2');
$table->integer('score_a')->default(0);
$table->integer('score_b')->default(0);
$table->integer('current_round')->default(0);
/*
* Statuses:
*
* 0. Not Started
* 1. Starting
* 2. Pre-Game Warmup
* 3. Knife Round
* 4. Knife Winners Deciding
* 5. First Half Warmup
* 6. First Half
* 7. Second Half Warmup
* 8. Second Half
* 9. Overtime Warmup
* 10. Overtime
* 11. Finished
*/
$table->integer('status')->default(0);
$table->boolean('is_paused')->default(false);
$table->string('team_paused')->nullable();
$table->boolean('team_a_unpause')->default(false);
$table->boolean('team_b_unpause')->default(false);
$table->string('current_side')->default('ct');
$table->boolean('t_ready')->default(false);
$table->boolean('ct_ready')->default(false);
$table->timestamps();
}
/**
* Runs the migrations.
*
* @param Blueprint $table
*
* @return void
*/
public function up($table)
{
$table->increments('id');
$table->integer('event_id')->unsigned();
$table->foreign('event_id')->references('id')->on('events')->onDelete('cascade');
$table->integer('server_id')->unsigned();
$table->foreign('server_id')->references('id')->on('servers')->onDelete('cascade');
$table->integer('team_a')->unsigned();
$table->foreign('team_a')->references('id')->on('teams')->onDelete('cascade');
$table->integer('team_b')->unsigned();
$table->foreign('team_b')->references('id')->on('teams')->onDelete('cascade');
$table->integer('ruleset_id')->unsigned();
$table->foreign('ruleset_id')->references('id')->on('rulesets')->onDelete('cascade');
/*
* Statuses:
*
* -1: Finished
* 0: Not Started
* 1: Running Map 1
* 2: Running Map 2
* 3: Running Map 3
* 4: Running Map 4
* 5: Running Map 5
*/
$table->integer('status')->default(0);
$table->boolean('starting')->default(false);
$table->string('password')->nullable();
$table->string('auth_key')->nullable();
$table->integer('best_of')->default(1);
$table->timestamps();
}
/**
* Runs the migrations.
*
* @param Blueprint $table
*
* @return void
*/
public function up($table)
{
$table->increments('id');
$table->integer('map_id')->unsigned();
$table->foreign('map_id')->references('id')->on('maps')->onDelete('cascade');
$table->string('steam_id');
$table->string('username')->nullable();
$table->bigInteger('kills')->default(0);
$table->bigInteger('assists')->default(0);
$table->bigInteger('deaths')->default(0);
$table->bigInteger('points')->default(0);
$table->bigInteger('headshots')->default(0);
$table->bigInteger('plants')->default(0);
$table->bigInteger('defuses')->default(0);
$table->bigInteger('teamkills')->default(0);
$table->bigInteger('1k')->default(0);
$table->bigInteger('2k')->default(0);
$table->bigInteger('3k')->default(0);
$table->bigInteger('4k')->default(0);
$table->bigInteger('5k')->default(0);
$table->bigInteger('1v1')->default(0);
$table->bigInteger('1v2')->default(0);
$table->bigInteger('1v3')->default(0);
$table->bigInteger('1v4')->default(0);
$table->bigInteger('1v5')->default(0);
$table->bigInteger('entries')->default(0);
$table->timestamps();
}
/**
* Creates the table.
*
* @param Blueprint $table
*
* @return void
*/
public function up($table)
{
$table->increments('id');
$table->string('username')->unique();
$table->string('password');
$table->timestamps();
}
/**
* Runs the migrations.
*
* @param Blueprint $table
*
* @return void
*/
public function up($table)
{
$table->increments('id');
$table->string('name');
$table->string('subtitle')->nullable();
$table->boolean('active')->default(false);
$table->string('link')->nullable();
$table->longText('description')->nullable();
$table->timestamps();
}
/**
* Runs the migrations.
*
* @param Blueprint $table
*
* @return void
*/
public function up($table)
{
$table->increments('id');
$table->integer('event_id')->unsigned();
$table->foreign('event_id')->references('id')->on('events')->onDelete('cascade');
$table->string('name');
$table->string('flag');
$table->string('logo')->nullable();
$table->timestamps();
}
/**
* Runs the migrations.
*
* @param Blueprint $table
*
* @return void
*/
public function up($table)
{
$table->increments('id');
$table->string('name');
$table->string('ip');
$table->integer('port')->default(27015);
$table->string('gotv_ip');
$table->string('rcon');
$table->timestamps();
}
/**
* Runs the migrations.
*
* @param Blueprint $table
*
* @return void
*/
public function up($table)
{
$table->increments('id');
$table->string('name');
$table->string('config_file')->default('esl5on5');
$table->integer('max_rounds')->default(15);
$table->boolean('knife_round')->default(true);
$table->boolean('overtime_enabled')->default(true);
$table->bigInteger('overtime_start_money')->default(10000);
$table->integer('overtime_max_round')->default(3);
$table->timestamps();
}
/**
* Runs the migrations.
*
* @param Blueprint $table
*
* @return void
*/
public function up($table)
{
$table->increments('id');
$table->integer('map_id')->unsigned();
$table->foreign('map_id')->references('id')->on('maps')->onDelete('cascade');
$table->integer('round');
$table->string('win_type')->nullable();
$table->integer('winner_id')->unsigned();
$table->foreign('winner_id')->references('id')->on('teams')->onDelete('cascade');
$table->string('winner_team')->default('t');
$table->integer('mvp_id')->unsigned();
$table->foreign('mvp_id')->references('id')->on('players')->onDelete('cascade');
$table->string('mvp_text')->nullable();
$table->string('backup_file')->nullable();
$table->timestamps();
}
/**
* Runs the migrations.
*
* @param Blueprint $table
*
* @return void
*/
public function up($table)
{
$table->increments('id');
$table->integer('map_id')->unsigned();
$table->foreign('map_id')->references('id')->on('maps')->onDelete('cascade');
$table->integer('current_round');
$table->string('type');
$table->json('data');
$table->timestamps();
}
/**
* Runs the migrations.
*
* @param Blueprint $table
*
* @return void
*/
public function up($table)
{
$table->increments('id');
$table->integer('map_id')->unsigned();
$table->foreign('map_id')->references('id')->on('maps')->onDelete('cascade');
$table->string('type')->default('normal');
$table->integer('team_a_side_1')->default(0);
$table->integer('team_a_side_2')->default(0);
$table->integer('team_b_side_1')->default(0);
$table->integer('team_b_side_2')->default(0);
$table->timestamps();
}