Differences

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

--- start [2013/11/05 11:59] – [Database schema] daniel
+++ start [2017/10/18 14:56] (current) – [Database schema] daniel
@@ Line 28: / Line 28: @@
 </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 ====
@@ Line 39: / Line 39: @@
 "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 =====
-[[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_dedup_attachments|Analyzing the attachments deduplication]] \\
 [[inverted_word_index|Querying the full text search index]] \\
-[[support_functions|Support functions]]
+[[support_functions|Support functions]] \\
+[[sql_basic_stats|Basic statistics]]