diff options
| author | Jochen Topf <jochen@topf.org> | 2015-03-23 10:19:57 +0100 |
|---|---|---|
| committer | Jochen Topf <jochen@topf.org> | 2015-03-23 10:19:57 +0100 |
| commit | b4392093a71c28690c0d8f88fca4e8b73ded323b (patch) | |
| tree | 6bc2e43424df57bd699abbc7640b9147386417ef | |
| parent | 115d956f7e8cbae0ef0a1beeb3365260f470575d (diff) | |
| download | taginfo-b4392093a71c28690c0d8f88fca4e8b73ded323b.tar taginfo-b4392093a71c28690c0d8f88fca4e8b73ded323b.tar.gz | |
Mark short keys as bad.
| -rw-r--r-- | sources/db/post_grades.sql | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/sources/db/post_grades.sql b/sources/db/post_grades.sql index 980df01..6846a4f 100644 --- a/sources/db/post_grades.sql +++ b/sources/db/post_grades.sql @@ -24,6 +24,9 @@ UPDATE keys SET grade='b' WHERE characters IS NULL; -- All other keys not used at least 10 times with strange characters in them. UPDATE keys SET grade='b' WHERE count_all < 10 AND characters='rest'; +-- All keys with less than three characters are bad +UPDATE keys SET grade='b' WHERE length(key) < 3; + -- ============================================================================ -- GOOD KEYS: |