Файл: database/migrations/2020_11_11_020127_create_users_table.php
Строк: 60
<?php
use IlluminateDatabaseMigrationsMigration;
use IlluminateDatabaseSchemaBlueprint;
use IlluminateSupportFacadesSchema;
class CreateUsersTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('users', function (Blueprint $table) {
$table->bigIncrements('id');
$table->string('name');
$table->string('email')->unique();
$table->timestamp('email_verified_at')->nullable();
$table->string('password');
$table->string('api_token', 80)->nullable()->unique();
$table->string('locale', 64)->nullable();
$table->string('timezone', 64)->nullable();
$table->rememberToken();
$table->integer('role')->default(0);
$table->timestamps();
$table->string('stripe_id')->nullable();
$table->string('card_brand')->nullable();
$table->string('card_last_four', 4)->nullable();
$table->timestamp('trial_ends_at')->nullable();
$table->tinyInteger('has_websites')->default(0)->index('has_websites');
$table->tinyInteger('can_track')->default(1);
$table->tinyInteger('email_account_limit')->nullable()->default(1);
$table->softDeletes();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('users');
}
}