1 files changed, 20 insertions, 0 deletions
diff --git a/sources/db/pre.sql b/sources/db/pre.sql
index b2a3704..a7f0351 100644
--- a/sources/db/pre.sql
+++ b/sources/db/pre.sql
@@ -117,3 +117,23 @@ CREATE TABLE relation_roles (
   count_relations  INTEGER
 );
 
+DROP TABLE IF EXISTS prevalent_roles;
+
+CREATE TABLE prevalent_roles (
+  rtype    TEXT,
+  role     TEXT,
+  count    INTEGER,
+  fraction REAL
+);
+
+DROP TABLE IF EXISTS selected_tags;
+
+CREATE TABLE selected_tags (
+  skey             VARCHAR,
+  svalue           VARCHAR,
+  count_all        INTEGER DEFAULT 0,
+  count_nodes      INTEGER DEFAULT 0,
+  count_ways       INTEGER DEFAULT 0,
+  count_relations  INTEGER DEFAULT 0
+);
+