vikkio88 / dsManager-php

use Illuminate\Database\Capsule\Manager as Capsule;

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

class CreateCoachesTable

{

    /**

     * Run the migrations.

     *

     * @return void

     */

    public function run()

    {

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

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

            $table->increments('id');

            $table->string('name');

            $table->string('surname');

            $table->tinyInteger('age');

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

            $table->float('skillAvg');

            $table->float('wageReq');

            $table->string('favouriteModule',10);

            $table->integer('team_id')->nullable();

            $table->timestamps();

        });

    }

    /**

     * Reverse the migrations.

     *

     * @return void

     */

    public function down()

    {

        Schema::drop('coaches');

    }

}

use Illuminate\Database\Capsule\Manager as Capsule;

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

class CreatePlayersTable

{

    /**

     * Run the migrations.

     *

     * @return void

     */

    public function run()

    {

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

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

            $table->increments('id');

            $table->string('name');

            $table->string('surname');

            $table->tinyInteger('age');

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

            $table->float('skillAvg');

            $table->float('wageReq');

            $table->float('val');

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

            $table->integer('team_id')->nullable();

            $table->timestamps();

        });

    }

}

use Illuminate\Database\Capsule\Manager as Capsule;

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

class CreateLeagueTeamsTable

{

    /**

     * Run the migrations.

     *

     * @return void

     */

    public function run()

    {

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

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

            $table->increments('id');

            $table->integer('league_id');

            $table->integer('team_id');

            $table->unsignedTinyInteger('points')->default(0);

            $table->unsignedTinyInteger('played')->default(0);

            $table->unsignedTinyInteger('won')->default(0);

            $table->unsignedTinyInteger('draw')->default(0);

            $table->unsignedTinyInteger('lost')->default(0);

            $table->timestamps();

        });

    }

}