Server : Apache System : Linux server2.corals.io 4.18.0-348.2.1.el8_5.x86_64 #1 SMP Mon Nov 15 09:17:08 EST 2021 x86_64 User : corals ( 1002) PHP Version : 7.4.33 Disable Function : exec,passthru,shell_exec,system Directory :  /home/corals/ts.corals.io/corals-api/Corals/core/Foundation/update-batches/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

<?php

use \Illuminate\Database\Schema\Blueprint;

if (!\Schema::hasTable('fulltext_search')) {

    \Schema::create('fulltext_search', function (Blueprint $table) {
        $table->integer('indexable_id');
        $table->string('indexable_type');
        $table->text('indexed_title');
        $table->text('indexed_content');
        $table->unique(['indexable_type', 'indexable_id']);
        $table->engine = 'MyISAM';

        $table->unsignedInteger('created_by')->nullable()->index();
        $table->unsignedInteger('updated_by')->nullable()->index();

        $table->timestamps();
    });

    \DB::statement('ALTER TABLE fulltext_search ADD FULLTEXT fulltext_title(indexed_title)');
    \DB::statement('ALTER TABLE fulltext_search ADD FULLTEXT fulltext_title_content(indexed_title, indexed_content)');

}