:::
4-1 database\migrations\2014_10_12_000000_create_users_table.php
4-2 database\migrations\2019_06_21_144827_change_users_table.php
<?php
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;
class ChangeUsersTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::table('users', function (Blueprint $table) {
// 在 password 欄位後面新增 address 欄位
$table->string('address')->after('password');
// 在 address 欄位後面新增 tel 欄位
$table->string('tel')->after('address');
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::table('users', function (Blueprint $table) {
$table->dropColumn('tel');
$table->dropColumn('address');
});
}
}
