diff options
Diffstat (limited to 'sources/db/pre.sql')
-rw-r--r-- | sources/db/pre.sql | 13 |
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 +); + |