Laravel 命令执行 php artisan migrate 命令时,报错:
Illuminate\Database\QueryException :
SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long;
max key length is 1000 bytes (SQL: alter table `users` add unique `users_email_unique`(`email`))
解决方法
修改 app/Providers/AppServiceProvider.php 文件中添加如下内容:
namespace App\Providers;
use Illuminate\Support\ServiceProvider;
use Illuminate\Support\Facades\Schema;
class AppServiceProvider extends ServiceProvider
{
public function register()
{
}
public function boot()
{
Schema::defaultStringLength(191);
}
}
修改部分
Schema::defaultStringLength(191);