word edit: record entry creator and modification time

[sheet.git] / tools / mkwordlist

diff --git a/tools/mkwordlist b/tools/mkwordlist
index bec1362b51b2c6a39cd94a2c75912ca1dc73f48f..b88cd1bdd1adf23a525f7c6715f541864d2e0617 100755 (executable)
--- a/tools/mkwordlist
+++ b/tools/mkwordlist
@@ -1,8 +1,5 @@
 #!/bin/sh
+echo 'use utf8;'
 psql sheet -XAt -c "
-       SELECT json_object_agg(coalesce(form, ''), forms)
-               FROM word RIGHT JOIN (
-                       SELECT cat id, array_agg(form ORDER BY form) forms
-                               FROM word WHERE ref IS NULL GROUP BY cat
-               ) sub USING (id)
-" | sed 's/:/=>/g'
+       SELECT json_object_agg(coalesce(form, ''), forms) FROM _cat_words
+" | sed 's/ : / => /g'