sagitarius29 / laravel-subscriptions

     */

    public function up()

    {

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

            $table->engine = 'InnoDB';

            $table->increments('id');

            $table->string('name');

            $table->text('description')->nullable();

            $table->string('group', 100)->nullable();

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

            $table->tinyInteger('sort_order');

            $table->boolean('is_active')->default(0);

            $table->boolean('is_default')->default(0);

            $table->timestamps();

        });

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

            $table->engine = 'InnoDB';

            $table->timestamps();

        });

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

            $table->engine = 'InnoDB';

            $table->increments('id');

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

            $table->string('code', 100);

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

            $table->integer('sort_order');

            $table->boolean('is_consumable')->default(0);

            $table->foreign('plan_id')

                ->references('id')->on('plans');

            $table->timestamps();

        });

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

            $table->engine = 'InnoDB';

            $table->timestamps();

        });

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

            $table->engine = 'InnoDB';

            $table->increments('id');

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

            $table->string('subscriber_type');

            $table->integer('subscriber_id');

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

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

            $table->foreign('plan_feature_id')

                ->references('id')->on('plans_features');

            $table->timestamps();

        });

    }

    /**

     * Reverse the migrations.