mnoGoSearch 3.2.39 reference manual: Full-featured search engine software
Prev | Chapter 9. Miscellaneous | Next

# Database schema

The complete database schema used by mnoGoSearch is defined in the appropriate SQL-scripts for database creation located under the `create` subdirectory.

Table 9-1. server table schema

rec_id | Unique record identifier.
enabled | A flag to enable/disable the record for the indexer.
url | URL or pattern.
tag | Tag value.
category | Categories table rec_id.
command | =S - this record is a server. =F - this record is a filter.
ordre | Sorting key, defines records order for server table loading.
parent | If not null, this record is added automatically by indexer and the url field contains a server name accepted in a record pointed by this filed value.
weight | This record weight for PopRank calculation.
pop_weight | One link weight from pages of this server. Calculated automatically. Manual change will have no effect.

Other server's parameters are stored in the srvinfo table. The possible values for several of these parameters are given in the table below.

Table 9-2. Several server parameters values in srvinfo table

sname value | Possible sval values.
--- | ---
Alias | Alias used for url.
Period | Reindex period in seconds.
RemoteCharset | Default charset value.
DefaultLang | Default language value.
Request.Authorization | For basic authorization.
Request.Proxy | Proxy server to access documents from this resource.
Request.Proxy-Authorization | Proxy server authorization.
MaxHops | Maximum depth of the path in "mouse" clicks from the start url.
Index | A flag to enable/disable documents indexing.
Follow | =0, "page" =1, "path" =2, "site" =3, "world"
Robots | A flag to enable/disable `robots.txt` file use.
Clones | A flag to enable/disable "clones" detection.
MaxNetErrors | Maximum network errors for this server.
NetErrorDelayTime | Indexing delay time if a network error occurs.
ReadTimeOut | Network timeout value.
match_type | =0, UDM_MATCH_FULL - full coincidence. =1, UDM_MATCH_BEGIN - pattern is a URL prefix. =2, UDM_MATCH_SUBSTR - pattern is a URL substring. =3, UDM_MATCH_END - pattern is a URL suffix. =4, UDM_MATCH_REGEX - pattern is a regular expression. =5, UDM_MATCH_WILD - pattern is a wildcards pattern (* and ? wildcards may be used) . =6, UDM_MATCH_SUBNET - < not yet supported >.
case_sense | =1, - case insensitive comparison. =0, - case sensitive comparison.
nomatch | =1, - URLs not matching this record are accepted. =0, - URLs matching this record are accepted.

Prev | Home | Next
MySQL fulltext parser plugin | Up | Reference