Remove unused prevalent_values field in keys sql table

2 files changed, 1 insertions, 14 deletions

diff --git a/sources/db/post.sql b/sources/db/post.sql
index ddcc80e..5567f19 100644
--- a/sources/db/post.sql
+++ b/sources/db/post.sql
@@ -65,18 +65,6 @@ INSERT INTO stats (key, value) SELECT 'characters_in_keys_rest',    count(*) FRO
 INSERT INTO stats (key, value) VALUES ('objects',     (SELECT sum(value) FROM stats WHERE key IN ('nodes', 'ways', 'relations')));
 INSERT INTO stats (key, value) VALUES ('object_tags', (SELECT sum(value) FROM stats WHERE key IN ('node_tags', 'way_tags', 'relation_tags')));
 
--- XXX this can probably be removed
-UPDATE keys SET prevalent_values=(
-        SELECT group_concat(value, '|') FROM (
-            SELECT value FROM tags t
-                    WHERE t.key       = keys.key
-                      AND t.count_all > keys.count_all / 100
-                 ORDER BY t.count_all DESC
-                    LIMIT 10
-               
-        )
-    ) WHERE values_all < 1000;
-
 INSERT INTO prevalent_values (key, value, count, fraction)
             SELECT t.key, t.value, t.count_all, CAST(t.count_all AS REAL) / CAST(k.count_all AS REAL) FROM tags t, keys k
                     WHERE t.key       = k.key
diff --git a/sources/db/pre.sql b/sources/db/pre.sql
index a7f0351..4be43ab 100644
--- a/sources/db/pre.sql
+++ b/sources/db/pre.sql
@@ -31,8 +31,7 @@ CREATE TABLE keys (
   in_josm          INTEGER DEFAULT 0,
   in_potlatch      INTEGER DEFAULT 0,
   in_merkaartor    INTEGER DEFAULT 0,
-  characters       VARCHAR,
-  prevalent_values TEXT
+  characters       VARCHAR
 );
 
 DROP TABLE IF EXISTS prevalent_values;