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 [2013/11/05 11:59] – [Database schema] danielstart [2017/10/18 14:56] (current) – [Database schema] daniel
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]]  
  
-[[schema_grants|Access rights|]] for the latest version.+[[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 39: 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 48: 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.1383652740.txt.gz · Last modified: 2013/11/05 11:59 by daniel