2017年9月10日 星期日

Laravel,migration,增加欄位


/*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

沒有留言:

張貼留言