Laravel数据库迁移与支持中文的填充 Laravel实现数据库迁移与支持中文的填充

php artisan make:migration create_students_table

<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreateStudentsTable extends Migration
{
 /**
 * Run the migrations.
 *
 * @return void
 */
 public function up()
 {
 // students为表名称
 Schema::create('students', function (Blueprint $table) {
  // 存储引擎
  $table->engine = 'InnoDB';
  // id自增
  $table->increments('id');
  // 学生名称
  $table->string('name');
  // 性别
  $table->string('sex');
  // 邮箱
  $table->string('email');
  // 喜爱的颜色
  $table->string('favorite_color');
  // 手机号
  $table->string('phone');
  // 地址
  $table->string('addr');
  // 自动维护时间戳
  $table->timestamps();
 });
 }

 /**
 * Reverse the migrations.
 *
 * @return void
 */
 public function down()
 {
 Schema::dropIfExists('students');
 }
}

php artisan migrate

[Illuminate\Database\QueryException]
SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was t
oo long; max key length is 767 bytes (SQL: alter table users add unique users_email_unique(email))

[PDOException]
SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was t
oo long; max key length is 767 bytes

'charset' => 'utf8',
'collation' => 'utf8_unicode_ci',

<?php
namespace App;

use Illuminate\Database\Eloquent\Model;

/**
 * 学生模型
 */
class Student extends Model
{
 
}

php artisan make:seed StudentsTableSeeder

<?php

use Illuminate\Database\Seeder;

class StudentsTableSeeder extends Seeder
{
 /**
 * Run the database seeds.
 *
 * @return void
 */
 public function run()
 {
 // 调用模型工厂 生成10000条数据
 factory(App\Student::class, 10000)->create();
 }
}

<?php

use Illuminate\Database\Seeder;

class DatabaseSeeder extends Seeder
{
 /**
 * Run the database seeds.
 *
 * @return void
 */
 public function run()
 {
 // 调用学生表填充文件
 $this->call(StudentsTableSeeder::class);
 }
}

php artisan make:factory StudentsFactory -m Student

<?php

use Faker\Generator as Faker;

/* @var Illuminate\Database\Eloquent\Factory $factory */

$factory->define(App\Student::class, function (Faker $faker) {
 $sex = rand(1, 1000);
 return [
 'name'  => $faker->name,
 'sex'  => $sex % 2 == 0 ? '男' : '女',
 'email'  => $faker->unique()->safeEmail,
 'favorite_color' => $faker->safeColorName,
 'phone'  => $faker->phoneNumber,
 'addr'  => $faker->address,
 ];
});

 public function boot()
 {
 // 填充中文数据
 $this->app->singleton(\Faker\Generator::class, function () {
  return \Faker\Factory::create('zh_CN');
 });
 }

composer dump-autoload

[ReflectionException]
Class StudentsTableSeeder does not exist

php artisan db:seed