public function up()
    {
        Schema::create('overwatch_matches', function (Blueprint $table) {

        $table->increments('id');

        /*
        match information
        */

        $table->string('match_id')->unique();
        $table->string('team_a_slot_party_id');
        $table->string('team_b_slot_party_id');
        $table->string('match_type');
        $table->string('match_mode');
        $table->string('match_pool');

        /*
        match result reporting
        */

        $table->string('match_winner')->nullable();
        $table->string('match_loser')->nullable();
        $table->boolean('match_dispute')->nullable();

        $table->string('team_a_slot_slot1_report')->nullable();
        $table->string('team_a_slot_slot2_report')->nullable();
        $table->string('team_a_slot_slot3_report')->nullable();
        $table->string('team_a_slot_slot4_report')->nullable();
        $table->string('team_a_slot_slot5_report')->nullable();
        $table->string('team_a_slot_slot6_report')->nullable();

        $table->string('team_b_slot_slot1_report')->nullable();
        $table->string('team_b_slot_slot2_report')->nullable();
        $table->string('team_b_slot_slot3_report')->nullable();
        $table->string('team_b_slot_slot4_report')->nullable();
        $table->string('team_b_slot_slot5_report')->nullable();
        $table->string('team_b_slot_slot6_report')->nullable();

        /*
        accepting party member
        */

        $table->integer('team_a_slot_slot1_user_id');
        $table->string('team_a_slot_slot1_bnet_id');
        $table->integer('team_a_slot_slot1_deposit');
        $table->integer('team_a_slot_slot2_user_id')->nullable();
        $table->string('team_a_slot_slot2_bnet_id')->nullable();
        $table->integer('team_a_slot_slot2_deposit')->nullable();
        $table->integer('team_a_slot_slot3_user_id')->nullable();
        $table->string('team_a_slot_slot3_bnet_id')->nullable();
        $table->integer('team_a_slot_slot3_deposit')->nullable();
        $table->integer('team_a_slot_slot4_user_id')->nullable();
        $table->string('team_a_slot_slot4_bnet_id')->nullable();
        $table->integer('team_a_slot_slot4_deposit')->nullable();
        $table->integer('team_a_slot_slot5_user_id')->nullable();
        $table->string('team_a_slot_slot5_bnet_id')->nullable();
        $table->integer('team_a_slot_slot5_deposit')->nullable();
        $table->integer('team_a_slot_slot6_user_id')->nullable();
        $table->string('team_a_slot_slot6_bnet_id')->nullable();
        $table->integer('team_a_slot_slot6_deposit')->nullable();

        /*
        challenging party members
        */

        $table->integer('team_b_slot_slot1_user_id');
        $table->string('team_b_slot_slot1_bnet_id');
        $table->integer('team_b_slot_slot1_deposit');
        $table->integer('team_b_slot_slot2_user_id')->nullable();
        $table->string('team_b_slot_slot2_bnet_id')->nullable();
        $table->integer('team_b_slot_slot2_deposit')->nullable();
        $table->integer('team_b_slot_slot3_user_id')->nullable();
        $table->string('team_b_slot_slot3_bnet_id')->nullable();
        $table->integer('team_b_slot_slot3_deposit')->nullable();
        $table->integer('team_b_slot_slot4_user_id')->nullable();
        $table->string('team_b_slot_slot4_bnet_id')->nullable();
        $table->integer('team_b_slot_slot4_deposit')->nullable();
        $table->integer('team_b_slot_slot5_user_id')->nullable();
        $table->string('team_b_slot_slot5_bnet_id')->nullable();
        $table->integer('team_b_slot_slot5_deposit')->nullable();
        $table->integer('team_b_slot_slot6_user_id')->nullable();
        $table->string('team_b_slot_slot6_bnet_id')->nullable();
        $table->integer('team_b_slot_slot6_deposit')->nullable();

        $table->timestamps();
        });
    }