From b4392093a71c28690c0d8f88fca4e8b73ded323b Mon Sep 17 00:00:00 2001 From: Jochen Topf Date: Mon, 23 Mar 2015 10:19:57 +0100 Subject: Mark short keys as bad. --- sources/db/post_grades.sql | 3 +++ 1 file changed, 3 insertions(+) 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: -- cgit v1.2.3