Вход Регистрация
Файл: database/migrations/2018_04_20_180017_create_files_table.php
Строк: 38
<?php

use IlluminateDatabaseMigrationsMigration;
use 
IlluminateDatabaseSchemaBlueprint;
use 
IlluminateSupportFacadesSchema;

return new class extends 
Migration {
    public function 
up(): void
    
{
        if (! 
Schema::hasTable('files')) {
            
Schema::create('files', function (Blueprint $table) {
                
$table->increments('id');
                
$table->string('relate_type'20);
                
$table->integer('relate_id');
                
$table->string('path'100);
                
$table->string('name'60);
                
$table->integer('size');
                
$table->string('extension'10)->nullable();
                
$table->string('mime_type'100)->nullable();
                
$table->integer('user_id');
                
$table->dateTime('created_at')->nullable();

                
$table->index(['relate_type''relate_id']);
                
$table->index('user_id');
                
$table->index('created_at');
            });
        }
    }

    public function 
down(): void
    
{
        
Schema::dropIfExists('files');
    }
};
Онлайн: 1
Реклама