aboutsummaryrefslogtreecommitdiff
path: root/sources/db
diff options
context:
space:
mode:
authorJochen Topf <jochen@topf.org>2014-09-18 12:31:17 +0200
committerJochen Topf <jochen@topf.org>2014-09-18 12:31:17 +0200
commit076414f518a298e4f98bc1e69a9008b199e08884 (patch)
treedbeedf538bd88f39c85da9bdbef305046ab364cc /sources/db
parent0ce037322548f6b2d3112c0d8ef89dc946777177 (diff)
downloadtaginfo-076414f518a298e4f98bc1e69a9008b199e08884.tar
taginfo-076414f518a298e4f98bc1e69a9008b199e08884.tar.gz
Prepare for putting project stats in db.keys and db.values.
Diffstat (limited to 'sources/db')
-rw-r--r--sources/db/pre.sql2
1 files changed, 2 insertions, 0 deletions
diff --git a/sources/db/pre.sql b/sources/db/pre.sql
index bc51db0..9d349a3 100644
--- a/sources/db/pre.sql
+++ b/sources/db/pre.sql
@@ -28,6 +28,7 @@ CREATE TABLE keys (
cells_ways INTEGER DEFAULT 0,
in_wiki INTEGER DEFAULT 0,
in_wiki_en INTEGER DEFAULT 0,
+ in_projects INTEGER DEFAULT 0,
in_josm INTEGER DEFAULT 0,
in_potlatch INTEGER DEFAULT 0,
characters VARCHAR
@@ -73,6 +74,7 @@ CREATE TABLE tags (
object_id INTEGER,
in_wiki INTEGER DEFAULT 0,
in_wiki_en INTEGER DEFAULT 0,
+ in_projects INTEGER DEFAULT 0,
in_josm INTEGER DEFAULT 0,
in_potlatch INTEGER DEFAULT 0
);