wikimedia / mediawiki

	/**

	 * (MySQL only) Drops fulltext index before populating the table.

	 */

	private function dropMysqlTextIndex() {

		$searchindex = $this->db->tableName( 'searchindex' );

		if ( $this->db->indexExists( 'searchindex', 'si_title', __METHOD__ ) ) {

			$this->output( "Dropping index...\n" );

			$sql = "ALTER TABLE $searchindex DROP INDEX si_title, DROP INDEX si_text";

			$this->db->query( $sql, __METHOD__ );

		}

	}

	/**

	 * (MySQL only) Adds back fulltext index after populating the table.

	/**

	 * (MySQL only) Adds back fulltext index after populating the table.

	 */

	private function createMysqlTextIndex() {

		$searchindex = $this->db->tableName( 'searchindex' );

		$this->output( "\nRebuild the index...\n" );

		$sql = "ALTER TABLE $searchindex ADD FULLTEXT si_title (si_title), " .

			"ADD FULLTEXT si_text (si_text)";

		$this->db->query( $sql, __METHOD__ );

	}

	/**

	 * Deletes everything from search index.