1. In Laravel 6 database migrations, the table options do not support adding comments. See Figure 1.
2. Reference: https://stackoverflow.com/questions/37493431/how-to-add-comment-to-table-not-column-in-laravel-5-migration . How to add comment to table (not column) in Laravel 5 migration? See Figure 2.
3. The final implementation is as follows:
JSON
<?php
use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
class CreateThemeInstallationTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
$tableName = 'theme_installation';
Schema::create($tableName, function (Blueprint $table) {
$table->increments('id');
// ...
$table->timestamps();
});
DB::statement('ALTER TABLE ' . DB::connection()->getTablePrefix() . $tableName . ' COMMENT \'主题安装\'');
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('theme_installation');
}
}4. After running the database migration, checking the execution result confirms that the table comment has been successfully added. See Figure 3.
