laravel 錯誤 1071 Specified key was too long; max key length is 1000 bytes

laravel 執行 php artisan migrate 安裝資料庫報

1071 Specified key was too long; max key length is 1000 bytes

資料庫不支援長位元組 需要在 AppServiceaProvider.php檔案裡面添加狀态碼191 具體代碼如下

use Illuminate\Support\Facades\Schema;  // 必須的
use Illuminate\Support\ServiceProvider;

class AppServiceProvider extends ServiceProvider
{
    /**
     * Bootstrap any application services.
     *
     * @return void
     */
    public function boot()
    {
        //  資料庫不是 mysqli的 需要寫個碼
        Schema::defaultStringLength(191); // 191
    }