我用unsigned user_id创建了一个迁移。我如何编辑user_id在一个新的迁移，也使它为空()?
Schema::create('throttle', function(Blueprint $table)
{
$table->increments('id');
// this needs to also be nullable, how should the next migration be?
$table->integer('user_id')->unsigned();
}
当前回答
加上Dmitri Chebotarev的答案，Laravel 5+。
在要求doctrine/dbal包后:
composer require doctrine/dbal
然后你可以使用可空列进行迁移，如下所示:
public function up()
{
Schema::table('users', function (Blueprint $table) {
// change() tells the Schema builder that we are altering a table
$table->integer('user_id')->unsigned()->nullable()->change();
});
}
要恢复操作，请执行:
public function down()
{
/* turn off foreign key checks for a moment */
DB::statement('SET FOREIGN_KEY_CHECKS = 0');
/* set null values to 0 first */
DB::statement('UPDATE `users` SET `user_id` = 0 WHERE `user_id` IS NULL;');
/* alter table */
DB::statement('ALTER TABLE `users` MODIFY `user_id` INTEGER UNSIGNED NOT NULL;');
/* finally turn foreign key checks back on */
DB::statement('SET FOREIGN_KEY_CHECKS = 1');
}
其他回答
您需要首先安装doctrine/dbal包。
composer require doctrine/dbal
然后使用change()方法 例如:
Schema::table('posts', function (Blueprint $table) {
$table->unsignedBigInteger('user_id')->nullable()->change();
});
注意，这只在Laravel 5+中是可能的。
首先，你需要doctrine/dbal包:
composer require doctrine/dbal
现在在你的迁移中，你可以这样做，使列为空:
public function up()
{
Schema::table('users', function (Blueprint $table) {
// change() tells the Schema builder that we are altering a table
$table->integer('user_id')->unsigned()->nullable()->change();
});
}
您可能想知道如何恢复此操作。遗憾的是，不支持这种语法:
// Sadly does not work :'(
$table->integer('user_id')->unsigned()->change();
这是恢复迁移的正确语法:
$table->integer('user_id')->unsigned()->nullable(false)->change();
或者，如果你喜欢，你可以写一个原始查询:
public function down()
{
/* Make user_id un-nullable */
DB::statement('UPDATE `users` SET `user_id` = 0 WHERE `user_id` IS NULL;');
DB::statement('ALTER TABLE `users` MODIFY `user_id` INTEGER UNSIGNED NOT NULL;');
}
如果你碰巧改变了这些列
'Doctrine\DBAL\Driver\PDOMySql\Driver' not found
然后安装
作曲家需要学说
加上Dmitri Chebotarev的答案，Laravel 5+。
在要求doctrine/dbal包后:
composer require doctrine/dbal
然后你可以使用可空列进行迁移，如下所示:
public function up()
{
Schema::table('users', function (Blueprint $table) {
// change() tells the Schema builder that we are altering a table
$table->integer('user_id')->unsigned()->nullable()->change();
});
}
要恢复操作，请执行:
public function down()
{
/* turn off foreign key checks for a moment */
DB::statement('SET FOREIGN_KEY_CHECKS = 0');
/* set null values to 0 first */
DB::statement('UPDATE `users` SET `user_id` = 0 WHERE `user_id` IS NULL;');
/* alter table */
DB::statement('ALTER TABLE `users` MODIFY `user_id` INTEGER UNSIGNED NOT NULL;');
/* finally turn foreign key checks back on */
DB::statement('SET FOREIGN_KEY_CHECKS = 1');
}
再加上德米特里·切波塔列夫的回答，
如果你想一次修改多个列，你可以像下面这样做
DB::statement('
ALTER TABLE `events`
MODIFY `event_date` DATE NOT NULL,
MODIFY `event_start_time` TIME NOT NULL,
MODIFY `event_end_time` TIME NOT NULL;
');
