AsgardCms / Blog

use Illuminate\Database\Migrations\Migration;

use Illuminate\Database\Schema\Blueprint;

class CreatePostTagTable extends Migration

{

    /**

     * Run the migrations.

     *

     * @return void

     */

    public function up()

    {

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

            $table->engine = 'InnoDB';

            $table->integer('tag_id');

            $table->integer('post_id');

            $table->timestamps();

        });

    }

    /**

     * Reverse the migrations.

     *

     * @return void

     */

    public function down()

    {

        Schema::drop('blog__post_tag');

    }

}

use Illuminate\Database\Migrations\Migration;

use Illuminate\Database\Schema\Blueprint;

class AddStatusColumnToPostTable extends Migration

{

    /**

     * Run the migrations.

     * @return void

     */

    public function up()

    {

        Schema::table('blog__posts', function (Blueprint $table) {

            $table->engine = 'InnoDB';

            $table->integer('status')->after('category_id');

        });

    }

    /**

     * Reverse the migrations.

     * @return void

     */

    public function down()

    {

        Schema::table('blog__posts', function (Blueprint $table) {

            $table->dropColumn('status');

        });

    }

}