xoco70 / laravel-tournaments

use Illuminate\Database\Migrations\Migration;

use Illuminate\Database\Schema\Blueprint;

class CreateTeamTable extends Migration

{

    public function up()

    {

        Schema::create('team', function (Blueprint $table) {

            $table->increments('id');

            $table->string('name');

            $table->integer('championship_id')->unsigned()->index(); // A checar

            $table->string('picture')->nullable();

            $table->string('entity_type')->nullable(); // Club, Assoc, Fed

            $table->integer('entity_id')->unsigned()->nullable()->index();

            $table->timestamps();

            $table->foreign('championship_id')

                ->references('id')

                ->on('championship')

                ->onUpdate('cascade')

                ->onDelete('cascade');

            $table->unique(['championship_id', 'name']);

        });

    }

    public function down()

    {

        DB::statement('SET FOREIGN_KEY_CHECKS = 0');

        Schema::drop('team');

        DB::statement('SET FOREIGN_KEY_CHECKS = 1');

    }

}

use Illuminate\Database\Schema\Blueprint;

use Illuminate\Database\Migrations\Migration;

class CreateRoundCompetitorTable extends Migration

{

    /**

     * Run the migrations.

     *

     * @return void

     */

    public function up()

    {

        Schema::create('competitor_round', function (Blueprint $table) {

            $table->increments('id');

            $table->integer('competitor_id')->unsigned()->index();

            $table->integer('round_id')->unsigned()->index(); // A checar

            $table->timestamps();

            $table->foreign('competitor_id')

                ->references('id')

                ->on('competitor')

                ->onUpdate('cascade')

                ->onDelete('cascade');

            $table->foreign('round_id')

                ->references('id')

                ->on('round')

                ->onUpdate('cascade')

                ->onDelete('cascade');

            $table->unique(['competitor_id', 'round_id']);

        });

    }

    /**

     * Reverse the migrations.

     *

     * @return void

     */

    public function down()

    {

        DB::statement('SET FOREIGN_KEY_CHECKS = 0');

        Schema::dropIfExists('competitor_round');

        DB::statement('SET FOREIGN_KEY_CHECKS = 1');

    }

}

use Illuminate\Database\Schema\Blueprint;

use Illuminate\Database\Migrations\Migration;

class CreateRoundTeamTable extends Migration

{

    /**

     * Run the migrations.

     *

     * @return void

     */

    public function up()

    {

        Schema::create('team_round', function (Blueprint $table) {

            $table->increments('id');

            $table->integer('team_id')->unsigned()->index();

            $table->integer('round_id')->unsigned()->index(); // A checar

            $table->timestamps();

            $table->foreign('team_id')

                ->references('id')

                ->on('team')

                ->onUpdate('cascade')

                ->onDelete('cascade');

            $table->foreign('round_id')

                ->references('id')

                ->on('round')

                ->onUpdate('cascade')

                ->onDelete('cascade');

            $table->unique(['team_id', 'round_id']);

        });

    }

    /**

     * Reverse the migrations.

     *

     * @return void

     */

    public function down()

    {

        DB::statement('SET FOREIGN_KEY_CHECKS = 0');

        Schema::dropIfExists('team_round');

        DB::statement('SET FOREIGN_KEY_CHECKS = 1');

    }

}