diff options
| author | Jochen Topf <jochen@topf.org> | 2010-11-01 18:26:05 +0100 |
|---|---|---|
| committer | Jochen Topf <jochen@topf.org> | 2010-11-01 18:29:33 +0100 |
| commit | 94748c28692398b953a385a3316162a3b141f5d8 (patch) | |
| tree | 264e317f3ef4af1eba8f5c94f7c6c523fc9d17e9 /sources/db | |
| parent | 1dc5013314a56a830a6d0f439866e7b18a217d5a (diff) | |
| download | taginfo-94748c28692398b953a385a3316162a3b141f5d8.tar taginfo-94748c28692398b953a385a3316162a3b141f5d8.tar.gz | |
Added reports
Added infrastructure for reports and the first report (not finished yet)
Preparation for better wiki and merkaartor source inclusion
Diffstat (limited to 'sources/db')
| -rw-r--r-- | sources/db/pre.sql | 8 |
1 files changed, 7 insertions, 1 deletions
diff --git a/sources/db/pre.sql b/sources/db/pre.sql index 9404aaa..0163089 100644 --- a/sources/db/pre.sql +++ b/sources/db/pre.sql @@ -43,8 +43,10 @@ CREATE TABLE keys ( users_relations INTEGER DEFAULT 0, grids INTEGER DEFAULT 0, in_wiki INTEGER DEFAULT 0, + in_wiki_en INTEGER DEFAULT 0, in_josm INTEGER DEFAULT 0, in_potlatch INTEGER DEFAULT 0, + in_merkaartor INTEGER DEFAULT 0, prevalent_values TEXT ); @@ -64,9 +66,13 @@ CREATE TABLE tags ( count_nodes INTEGER DEFAULT 0, count_ways INTEGER DEFAULT 0, count_relations INTEGER DEFAULT 0, + object_type VARCHAR(1), -- (n)ode, (w)ay, (r)elation + object_id INTEGER, in_wiki INTEGER DEFAULT 0, + in_wiki_en INTEGER DEFAULT 0, in_josm INTEGER DEFAULT 0, - in_potlatch INTEGER DEFAULT 0 + in_potlatch INTEGER DEFAULT 0, + in_merkaartor INTEGER DEFAULT 0 ); DROP TABLE IF EXISTS keypairs; |