amics/database/migrations/2024_03_07_100000_create_as...

<?php

use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;
use Statamic\Eloquent\Database\BaseMigration as Migration;

return new class extends Migration
{
    public function up()
    {
        Schema::create($this->prefix('assets_meta'), function (Blueprint $table) {
            $table->id();
            $table->string('container')->index();
            $table->string('folder')->index();
            $table->string('basename')->index();
            $table->string('filename')->index();
            $table->char('extension', 10)->index();
            $table->string('path')->index();
            $table->jsonb('meta')->nullable();
            $table->timestamps();

            $table->unique(['container', 'folder', 'basename']);
        });
    }

    public function down()
    {
        Schema::dropIfExists($this->prefix('assets_meta'));
    }
};