我需要从我的数据库表clients
中删除列UserDomainName
.
起初,我通过执行composer require doctrine/dbal
和composer update
来安装doctrine/dbal
,如documentation中所述.
然后我创建了迁移,我想用它删除列:
php artisan make:migration remove_user_domain_name_from_clients --table=clients
我在down()
方法中添加了Schema::dropColumn('UserDomainName');
:
<?php
use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
class RemoveDomainName extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::table('clients', function (Blueprint $table) {
//
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::table('clients', function (Blueprint $table) {
Schema::dropColumn('UserDomainName');
});
}
}
然而,我明白了
Migrating: 2017_08_22_135145_remove_user_domain_name_from_clients
Migrated: 2017_08_22_135145_remove_user_domain_name_from_clients
after executing php artisan migrate
but no Column is dropped.
If I execute it again I get Nothing to migrate.