manelgavalda / enrollment_mobile

/**

 * Class CreateActivitiesTable

 */

class CreateActivitiesTable extends Migration

{

    /**

     * Run the migrations.

     *

     * @return void

     */

    public function up()

    {

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

            $table->increments('id');

            $table->unsignedInteger('user_id')->index();

            $table->unsignedInteger('subject_id')->index();

            $table->string('subject_type', 50);

            $table->string('type', 50);

            $table->timestamps();

        });

    }

    /**

     * Reverse the migrations.

     *

     * @return void

     */

    public function down()

    {

        Schema::dropIfExists('activities');

    }

}

use Illuminate\Database\Schema\Blueprint;

use Illuminate\Database\Migrations\Migration;

class CreateClassroomsTable extends Migration

{

    /**

     * Run the migrations.

     *

     * @return void

     */

    public function up()

    {

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

            $table->increments('id');

            $table->string('name');

            $table->timestamps();

            $table->integer('enrollment_id')->unsigned()->nullable();

            $table->integer('submodule_id')->unsigned()->nullable();

        });

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

//            $table->integer('classroom_id')->unsigned();

//            $table->integer('enrollment_id')->unsigned();

//            $table->timestamps();

//            $table->unique(['classroom_id', 'enrollment_id']);

//        });

    }

    /**

     * Reverse the migrations.

     *

     * @return void

     */

    public function down()

    {

        Schema::dropIfExists('classrooms');

    }

}