Add code to create maps for tags.

For a long time we had the capability to create overview maps for keys, but
never for tags (ie key-value-combinations). This commit now adds code to
create maps for frequently used tags. We can't create maps for all tags,
because each map takes about 8k in RAM and there are a lot of tags.

1 files changed, 2 insertions, 0 deletions

diff --git a/sources/db/post.sql b/sources/db/post.sql
index 0edba18..35c0a43 100644
--- a/sources/db/post.sql
+++ b/sources/db/post.sql
@@ -19,6 +19,8 @@ CREATE        INDEX key_combinations_key1_idx ON key_combinations (key1);
 CREATE        INDEX key_combinations_key2_idx ON key_combinations (key2);
 CREATE UNIQUE INDEX key_distributions_key_idx ON key_distributions (key, object_type);
 
+CREATE UNIQUE INDEX tag_distributions_key_value_idx ON tag_distributions (key, value, object_type);
+
 CREATE        INDEX tag_combinations_key1_value1_idx ON tag_combinations (key1, value1);
 CREATE        INDEX tag_combinations_key2_value2_idx ON tag_combinations (key2, value2);