diff options
Diffstat (limited to 'sources/master/master.sql')
| -rw-r--r-- | sources/master/master.sql | 16 |
1 files changed, 7 insertions, 9 deletions
diff --git a/sources/master/master.sql b/sources/master/master.sql index a3c250b..ebd8202 100644 --- a/sources/master/master.sql +++ b/sources/master/master.sql @@ -8,12 +8,11 @@ .bail ON -ATTACH DATABASE '__DIR__/db/taginfo-db.db' AS db; -ATTACH DATABASE '__DIR__/wiki/taginfo-wiki.db' AS wiki; -ATTACH DATABASE '__DIR__/languages/taginfo-languages.db' AS languages; -ATTACH DATABASE '__DIR__/josm/taginfo-josm.db' AS josm; -ATTACH DATABASE '__DIR__/projects/taginfo-projects.db' AS projects; -ATTACH DATABASE '__DIR__/potlatch/taginfo-potlatch.db' AS potlatch; +ATTACH DATABASE '__DIR__/db/taginfo-db.db' AS db; +ATTACH DATABASE '__DIR__/wiki/taginfo-wiki.db' AS wiki; +ATTACH DATABASE '__DIR__/languages/taginfo-languages.db' AS languages; +ATTACH DATABASE '__DIR__/josm/taginfo-josm.db' AS josm; +ATTACH DATABASE '__DIR__/projects/taginfo-projects.db' AS projects; -- ============================================================================ @@ -35,8 +34,7 @@ INSERT INTO sources SELECT 1, 1, * FROM db.source UNION SELECT 2, 1, * FROM wiki.source UNION SELECT 3, 1, * FROM languages.source UNION SELECT 4, 1, * FROM josm.source - UNION SELECT 5, 1, * FROM projects.source - UNION SELECT 6, 0, * FROM potlatch.source; + UNION SELECT 5, 1, * FROM projects.source; DROP TABLE IF EXISTS master_stats; CREATE TABLE master_stats ( @@ -47,7 +45,7 @@ CREATE TABLE master_stats ( INSERT INTO master_stats SELECT * FROM db.stats UNION SELECT * FROM wiki.stats UNION SELECT * FROM josm.stats - UNION SELECT * FROM potlatch.stats; + UNION SELECT * FROM projects.stats; -- ============================================================================ |