code: def create_fulltext_index(self,
                                table: str,
                                field: str,
                                indexname: str = None) -> Optional[int]:
          
          if indexname is None:
              indexname = "_idxft_{}".format(field)
          if self.index_exists(table, indexname):
              return None
          sql = "CREATE FULLTEXT INDEX {} ON {} ({})".format(indexname, table,
                                                             field)
          return self.db_exec(sql)
docs: Creates a FULLTEXT index (default name _idxft_FIELDNAME), unless it
          exists already. See:
  
          http://dev.mysql.com/doc/refman/5.6/en/innodb-fulltext-index.html
          http://dev.mysql.com/doc/refman/5.0/en/fulltext-search.html