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 revision Previous revision
Next revision
Previous revision
start [2012/08/21 15:28]
127.0.0.1 external edit
start [2017/10/18 16:56] (current)
daniel [Database schema]
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.1345555698.txt.gz · Last modified: 2012/10/09 19:16 (external edit)