Error in migration on MariaDB: Specified key was too long

[dryabov]

https://github.com/freescout-helpdesk/freescout/blob/3538a418177db6176feba4d811cbd5d688c5ad99/database/migrations/2018_07_09_053559_create_customers_table.php#L42

I'd either reduce lengths of first_name and last_name columns or rewrite up method as (WARNING: not tested!)

    public function up()
    {
        $connection = config('database.default');
        $driver = config("database.connections.{$connection}.driver");

        // https://developer.helpscout.com/mailbox-api/endpoints/customers/get/
        Schema::create('customers', function (Blueprint $table) use ($driver) {

            /* skipped */

            // Indexes
            // For ajax search
            if ($driver === 'mysql') {
                $table->index([DB::raw('first_name(191), last_name(191)')], 'customers_first_name_last_name_index');
            } else {
                $table->index(['first_name', 'last_name']);
            }
        });
    }

[freescout-helpdesk]

e2c2be7