manelgavalda / enrollment_mobile

/**

 * Class CreateCoursesTable

 */

class CreateCoursesTable extends Migration

{

    /**

     * Run the migrations.

     *

     * @return void

     */

    public function up()

    {

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

            $table->increments('id');

            $table->string('name');

            $table->timestamps();

        });

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

            $table->integer('course_id')->unsigned();

            $table->integer('study_id')->unsigned();

            $table->timestamps();

            $table->unique(['course_id', 'study_id']);

        });

    }

    /**

     * Reverse the migrations.

     *

     * @return void

     */

    public function down()

    {

        Schema::dropIfExists('courses');

        Schema::dropIfExists('course_study');

    }

}

use Illuminate\Database\Schema\Blueprint;

use Illuminate\Database\Migrations\Migration;

class CreateFamiliesTable extends Migration

{

    /**

     * Run the migrations.

     *

     * @return void

     */

    public function up()

    {

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

            $table->increments('id');

            $table->timestamps();

        });

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

            $table->integer('family_id')->unsigned();

            $table->integer('study_id')->unsigned();

            $table->timestamps();

            $table->unique(['family_id', 'study_id']);

        });

    }

    /**

     * Reverse the migrations.

     *

     * @return void

     */

    public function down()

    {

        Schema::dropIfExists('families');

        Schema::dropIfExists('family_study');

    }

}