Bug倉庫 // 程式日記

/*cmd指令*/
 php artisan make:migration add_is_admin_column_to_posts_tables

<?php
/*檔案：2017_08_23_160802_add_is_admin_column_to_posts_tables.php*/

use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class AddIsAdminColumnToPostsTables extends Migration
{

    public function up()
    {
        Schema::table('posts', function (Blueprint $table) {
            //can't be negative number
            $table->tinyInteger('is_admin')->default('0');
        });
    }

    public function down()
    {
        Schema::table('posts', function (Blueprint $table) {
            //
            $table->dropColumn('is_admin');
        });
    }
}

/*cmd指令*/
 php artisan migrate