vikkio88 / dsManager-php

use Illuminate\Database\Capsule\Manager as Capsule;

use \Illuminate\Database\Schema\Blueprint as Blueprint;

class CreateTeamTable

{

    /**

     * Run the migrations.

     *

     * @return void

     */

    public function run()

    {

        Capsule::schema()->dropIfExists('teams');

        Capsule::schema()->create('teams', function (Blueprint $table) {

            $table->increments('id');

            $table->string('name');

            $table->string('nationality',2);

            $table->timestamps();

        });

    }

}

use Illuminate\Database\Capsule\Manager as Capsule;

use \Illuminate\Database\Schema\Blueprint as Blueprint;

class CreateLeaguesTable

{

    /**

     * Run the migrations.

     *

     * @return void

     */

    public function run()

    {

        Capsule::schema()->dropIfExists('leagues');

        Capsule::schema()->create('leagues', function (Blueprint $table) {

            $table->increments('id');

            $table->string('name');

            $table->unsignedTinyInteger('teams')->default(2);

            $table->timestamps();

        });

    }

}

use Illuminate\Database\Capsule\Manager as Capsule;

use \Illuminate\Database\Schema\Blueprint as Blueprint;

class CreateLeagueRoundsTable

{

    /**

     * Run the migrations.

     *

     * @return void

     */

    public function run()

    {

        Capsule::schema()->dropIfExists('league_rounds');

        Capsule::schema()->create('league_rounds', function (Blueprint $table) {

            $table->increments('id');

            $table->integer('league_id');

            $table->boolean('simulated')->default(false);

            $table->integer('day')->default(0);

            $table->timestamps();

        });

    }

}