<HTML ><HEAD ><TITLE >Database schema</TITLE ><META NAME="GENERATOR" CONTENT="Modular DocBook HTML Stylesheet Version 1.73 "><LINK REL="HOME" TITLE="mnoGoSearch 3.2 reference manual" HREF="index.html"><LINK REL="UP" TITLE="Miscellaneous" HREF="msearch-misc.html"><LINK REL="PREVIOUS" TITLE="Using libudmsearch library " HREF="msearch-lib.html"><LINK REL="NEXT" TITLE="Index" HREF="msearch-index.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" ><DIV CLASS="NAVHEADER" ><TABLE SUMMARY="Header navigation table" WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" ><TR ><TH COLSPAN="3" ALIGN="center" >mnoGoSearch 3.2 reference manual: Full-featured search engine software</TH ></TR ><TR ><TD WIDTH="10%" ALIGN="left" VALIGN="bottom" ><A HREF="msearch-lib.html" ACCESSKEY="P" >Prev</A ></TD ><TD WIDTH="80%" ALIGN="center" VALIGN="bottom" >Chapter 9. Miscellaneous</TD ><TD WIDTH="10%" ALIGN="right" VALIGN="bottom" ><A HREF="msearch-index.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="AEN3778" ></A ><P >Full database schema used by <SPAN CLASS="application" >mnoGoSearch</SPAN > is defined in appropriate sql-scipts for database creation located under <TT CLASS="filename" >create</TT > subdirectory. <DIV CLASS="table" ><A NAME="db-server" ></A ><P ><B >Table 9-1. <TT CLASS="varname" >server</TT > table schema</B ></P ><TABLE BORDER="1" CLASS="CALSTABLE" ><TBODY ><TR ><TD ALIGN="LEFT" VALIGN="MIDDLE" ><TT CLASS="varname" >rec_id</TT ></TD ><TD ALIGN="LEFT" VALIGN="MIDDLE" >Unique record identificator.</TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="MIDDLE" ><TT CLASS="varname" >enabled</TT ></TD ><TD ALIGN="LEFT" VALIGN="MIDDLE" >A flag to enable/disable record for <B CLASS="command" >indexer</B >. </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="MIDDLE" ><TT CLASS="varname" >url</TT ></TD ><TD ALIGN="LEFT" VALIGN="MIDDLE" >URL or pattern.</TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="MIDDLE" ><TT CLASS="varname" >alias</TT ></TD ><TD ALIGN="LEFT" VALIGN="MIDDLE" >Alias used for <TT CLASS="varname" >url</TT >.</TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="MIDDLE" ><TT CLASS="varname" >period</TT ></TD ><TD ALIGN="LEFT" VALIGN="MIDDLE" >Reindex period. </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="MIDDLE" ><TT CLASS="varname" >tag</TT ></TD ><TD ALIGN="LEFT" VALIGN="MIDDLE" >Tag value.</TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="MIDDLE" ><TT CLASS="varname" >category</TT ></TD ><TD ALIGN="LEFT" VALIGN="MIDDLE" >Category value.</TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="MIDDLE" ><TT CLASS="varname" >charset</TT ></TD ><TD ALIGN="LEFT" VALIGN="MIDDLE" >Default charset value.</TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="MIDDLE" ><TT CLASS="varname" >lang</TT ></TD ><TD ALIGN="LEFT" VALIGN="MIDDLE" >Default language value.</TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="MIDDLE" ><TT CLASS="varname" >basic_auth</TT ></TD ><TD ALIGN="LEFT" VALIGN="MIDDLE" >For basic authorozation.</TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="MIDDLE" ><TT CLASS="varname" >proxy</TT ></TD ><TD ALIGN="LEFT" VALIGN="MIDDLE" >Proxy server to access documents from this resource.</TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="MIDDLE" ><TT CLASS="varname" >proxy_port</TT ></TD ><TD ALIGN="LEFT" VALIGN="MIDDLE" >Proxy server port.</TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="MIDDLE" ><TT CLASS="varname" >proxy_auth</TT ></TD ><TD ALIGN="LEFT" VALIGN="MIDDLE" >Proxy server autorization.</TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="MIDDLE" ><TT CLASS="varname" >maxhops</TT ></TD ><TD ALIGN="LEFT" VALIGN="MIDDLE" >Maximum depth of way in "mouse" clicks from start url.</TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="MIDDLE" ><TT CLASS="varname" >gindex</TT ></TD ><TD ALIGN="LEFT" VALIGN="MIDDLE" >A flag to enable/disable documents indexing.</TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="MIDDLE" ><TT CLASS="varname" >follow</TT ></TD ><TD ALIGN="LEFT" VALIGN="MIDDLE" >A flag to enable/disable links following.</TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="MIDDLE" ><TT CLASS="varname" >deletebad</TT ></TD ><TD ALIGN="LEFT" VALIGN="MIDDLE" >.</TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="MIDDLE" ><TT CLASS="varname" >use_robots</TT ></TD ><TD ALIGN="LEFT" VALIGN="MIDDLE" >A flag to enable/disable <TT CLASS="filename" >robots.txt</TT > file using.</TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="MIDDLE" ><TT CLASS="varname" >use_clones</TT ></TD ><TD ALIGN="LEFT" VALIGN="MIDDLE" >A flag to enable/disable "clones" detection.</TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="MIDDLE" ><TT CLASS="varname" >max_net_errors</TT ></TD ><TD ALIGN="LEFT" VALIGN="MIDDLE" >Maximum network errors for this server.</TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="MIDDLE" ><TT CLASS="varname" >net_delay_time</TT ></TD ><TD ALIGN="LEFT" VALIGN="MIDDLE" >Indexing delay time if a network error is occured.</TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="MIDDLE" ><TT CLASS="varname" >read_timeout</TT ></TD ><TD ALIGN="LEFT" VALIGN="MIDDLE" >Network timeout value.</TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="MIDDLE" ><TT CLASS="varname" >command</TT ></TD ><TD ALIGN="LEFT" VALIGN="MIDDLE" > <P >=S - this record is a <TT CLASS="varname" >server</TT >.</P > <P >=F - this record is a <TT CLASS="varname" >filter</TT >.</P > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="MIDDLE" ><TT CLASS="varname" >match_type</TT ></TD ><TD ALIGN="LEFT" VALIGN="MIDDLE" > <P >=0, UDM_MATCH_FULL - full coincedence.</P > <P >=1, UDM_MATCH_BEGIN - pattern is a URL prefix.</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.</P > <P >=5, UDM_MATCH_WILD - pattern is a wildcards pattern (* and ? wildcards may be used) .</P > <P >=6, UDM_MATCH_SUBNET - < not yet supported >.</P > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="MIDDLE" ><TT CLASS="varname" >case_sense</TT ></TD ><TD ALIGN="LEFT" VALIGN="MIDDLE" > <P >=1, - case insensitive comparison.</P > <P >=0, - case sensitive comparison.</P > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="MIDDLE" ><TT CLASS="varname" >nomatch</TT ></TD ><TD ALIGN="LEFT" VALIGN="MIDDLE" > <P >=1, - URLs not matchs this record is accepted.</P > <P >=0, - URL match this record is accepted.</P > </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="MIDDLE" ><TT CLASS="varname" >ordre</TT ></TD ><TD ALIGN="LEFT" VALIGN="MIDDLE" >Sorting key, it define records order for <TT CLASS="varname" >server</TT > table loading. </TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="MIDDLE" ><TT CLASS="varname" >parent</TT ></TD ><TD ALIGN="LEFT" VALIGN="MIDDLE" >If not null, this record is added automaticaly by <B CLASS="command" >indexer</B > and <TT CLASS="varname" >url</TT > field contain a server name accepted on record pointed by this filed value.</TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="MIDDLE" ><TT CLASS="varname" >weight</TT ></TD ><TD ALIGN="LEFT" VALIGN="MIDDLE" >This record weight for PopRank calculation.</TD ></TR ><TR ><TD ALIGN="LEFT" VALIGN="MIDDLE" ><TT CLASS="varname" >pop_weight</TT ></TD ><TD ALIGN="LEFT" VALIGN="MIDDLE" >One link weight from pages of this server. Calculated automaticaly. Manualy change will have no effect.</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-lib.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-index.html" ACCESSKEY="N" >Next</A ></TD ></TR ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" >Using libudmsearch library <A NAME="AEN3756" ></A ></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" >Index</TD ></TR ></TABLE ></DIV ></BODY ></HTML >