Laravel實現(xiàn)數(shù)據(jù)庫遷移與支持中文的填充

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');
  // 學(xué)生名稱
  $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;

/**
 * 學(xué)生模型
 */
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()
 {
 // 調(diào)用模型工廠 生成10000條數(shù)據(jù)
 factory(App\Student::class, 10000)->create();
 }
}

?php

use Illuminate\Database\Seeder;

class DatabaseSeeder extends Seeder
{
 /**
 * Run the database seeds.
 *
 * @return void
 */
 public function run()
 {
 // 調(diào)用學(xué)生表填充文件
 $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()
 {
 // 填充中文數(shù)據(jù)
 $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