summaryrefslogtreecommitdiff
path: root/sources/db/pre.sql
diff options
context:
space:
mode:
Diffstat (limited to 'sources/db/pre.sql')
-rw-r--r--sources/db/pre.sql13
1 files changed, 13 insertions, 0 deletions
diff --git a/sources/db/pre.sql b/sources/db/pre.sql
index 03e6b23..2b80a84 100644
--- a/sources/db/pre.sql
+++ b/sources/db/pre.sql
@@ -81,3 +81,16 @@ CREATE TABLE keypairs (
count_relations INTEGER
);
+DROP TABLE IF EXISTS tagpairs;
+
+CREATE TABLE tagpairs (
+ key1 VARCHAR,
+ value1 VARCHAR,
+ key2 VARCHAR,
+ value2 VARCHAR,
+ count_all INTEGER,
+ count_nodes INTEGER,
+ count_ways INTEGER,
+ count_relations INTEGER
+);
+