satrun77 / flashcard

use Illuminate\Database\Schema\Blueprint;

use Illuminate\Support\Facades\Schema;

class CreateCardTable extends Migration

{

    /**

     * Run the migrations.

     *

     * @return void

     */

    public function up()

    {

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

            $table->bigIncrements('id');

            $table->string('title');

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

            $table->boolean('active')->default(true);

            $table->text('content');

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

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

            $table->integer('category_id');

            $table->timestamps();

        });

    }

    /**

     * Reverse the migrations.

     *

     * @return void

     */

    public function down()

    {

        Schema::drop('card');

    }

}

use Illuminate\Database\Schema\Blueprint;

use Illuminate\Support\Facades\Schema;

class CreateCategoryTable extends Migration

{

    /**

     * Run the migrations.

     *

     * @return void

     */

    public function up()

    {

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

            $table->bigIncrements('id');

            $table->string('title');

            $table->boolean('active')->default(true);

            $table->string('color')->default('black');

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

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

            $table->timestamps();

        });

    }

    /**

     * Reverse the migrations.

     *

     * @return void

     */

    public function down()

    {

        Schema::drop('card_category');

    }

}