+global\CreateLtChampionshipSettingsTable::up()

Complexity

Conditions	1
Paths	1

Size

Total Lines	47
Code Lines	31

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
    public function up()
    {
        Schema::create('championship_settings', function (Blueprint $table) {
            $table->increments('id');
            $table->string('alias')->nullable();
            $table->integer('championship_id')->unsigned()->unique();
            $table->foreign('championship_id')
                ->references('id')
                ->onUpdate('cascade')
                ->on('championship')
                ->onDelete('cascade');

            // Category Section
            $table->tinyInteger('treeType')->default(ChampionshipSettings::SINGLE_ELIMINATION);
            $table->tinyInteger('fightingAreas')->unsigned()->nullable()->default(1);
            $table->integer('limitByEntity')->unsigned()->nullable();

            // Preliminary
            $table->boolean('hasPreliminary')->default(1);
            $table->boolean('preliminaryGroupSize')->default(3);
            $table->tinyInteger('preliminaryWinner')->default(1); // Number of Competitors that go to next level
            $table->string('preliminaryDuration')->nullable(); // Match Duration in preliminary heat

            // Team
            $table->tinyInteger('teamSize')->nullable(); // Default is null
            $table->tinyInteger('teamReserve')->nullable(); // Default is null

            // Seed
            $table->smallInteger('seedQuantity')->nullable(); // Competitors seeded in tree

            //TODO This should go in another table that is not for tree construction but for rules
            // Rules
            $table->boolean('hasEncho')->default(1);
            $table->tinyInteger('enchoQty')->default(0);
            $table->string('enchoDuration')->nullable();
            $table->boolean('hasHantei')->default(false);
            $table->smallInteger('cost')->nullable(); // Cost of competition

            $table->string('fightDuration')->nullable(); // Can't apply default because text
            $table->smallInteger('hanteiLimit')->default(0); // 0 = none, 1 = 1/8, 2 = 1/4, 3=1/2, 4 = FINAL
            $table->smallInteger('enchoGoldPoint')->default(0); // 0 = none, 1 = 1/8, 2 = 1/4, 3=1/2, 4 = FINAL

            $table->timestamps();
            $table->softDeletes();
            $table->engine = 'InnoDB';
        });
    }