From 8cf6d48d8b3a400ac2d1856384a8ea4bf9105cea Mon Sep 17 00:00:00 2001 From: Jochen Topf Date: Thu, 18 Sep 2014 11:52:45 +0200 Subject: Remove temporary hack. --- sources/master/master.sql | 11 ----------- 1 file changed, 11 deletions(-) (limited to 'sources') diff --git a/sources/master/master.sql b/sources/master/master.sql index ebd8202..b271b5c 100644 --- a/sources/master/master.sql +++ b/sources/master/master.sql @@ -149,17 +149,6 @@ DELETE FROM suggestions WHERE count < 100; UPDATE suggestions SET score = count * (1+in_wiki); --- ============================================================================ - --- temporary hack to pull over JOSM data from old JOSM format into new projects format - -INSERT INTO projects.projects (id, json_url, status, name, description) VALUES ('josm', '', 'OK', 'JOSM Editor', 'JOSM offline OSM Editor'); - -INSERT INTO projects.project_tags (project_id, key, value, on_node, on_way, on_relation, on_area, icon_url) SELECT 'josm', k, v, 1, 0, 0, 0, '/api/4/josm/style/image?style=standard&image=' || icon_source FROM josm.josm_style_rules WHERE icon_source IS NOT NULL; --- INSERT INTO projects.project_tags (project_id, key, value, on_node, on_way, on_relation, on_area, icon_url) SELECT 'josm', k, v, 0, 1, 0, 0, 'https://chart.googleapis.com/chart?cht=bhs&chs=16x16&chf=bg,s,' || substr(line_color, 1+instr(line_color, '#')) FROM josm.josm_style_rules WHERE line_color IS NOT NULL; --- INSERT INTO projects.project_tags (project_id, key, value, on_node, on_way, on_relation, on_area, icon_url) SELECT 'josm', k, v, 0, 0, 0, 1, 'https://chart.googleapis.com/chart?cht=bhs&chs=16x16&chf=bg,s,' || substr(area_color, 1+instr(area_color, '#')) FROM josm.josm_style_rules WHERE area_color IS NOT NULL; - - -- ============================================================================ ANALYZE; -- cgit v1.2.3