Файл: database/migrations/2018_04_20_180003_create_banhist_table.php
Строк: 40
<?php
declare(strict_types=1);
use AppModelsBanhist;
use IlluminateDatabaseMigrationsMigration;
use IlluminateDatabaseSchemaBlueprint;
use IlluminateSupportFacadesSchema;
final class CreateBanhistTable extends Migration
{
/**
* Migrate Up.
*/
public function up(): void
{
if (! Schema::hasTable('banhist')) {
Schema::create('banhist', function (Blueprint $table) {
$table->increments('id');
$table->integer('user_id');
$table->integer('send_user_id');
$table->enum('type', [Banhist::BAN, Banhist::UNBAN, Banhist::CHANGE]);
$table->text('reason');
$table->integer('term')->default(0);
$table->integer('created_at');
$table->boolean('explain')->default(false);
$table->index('user_id');
$table->index('created_at');
});
}
}
/**
* Migrate Down.
*/
public function down(): void
{
Schema::dropIfExists('banhist');
}
}