Beispiel #1
0
 /**
  * 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();
 }
Beispiel #2
0
 /**
  * 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();
 }
Beispiel #3
0
 /**
  * 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();
 }
Beispiel #4
0
 /**
  * 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();
 }
Beispiel #5
0
 /**
  * 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();
 }
Beispiel #6
0
 /**
  * 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();
 }
Beispiel #7
0
 /**
  * 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();
 }