Fulltext index on one column

yabhq / laravel-scout-mysql-driver

Laravel Scout MySQL Driver

MIT License

522 stars 113 forks source link

Fulltext index on one column #43

Open dominik04u opened 7 years ago

dominik04u commented 7 years ago

How to make fulltext index on only one column? When I call php artisan scout:mysql-index it returns fulltext index from all text and varchar columns.

Barcelonczyk commented 7 years ago

I think it's better to use laravel migartions to create fulltext indexes instead of artisan command. Using migrations you'll have all changes in version control system.

olivernybroe commented 6 years ago

can't we just add it in migrations like this DB::statement('ALTER TABLE posts ADD FULLTEXT INDEX fulltextNameIndex (name)');?