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