1.使用laragon新建laravel项目 zhihu

2.配置env文件的database设置 DB_DATABASE=zhihu

3.分析users表需要的字段

4.修改数据库迁移文件:

  1 class CreateUsersTable extends Migration
2 {
3 /**
4 * Run the migrations.
5 *
6 * @return void
7 */
8 public function up()
9 {
10 Schema::create('users', function (Blueprint $table) {
11 $table->bigIncrements('id');
12 $table->string('name')->unique();
13 $table->string('email')->unique();
14 $table->timestamp('email_verified_at')->nullable();
15 $table->string('password');
16 $table->string('activation_token', 40);
17 $table->smallInteger('activated')->default(0);
18 $table->string('avatar');
19 $table->integer('questions_count')->default(0);
20 $table->integer('answers_count')->default(0);
21 $table->integer('comments_count')->default(0);
22 $table->integer('favorites_count')->default(0);
23 $table->integer('likes_count')->default(0);
24 $table->integer('followers_count')->default(0);
25 $table->integer('followings_count')->default(0);
26 $table->json('settings')->nullable();
27 $table->rememberToken();
28 $table->timestamps();
29 });
30 }
31
32 /**
33 * Reverse the migrations.
34 *
35 * @return void
36 */
37 public function down()
38 {
39 Schema::dropIfExists('users');
40 }
41 }

5.执行

  1 php artisan migrate
05-11 15:17