anonymous//src/Database/Migrations/2023_01_28_154030_create_files_table.php$0 ➔ up()

Complexity

Conditions	1
Paths	1

Size

Total Lines	41
Code Lines	32

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

<?php
    public function up()
    {
        Schema::create('files', function (Blueprint $table) {
            $table->id();
            $table->uuid()->unique();
            $table->nullableMorphs('model');

            $table->string('category')->nullable();
            $table->string('filename');
            $table->string('path');
            $table->string('original_filename');
            $table->string('mime_type');
            $table->unsignedBigInteger('size');
            $table->string('source')->nullable();

            $table->timestamps();
            $table->softDeletes();

            $table->index([
                'id',
                'deleted_at',
            ], 'idx_files_find_by_id');

            $table->index([
                'uuid',
                'deleted_at',
            ], 'idx_files_find_by_uuid');

            // normal search
            $table->index([
                'model_id',
                'model_type',
                'deleted_at',
            ], 'idx_files_normal_search');

            $table->index([
                'model_id',
                'model_type',
                'category',
                'deleted_at',
            ], 'idx_files_category_search');
        });