<!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.9 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.9 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="AEN6868" ></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 > <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 > 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 > <P ><TT CLASS="literal" >yes</TT > indicates that the content of this site should be indexed. </P > <P > <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 > 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 > <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 - < not yet supported >.</P > </TD ></TR ><TR ><TD > <CODE CLASS="varname" >case_sense</CODE > </TD ><TD > <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 > <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 >