diff options
author | Jochen Topf <jochen@topf.org> | 2013-01-14 11:41:37 +0100 |
---|---|---|
committer | Jochen Topf <jochen@topf.org> | 2013-01-14 11:41:37 +0100 |
commit | 522ae6c8bf890437d9cc40d80d00063b2f2a584c (patch) | |
tree | b2a6ec11d92569605b3e0e90c9112bfd7cde514b /sources | |
parent | ff80fc295e1894db534ed59c70d7eb67ff766640 (diff) | |
download | taginfo-522ae6c8bf890437d9cc40d80d00063b2f2a584c.tar taginfo-522ae6c8bf890437d9cc40d80d00063b2f2a584c.tar.gz |
Create relation member and role stats
Diffstat (limited to 'sources')
-rw-r--r-- | sources/db/pre.sql | 23 |
1 files changed, 23 insertions, 0 deletions
diff --git a/sources/db/pre.sql b/sources/db/pre.sql index 2b80a84..b2a3704 100644 --- a/sources/db/pre.sql +++ b/sources/db/pre.sql @@ -36,6 +36,7 @@ CREATE TABLE keys ( ); DROP TABLE IF EXISTS prevalent_values; + CREATE TABLE prevalent_values ( key TEXT, value TEXT, @@ -94,3 +95,25 @@ CREATE TABLE tagpairs ( count_relations INTEGER ); +DROP TABLE IF EXISTS relation_types; + +CREATE TABLE relation_types ( + rtype VARCHAR, + count INTEGER, + members_all INTEGER, + members_nodes INTEGER, + members_ways INTEGER, + members_relations INTEGER +); + +DROP TABLE IF EXISTS relation_roles; + +CREATE TABLE relation_roles ( + rtype VARCHAR, + role VARCHAR, + count_all INTEGER, + count_nodes INTEGER, + count_ways INTEGER, + count_relations INTEGER +); + |