|
|
<?php
|
|
|
|
|
|
use App\Models\User;
|
|
|
use Illuminate\Support\Facades\Schema;
|
|
|
use Illuminate\Database\Schema\Blueprint;
|
|
|
use Illuminate\Database\Migrations\Migration;
|
|
|
|
|
|
class CreateUsersTable extends Migration
|
|
|
{
|
|
|
/**
|
|
|
* Run the migrations.
|
|
|
*
|
|
|
* @return void
|
|
|
*/
|
|
|
public function up()
|
|
|
{
|
|
|
Schema::create('users', function (Blueprint $table) {
|
|
|
$table->engine = 'InnoDB';
|
|
|
$table->increments('id');
|
|
|
$table->string('name', 50)->nullable();
|
|
|
$table->tinyInteger('sex')->default(\App\Enums\UserSexEnum::MAN)->commen('1为男，2为女');
|
|
|
$table->string('email', 50)->nullable();
|
|
|
$table->string('password', 60);
|
|
|
|
|
|
// 用户信息
|
|
|
$table->string('avatar')->comment('用户的头像');
|
|
|
|
|
|
// 第三方登录
|
|
|
$table->integer('github_id')->nullable()->index()->comment('github第三方登录的ID');
|
|
|
$table->string('github_name')->nullable()->comment('github第三方登录的用户名');
|
|
|
$table->string('qq_id')->nullable()->index();
|
|
|
$table->string('qq_name')->nullable();
|
|
|
$table->string('weibo_id')->nullable()->index();
|
|
|
$table->string('weibo_name')->nullable();
|
|
|
|
|
|
|
|
|
$table->integer('login_count')->default(0)->comment('登录次数');
|
|
|
$table->tinyInteger('source')->default(\App\Enums\UserSourceEnum::MOON)->comment('用户的来源');
|
|
|
|
|
|
// 用户激活所需信息
|
|
|
$table->string('active_token')->nullable()->comment('邮箱激活的token');
|
|
|
|
|
|
$table->boolean('is_active')->default(\App\Enums\UserStatusEnum::UN_ACTIVE)->comment('用户是否激活');
|
|
|
$table->boolean('is_init_name')->default(0)->comment('是否是初始用户名，是的话，可以修改用户名');
|
|
|
$table->boolean('is_init_email')->default(0)->comment('是否是初始邮箱，是的话可以修改邮箱');
|
|
|
$table->boolean('is_init_password')->default(0)->comment('是否是初始密码，是的话可以不用输入旧密码直接修改');
|
|
|
|
|
|
$table->bigInteger('score_all')->default(0)->comment('用户的总积分');
|
|
|
$table->bigInteger('score_now')->default(0)->comment('用户剩余的积分');
|
|
|
$table->integer('login_days')->default(0)->comment('用户连续登录天数');
|
|
|
$table->date('last_login_date')->nullable()->comment('上一次登录的日期,用于计算连续登录');
|
|
|
|
|
|
$table->rememberToken()->comment('laravel中的记住我');
|
|
|
$table->timestamps();
|
|
|
});
|
|
|
}
|
|
|
|
|
|
/**
|
|
|
* Reverse the migrations.
|
|
|
*
|
|
|
* @return void
|
|
|
*/
|
|
|
public function down()
|
|
|
{
|
|
|
Schema::dropIfExists('users');
|
|
|
}
|
|
|
}
|
