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_enabled')->default(0);

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

            $table->timestamps();

        });

        Schema::create('plan_intervals', 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')->nullable();

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

            $table->foreign('plan_id')

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

                ->onDelete('cascade');

            $table->timestamps();

        });

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

            $table->engine = 'InnoDB';