Changes

Jump to: navigation, search

User:Hef/rt search

40 bytes removed, 23:39, 26 August 2014
More output
== Create Table ==
 
<pre>
CREATE TABLE AttachmentsIndex
(
id INTEGER UNSIGNED BIGINT NOT NULL,
weight INTEGER NOT NULL,
query VARCHAR(3072) NOT NULL,
group_id INTEGER,
INDEX(query)
) ENGINE=SPHINX CONNECTION="sphinx://localhost127.0.0.1:9312/testrt"CHARACTER SET utf8;</pre>
== More output ==
<pre>
You can now configure RT to use the newly-created full-text index byadding the I added The following to your RT_SiteConfig.pm:
<pre>
Set( %FullTextSearch,
Enable => 1,
Table => 'AttachmentsIndex',
);
</pre>
Below is a simple Sphinx configuration which can be used to index all
ideal; you should read the Sphinx documentation to understand how to
configure it to better suit your needs.
<pre>
source rt {
unlink_old = 1
}
 
</pre>
 
== Prime things ==

Navigation menu