www.gusucode.com > Flarum中文优化论坛PHP源码程序 > FlarumChina-master/vendor/flarum/core/migrations/2015_02_24_000000_create_users_table.php
<?php /* * This file is part of Flarum. * * (c) Toby Zerner <toby.zerner@gmail.com> * * For the full copyright and license information, please view the LICENSE * file that was distributed with this source code. */ use Flarum\Database\Migration; use Illuminate\Database\Schema\Blueprint; return Migration::createTable( 'users', function (Blueprint $table) { $table->increments('id'); $table->string('username', 100)->unique(); $table->string('email', 150)->unique(); $table->boolean('is_activated')->default(0); $table->string('password', 100); $table->text('bio')->nullable(); $table->string('avatar_path', 100)->nullable(); $table->binary('preferences')->nullable(); $table->dateTime('join_time')->nullable(); $table->dateTime('last_seen_time')->nullable(); $table->dateTime('read_time')->nullable(); $table->dateTime('notification_read_time')->nullable(); $table->integer('discussions_count')->unsigned()->default(0); $table->integer('comments_count')->unsigned()->default(0); } );