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 [2013/11/05 13:00]
daniel [Version 1.0.0 and above]
start [2017/10/18 16:56] (current)
daniel [Database schema]
Line 28: 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. [[access_rights|Access rights]] Scripts to grant access rights for multi-user installations. For the latest version.
Line 47: 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.1383652816.txt.gz · Last modified: 2013/11/05 13:00 by daniel