Create relation member and role stats

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
+);
+