manelgavalda / enrollment_mobile

     *

     * @return void

     */

    public function up()

    {

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

            $table->increments('id');

            $table->integer('code');

            $table->string('name');

            $table->timestamps();

        });

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

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

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

            $table->timestamps();

            $table->unique(['user_id', 'speciality_id']);

        });

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

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

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

            $table->timestamps();

            $table->unique(['speciality_id', 'submodule_id']);

        });

    }

    /**

     * Reverse the migrations.

     *

     *

     * @return void

     */

    public function up()

    {

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

            $table->increments('id');

            $table->string('name');

            $table->boolean('selected')->nullable();

            $table->unsignedTinyInteger('order')->nullable();

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

            $table->timestamps();

            $table->unique(array('name', 'order','study_id'));

        });

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

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

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

            $table->timestamps();

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

        });

    }

    /**

     * Reverse the migrations.

     *