iMattPro / similartopics

	 */

	public function create_fulltext_index($field = 'topic_title')

	{

		if (!$this->is_index($field))

		{

			$sql = 'ALTER TABLE ' . TOPICS_TABLE . ' ADD FULLTEXT (' . $field . ')';

			$this->db->sql_query($sql);

		}

	}

	/**

		$driver = $this->get_driver();

		// FULLTEXT is supported and topic_title IS NOT an index

		if ($driver->is_supported() && !$driver->is_index('topic_title'))

		{

			$sql = 'ALTER TABLE ' . TOPICS_TABLE . ' ADD FULLTEXT (topic_title)';

			$this->db->sql_query($sql);

		}

	}

	/**

		$driver = $this->get_driver();

		// FULLTEXT is supported and topic_title IS an index

		if ($driver->is_supported() && $driver->is_index('topic_title'))

		{

			$sql = 'ALTER TABLE ' . TOPICS_TABLE . ' DROP INDEX topic_title';

			$this->db->sql_query($sql);

		}

	}

	/**

		$driver = new \vse\similartopics\driver\mysqli($this->db);

		// Drop the FULLTEXT index

		if ($driver->is_index('topic_title'))

		{

			$sql = 'ALTER TABLE ' . TOPICS_TABLE . ' DROP INDEX topic_title';

			$this->db->sql_query($sql);

		}

		// Revert the storage engine back to its original setting

		$sql = 'ALTER TABLE ' . TOPICS_TABLE . ' ENGINE = ' . $this->db->sql_escape(strtoupper($this->config['similar_topics_fulltext']));