PHP編程
php artisan make:migration create_users_table
php artisan make:migration create_users_table --create=users
php artisan make:migration add_votes_to_users_table --table=users

PHP編程
<?php
use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
class CreateUsersTable extends Migration
{
  /**
   * 運(yùn)行數(shù)據(jù)庫(kù)遷移
   *
   * @return void
   */
  public function up()
  {
    //
      Schema::create('users',function (Blueprint $table){
        $table->increments('id')->comment('遞增ID');
        $table->string('email',60)->comment('會(huì)員Email');
        $table->string('phone',20)->comment('會(huì)員手機(jī)號(hào)');
        $table->string('username',60)->comment('用戶名');
        $table->string('password',32)->comment('用戶密碼');
        $table->char('rank',10)->comment('會(huì)員等級(jí)');
        $table->unsignedSmallInteger('sex')->comment('性別;0保密;1男;2女');
        $table->unsignedSmallInteger('status')->comment('用戶狀態(tài)');
        $table->ipAddress('last_ip')->default('0.0.0.0')->comment('最后一次登錄IP');
        $table->timeTz('last_login')->comment('最后一次登錄時(shí)間');
        $table->timestamps();
      });
  }
  /**
   * 回滾數(shù)據(jù)庫(kù)遷移
   *
   * @return void
   */
  public function down()
  {
    //
    Schema::drop('users');
  }
}

PHP編程
if (Schema::hasTable('users')) {
  //
}
if (Schema::hasColumn('users', 'email')) {
  //
}

PHP編程
Schema::connection('foo')->create('users', function (Blueprint $table) {
  $table->increments('id');
});

PHP編程
Schema::create('users', function (Blueprint $table) {
  $table->engine = 'InnoDB';
  $table->increments('id');
});

PHP編程
Schema::rename($from, $to);//重命名
//刪除已存在的數(shù)據(jù)表
Schema::drop('users');
Schema::dropIfExists('users');

PHP編程
Schema::table('users', function (Blueprint $table) {
  $table->string('email');
});

PHP編程
Schema::table('users', function (Blueprint $table) {
  $table->string('email')->nullable();
});

PHP編程
Schema::table('users', function (Blueprint $table) {
  $table->string('phone',20)->change();
  $table->string('username',60)->->nullable()->change();
});

PHP編程
Schema::table('users', function (Blueprint $table) {
  $table->renameColumn('from', 'to');
});

PHP編程
Schema::table('users', function (Blueprint $table) {
  $table->dropColumn(['last_ip', 'last_login']);
});

PHP編程
composer require doctrine/dbal

PHP編程
$table->string('email')->unique();

PHP編程
Schema::enableForeignKeyConstraints();
Schema::disableForeignKeyConstraints();

PHP編程
php artisan migrate

PHP編程
php artisan migrate --force

PHP編程
php artisan migrate:rollback

PHP編程
php artisan migrate:rollback --step=5

PHP編程
php artisan migrate:reset

PHP編程
php artisan migrate:refresh
// 刷新數(shù)據(jù)庫(kù)結(jié)構(gòu)并執(zhí)行數(shù)據(jù)填充
php artisan migrate:refresh --seed

PHP編程
php artisan migrate:refresh --step=5