mnoGoSearch 3.3.4 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-2. `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-3. 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 | Reporting bugs