xoco70 / laravel-tournaments

     *

     * @return void

     */

    public function up()

    {

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

            $table->increments('id');

            $table->string('venue_name');

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

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

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

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

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

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

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

            $table->timestamps();

            $table->engine = 'InnoDB';

        });

    }

    /**

     * Reverse the migrations.

     *

     * @return void

     */

    public function up()

    {

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

            $table->increments('id');

            $table->tinyInteger('short_id')->unsigned()->nullable();

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

            $table->tinyInteger('round')->default(0); // Eliminitory, 1/8, 1/4, etc.

            $table->tinyInteger('area');

            $table->tinyInteger('order');

            NestedSet::columns($table);

            $table->timestamps();

            $table->engine = 'InnoDB';

            $table->foreign('championship_id')

                ->references('id')

                ->onUpdate('cascade')

                ->on('championship')

                ->onDelete('cascade');

        });

    }

    /**

     * Reverse the migrations.