Each time I add a new MySQL InnoDB index of type ‘Full Text’ and then re-save the custom DocType, the index is removed.
For example, I have build a custom DocType named Member…
SELECT name,member_name, MATCH (member_name) AGAINST (‘Palmer Logitics’ IN NATURAL LANGUAGE MODE) AS score FROM tabMember order by score desc;