diff options
| author | Jochen Topf <jochen@topf.org> | 2011-12-10 11:13:47 +0100 |
|---|---|---|
| committer | Jochen Topf <jochen@topf.org> | 2011-12-10 11:13:47 +0100 |
| commit | e3998d2420a0bdae8e81322ef8a568577819574c (patch) | |
| tree | 49bf76990b15596f8bbd1a02f3f7ad798f68a7d4 /sources/db | |
| parent | 8a59bfba5a90ce9121975c52c5457d13768a99b1 (diff) | |
| download | taginfo-e3998d2420a0bdae8e81322ef8a568577819574c.tar taginfo-e3998d2420a0bdae8e81322ef8a568577819574c.tar.gz | |
Add support in tagstat for counting key-value-combinations
Diffstat (limited to 'sources/db')
| -rw-r--r-- | sources/db/pre.sql | 13 | ||||
| -rwxr-xr-x | sources/db/update.sh | 2 |
2 files changed, 14 insertions, 1 deletions
diff --git a/sources/db/pre.sql b/sources/db/pre.sql index 03e6b23..2b80a84 100644 --- a/sources/db/pre.sql +++ b/sources/db/pre.sql @@ -81,3 +81,16 @@ CREATE TABLE keypairs ( count_relations INTEGER ); +DROP TABLE IF EXISTS tagpairs; + +CREATE TABLE tagpairs ( + key1 VARCHAR, + value1 VARCHAR, + key2 VARCHAR, + value2 VARCHAR, + count_all INTEGER, + count_nodes INTEGER, + count_ways INTEGER, + count_relations INTEGER +); + diff --git a/sources/db/update.sh b/sources/db/update.sh index 81f806d..20f13be 100755 --- a/sources/db/update.sh +++ b/sources/db/update.sh @@ -8,7 +8,7 @@ set -e # uncomment this if you want to get a core file in case tagstats crashes -#ulimit -c 1000000000 +#ulimit -c unlimited DIR=$1 PLANETFILE=$2 |