Sophie: mnogosearch-3.3.8-3mdv2010.0 i586

mnogosearch-3.3.8-3mdv2010.0.i586.rpm

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<HTML
><HEAD
><TITLE
>Database schema</TITLE
><META
NAME="GENERATOR"
CONTENT="Modular DocBook HTML Stylesheet Version 1.79"><LINK
REL="HOME"
TITLE="mnoGoSearch 3.3.8 reference manual"
HREF="index.html"><LINK
REL="UP"
TITLE="Miscellaneous"
HREF="msearch-misc.html"><LINK
REL="PREVIOUS"
TITLE="MySQL fulltext parser plugin"
HREF="msearch-udmstemmer.html"><LINK
REL="NEXT"
TITLE="Reporting bugs"
HREF="msearch-bugs.html"><LINK
REL="STYLESHEET"
TYPE="text/css"
HREF="mnogo.css"><META
NAME="Description"
CONTENT="mnoGoSearch - Full Featured Web site Open Source Search Engine Software over the Internet and Intranet Web Sites Based on SQL Database. It is a Free search software covered by GNU license."><META
NAME="Keywords"
CONTENT="shareware, freeware, download, internet, unix, utilities, search engine, text retrieval, knowledge retrieval, text search, information retrieval, database search, mining, intranet, webserver, index, spider, filesearch, meta, free, open source, full-text, udmsearch, website, find, opensource, search, searching, software, udmsearch, engine, indexing, system, web, ftp, http, cgi, php, SQL, MySQL, database, php3, FreeBSD, Linux, Unix, mnoGoSearch, MacOS X, Mac OS X, Windows, 2000, NT, 95, 98, GNU, GPL, url, grabbing"></HEAD
><BODY
CLASS="sect1"
BGCOLOR="#EEEEEE"
TEXT="#000000"
LINK="#000080"
VLINK="#800080"
ALINK="#FF0000"
><!--#include virtual="body-before.html"--><DIV
CLASS="NAVHEADER"
><TABLE
SUMMARY="Header navigation table"
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
><TR
><TH
COLSPAN="3"
ALIGN="center"
><SPAN
CLASS="application"
>mnoGoSearch</SPAN
> 3.3.8 reference manual: Full-featured search engine software</TH
></TR
><TR
><TD
WIDTH="10%"
ALIGN="left"
VALIGN="bottom"
><A
HREF="msearch-udmstemmer.html"
ACCESSKEY="P"
>Prev</A
></TD
><TD
WIDTH="80%"
ALIGN="center"
VALIGN="bottom"
>Chapter 12. Miscellaneous</TD
><TD
WIDTH="10%"
ALIGN="right"
VALIGN="bottom"
><A
HREF="msearch-bugs.html"
ACCESSKEY="N"
>Next</A
></TD
></TR
></TABLE
><HR
ALIGN="LEFT"
WIDTH="100%"></DIV
><DIV
CLASS="sect1"
><H1
CLASS="sect1"
><A
NAME="dbschema"
>Database schema</A
></H1
><A
NAME="AEN6593"
></A
><P
>The complete database schema used by <SPAN
CLASS="application"
>mnoGoSearch</SPAN
>
can be found in the SQL scripts in the <TT
CLASS="filename"
>/create</TT
> subdirectory
of <SPAN
CLASS="application"
>mnoGoSearch</SPAN
> sources.

<DIV
CLASS="table"
><A
NAME="db-server"
></A
><P
><B
>Table 12-2. <CODE
CLASS="varname"
>server</CODE
> table schema</B
></P
><TABLE
BORDER="1"
CLASS="CALSTABLE"
><COL><COL><THEAD
><TR
><TH
>Column name</TH
><TH
>Purpose</TH
></TR
></THEAD
><TBODY
><TR
><TD
><CODE
CLASS="varname"
>rec_id</CODE
></TD
><TD
>An unique record identifier.</TD
></TR
><TR
><TD
><CODE
CLASS="varname"
>enabled</CODE
></TD
><TD
>Indicates whether this record is to be loaded
  or ignored by <B
CLASS="command"
>indexer</B
>. Use this flag to disable entries temporarily.
  </TD
></TR
><TR
><TD
><CODE
CLASS="varname"
>url</CODE
></TD
><TD
>URL in case of <B
CLASS="command"
><A
HREF="msearch-cmdref-server.html"
>Server</A
></B
>, or an URL pattern in case
  of a filter (<B
CLASS="command"
><A
HREF="msearch-cmdref-allow.html"
>Allow</A
></B
>,
  <B
CLASS="command"
><A
HREF="msearch-cmdref-disallow.html"
>Disallow</A
></B
>, etc.).
  </TD
></TR
><TR
><TD
><CODE
CLASS="varname"
>tag</CODE
></TD
><TD
>Tag value, used to limit searches by <A
HREF="msearch-cmdref-tag.html"
>Tag</A
>.</TD
></TR
><TR
><TD
><CODE
CLASS="varname"
>category</CODE
></TD
><TD
>Category ID, referencing to the table <TT
CLASS="literal"
>Category</TT
>.</TD
></TR
><TR
><TD
><CODE
CLASS="varname"
>command</CODE
></TD
><TD
>&#13;    <P
>'<TT
CLASS="literal"
>S</TT
>' - this record defines a <CODE
CLASS="varname"
>server</CODE
>.</P
>
    <P
>'<TT
CLASS="literal"
>F</TT
>' - this record defines a <CODE
CLASS="varname"
>filter</CODE
>.</P
>
  </TD
></TR
><TR
><TD
><CODE
CLASS="varname"
>ordre</CODE
></TD
><TD
>Sorting key, <B
CLASS="command"
>indexer</B
> fetches the records from the table "<CODE
CLASS="varname"
>server</CODE
>"
  in the order of this key. Put the entries for subdirectories with smaller <CODE
CLASS="varname"
>ordre</CODE
>
  values than the entries for the entire server.
  </TD
></TR
><TR
><TD
><CODE
CLASS="varname"
>parent</CODE
></TD
><TD
>&#13;  Use <TT
CLASS="literal"
>0</TT
> for your own entries.
  A non-zero value <TT
CLASS="literal"
>N</TT
> in this column indicates that 
  this record was collected by <B
CLASS="command"
>indexer</B
> automatically,
  references to the parent record with <CODE
CLASS="varname"
>url_id</CODE
>=<TT
CLASS="literal"
>N</TT
>.
  </TD
></TR
><TR
><TD
><CODE
CLASS="varname"
>weight</CODE
></TD
><TD
>The weight of this record for PopRank calculation.</TD
></TR
><TR
><TD
><CODE
CLASS="varname"
>pop_weight</CODE
></TD
><TD
>The weight of the outgoing links of this server.
  This value is calculated automatically. Manual changes will have no effect.
  </TD
></TR
></TBODY
></TABLE
></DIV
>
</P
><P
>The other server parameters are stored in the <CODE
CLASS="varname"
>srvinfo</CODE
> table.
Possible values for some parameters are given in the table below.
Most of them have similar effect with the corresponding <TT
CLASS="filename"
>indexer.conf</TT
>
commands.

<DIV
CLASS="table"
><A
NAME="db-srvinfo"
></A
><P
><B
>Table 12-3. Server parameters in the table <CODE
CLASS="varname"
>srvinfo</CODE
>.</B
></P
><TABLE
BORDER="1"
CLASS="CALSTABLE"
><COL><COL><THEAD
><TR
><TH
><CODE
CLASS="varname"
>sname</CODE
> value</TH
><TH
>Possible <CODE
CLASS="varname"
>sval</CODE
> values.</TH
></TR
></THEAD
><TBODY
><TR
><TD
><CODE
CLASS="varname"
>Alias</CODE
></TD
><TD
>An alias used for the <CODE
CLASS="varname"
>URL</CODE
>, in case of a server
  definition.
  </TD
></TR
><TR
><TD
><CODE
CLASS="varname"
>Period</CODE
></TD
><TD
>Reindexing period in seconds.</TD
></TR
><TR
><TD
><CODE
CLASS="varname"
>RemoteCharset</CODE
>
  </TD
><TD
>Default character set value.
  </TD
></TR
><TR
><TD
><CODE
CLASS="varname"
>DefaultLang</CODE
></TD
><TD
>Default language value.</TD
></TR
><TR
><TD
><CODE
CLASS="varname"
>DetectClones</CODE
></TD
><TD
>Indicates whether to detect clones for this site.</TD
></TR
><TR
><TD
><CODE
CLASS="varname"
>Request.Authorization</CODE
></TD
><TD
>For basic authorization.</TD
></TR
><TR
><TD
><CODE
CLASS="varname"
>Request.Proxy</CODE
></TD
><TD
>Proxy server to access documents from this resource.</TD
></TR
><TR
><TD
><CODE
CLASS="varname"
>Request.Proxy-Authorization</CODE
></TD
><TD
>Proxy server authorization.</TD
></TR
><TR
><TD
><CODE
CLASS="varname"
>MaxHops</CODE
></TD
><TD
>Maximum depth of the path in "mouse" clicks from the start URL.</TD
></TR
><TR
><TD
><CODE
CLASS="varname"
>Index</CODE
></TD
><TD
>&#13;    <P
><TT
CLASS="literal"
>yes</TT
> indicates that the content of
    this site should be indexed.
    </P
>
    <P
>&#13;     <TT
CLASS="literal"
>no</TT
> indicates that the site content should not be indexed,
     but the outgoing links should be collected.
    </P
>
   </TD
></TR
><TR
><TD
><CODE
CLASS="varname"
>Follow</CODE
></TD
><TD
>&#13;    Corresponds to the <CODE
CLASS="varname"
>Subsection</CODE
> argument of
    the command <B
CLASS="command"
><A
HREF="msearch-cmdref-server.html"
>Server</A
></B
>.
    <P
><TT
CLASS="literal"
>0</TT
> - "page"</P
>
    <P
><TT
CLASS="literal"
>1</TT
> - "path"</P
>
    <P
><TT
CLASS="literal"
>2</TT
> - "site"</P
>
    <P
><TT
CLASS="literal"
>3</TT
> - "world"</P
>
  </TD
></TR
><TR
><TD
><CODE
CLASS="varname"
>Robots</CODE
></TD
><TD
>Indicates whether <TT
CLASS="filename"
>robots.txt</TT
> should be
  downloaded and processed for this site.
  </TD
></TR
><TR
><TD
><CODE
CLASS="varname"
>MaxNetErrors</CODE
></TD
><TD
>Maximum network errors for this server.</TD
></TR
><TR
><TD
><CODE
CLASS="varname"
>NetErrorDelayTime</CODE
></TD
><TD
>Crawler delay time when a network error occurs for this server.</TD
></TR
><TR
><TD
><CODE
CLASS="varname"
>ReadTimeOut</CODE
></TD
><TD
>Network timeout value.</TD
></TR
><TR
><TD
><CODE
CLASS="varname"
>match_type</CODE
></TD
><TD
>&#13;    <P
>=0, UDM_MATCH_FULL - full match (<TT
CLASS="literal"
>Server page</TT
>).</P
>
    <P
>=1, UDM_MATCH_BEGIN - pattern is a URL prefix (<TT
CLASS="literal"
>Server path</TT
>).</P
>
    <P
>=2, UDM_MATCH_SUBSTR - pattern is a URL substring.</P
>
    <P
>=3, UDM_MATCH_END - pattern is a URL suffix.</P
>
    <P
>=4, UDM_MATCH_REGEX - pattern is a regular expression (<TT
CLASS="literal"
>Realm regex</TT
>).</P
>
    <P
>=5, UDM_MATCH_WILD - a wildcard pattern with * and ? wildcards
    (<TT
CLASS="literal"
>Realm string</TT
>).
    </P
>
<P
>=6, UDM_MATCH_SUBNET - &#60; not yet supported &#62;.</P
>
</TD
></TR
><TR
><TD
>&#13;    <CODE
CLASS="varname"
>case_sense</CODE
>
  </TD
><TD
>&#13;    <P
><TT
CLASS="literal"
>1</TT
> - case insensitive match.</P
>
    <P
><TT
CLASS="literal"
>0</TT
> - case sensitive match.</P
>
  </TD
></TR
><TR
><TD
><CODE
CLASS="varname"
>nomatch</CODE
></TD
><TD
>&#13;    <P
><TT
CLASS="literal"
>1</TT
> - URLs not matching this record are accepted.</P
>
    <P
><TT
CLASS="literal"
>0</TT
> - URLs matching this record are accepted.</P
>
  </TD
></TR
></TBODY
></TABLE
></DIV
>
</P
></DIV
><DIV
CLASS="NAVFOOTER"
><HR
ALIGN="LEFT"
WIDTH="100%"><TABLE
SUMMARY="Footer navigation table"
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
><A
HREF="msearch-udmstemmer.html"
ACCESSKEY="P"
>Prev</A
></TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="index.html"
ACCESSKEY="H"
>Home</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
><A
HREF="msearch-bugs.html"
ACCESSKEY="N"
>Next</A
></TD
></TR
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
><SPAN
CLASS="application"
>MySQL</SPAN
> fulltext parser plugin</TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="msearch-misc.html"
ACCESSKEY="U"
>Up</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
>Reporting bugs</TD
></TR
></TABLE
></DIV
><!--#include virtual="body-after.html"--></BODY
></HTML
>