User Tools

Site Tools


start

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
start [2012/02/22 15:23] – [SQL tips and queries] danielstart [2017/10/18 14:56] (current) – [Database schema] daniel
Line 3: Line 3:
  
 ===== manitou-mdx ===== ===== manitou-mdx =====
-manitou-mdx is a Perl program that is responsible for importing incoming mail into the database, and exporting outgoing mail to a [[http://en.wikipedia.org/wiki/Mail_transfer_agent|Mail Transfert Agent]]. MDX stands for **M**ail **D**atabase e**X**changer. It is supposed to run as a daemon (always running in background) although it can also be invoked as a normal command to import existing mailboxes.\\ +manitou-mdx is a Perl program that is responsible for importing incoming mail into the database, and exporting outgoing mail to a [[http://en.wikipedia.org/wiki/Mail_transfer_agent|Mail Transfert Agent]]. MDX stands for **M**ail **D**atabase e**X**changer. It generally runs as a daemon (a permanent process in background) although it can also be invoked as a normal command to import existing mailboxes.\\ 
 Its functionalities can be vastly extended by user-contributed plugins written in the Perl language.\\  Its functionalities can be vastly extended by user-contributed plugins written in the Perl language.\\ 
  
Line 9: Line 9:
  
 Additional information is available on this wiki: Additional information is available on this wiki:
-  * [[mdx_debian_package|Debian package]] How to create a debian package from scratch for manitou-mdx +  * [[mdx_debian_package|Debian package]] How to create a debian package from scratch for manitou-mdx. 
-  * [[mdx_filters|Filters]] On the use of server-side mail filters+  * [[mdx_filters|Filters]] On the use of server-side mail filters
 +  * [[mdx_word_extractors|Word extractors]] External scripts that extract text from attachments for the full-text indexer.
  
 The [[mdx_plugins|Plugins page]] provides documentation and sample plugins. The [[mdx_plugins|Plugins page]] provides documentation and sample plugins.
Line 27: Line 28:
 </code> </code>
  
-A visual representation of the schema can be seen on [[http://www.manitou-mail.org/articles/db-diagram.html|this diagram]] (although it's not current, it doesn't differ that much from newer versions of the schema)+A visual representation of the schema can be seen on [[http://www.manitou-mail.org/screenshots/db-diagram.png|this diagram]]   
 + 
 +[[access_rights|Access rights]] Scripts to grant access rights for multi-user installations. For the latest version.
  
 ==== Version 1.0.0 and above ==== ==== Version 1.0.0 and above ====
Line 36: Line 39:
 "Latest" here means the latest known to the manitou-mgr command. "Latest" here means the latest known to the manitou-mgr command.
  
-[[schema_1_0_0_grants|Access rights]] Scripts to grant access rights for multi-user installations 
  
  
Line 45: Line 47:
  
 ===== SQL tips and queries ===== ===== SQL tips and queries =====
-[[sample_user_queries|Sample user queries]] for the Quick Selection panel in the user interface \\+[[sample_user_queries|Sample user queries (easy)]], with the Quick Selection panel in the user interface \\ 
 +[[adv_sample_user_queries_plus|Sample user queries (advanced)]] \\
 [[sql_analysis|Queries for analysis]] \\ [[sql_analysis|Queries for analysis]] \\
 +[[sql_analysis_dedup_attachments|Analyzing the attachments deduplication]] \\
 [[inverted_word_index|Querying the full text search index]] \\ [[inverted_word_index|Querying the full text search index]] \\
-[[support_functions|Support functions]] +[[support_functions|Support functions]] \\ 
 +[[sql_basic_stats|Basic statistics]]
  
start.1329924224.txt.gz · Last modified: 2012/02/22 15:23 by daniel