Differences

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

--- start [2013/11/05 12:00] – [Version 1.0.0 and above] 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]]
 [[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 =====
-[[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]]