数据库迁移notnull()？

Question

我使用迁移将nullable()添加到列中。

class ChangeUgIdCanNull extends Migration
{
  public function up()
  {
    Schema::table('service_request_step', function (Blueprint $table) {
      $table->dropForeign(['ug_id']);
    });
    Schema::table('service_request_step', function (Blueprint $table) {
      $table->dropIndex(['ug_id']);
    });
    Schema::table('service_request_step', function (Blueprint $table) {
      $table->integer('ug_id')->unsigned()->index()->nullable()->change();
      $table->foreign('ug_id')->references('ug_id')
            ->on('user_group')->onDelete('cascade');
    });
  }

  public function down()
  {
    Schema::table('service_request_step', function (Blueprint $table) {
      $table->dropForeign(['ug_id']);
    });
    Schema::table('service_request_step', function (Blueprint $table) {
      $table->dropIndex(['ug_id']);
    });
    Schema::table('service_request_step', function (Blueprint $table) {
      $table->integer('ug_id')->unsigned()->index()->change();
      $table->foreign('ug_id')->references('ug_id')
            ->on('user_group')->onDelete('cascade');
    });
  }
}

当我使用的时候，php artisan migrate是可以的。但是，当我想在我的数据库中php artisan migrate:rollback. 'ug_id‘列仍然是空的。我有像$table->integer('ug_id')->unsigned()->index()->notnull()->change();这样的功能吗

Laravel Version: 5.4.19
PHP Version: 7.1.3
Database Driver & Version: 10.2.4-MariaDB

Answer 1

您可以使用nullable(false)。你的代码应该是

$table->integer('ug_id')->unsigned()->index()->nullable(false)->change();