# HG changeset patch
# User HIROSE Yuuji <yuuji@gentei.org>
# Date 1608076504 -32400
# Node ID a240c8988c651d243eba129054c3c07ebcf3d222
# Parent  fa5be649968fc4eeb00c967ccb740c7f421ec26c
Save profile update time stamp in user_s table

diff -r fa5be649968f -r a240c8988c65 s4-funcs.sh
--- a/s4-funcs.sh	Mon Dec 14 20:01:07 2020 +0900
+++ b/s4-funcs.sh	Wed Dec 16 08:55:04 2020 +0900
@@ -4244,7 +4244,15 @@
 	RELEASE SAVEPOINT pa2table_insert;
 	EOF
   rc=$?
-  [ $rc -eq 0 -a x"$tbl" = x"user" ] && touch $userupdateflag
+  if [ $rc -eq 0 -a x"$tbl" = x"user" ]; then
+    # XXX:	Sorry to use undeclared column in user.def
+    #		This is useful to mitigate account sync load
+    query <<-EOF
+	REPLACE INTO user_s(name, key, type, val)
+	VALUES('$user', 'profupdate', 'string', datetime('now', 'localtime'));
+	EOF
+    touch $userupdateflag
+  fi
   ## err "Table:$tbl update done "
   return $rc
 )
diff -r fa5be649968f -r a240c8988c65 s4-world.sh
--- a/s4-world.sh	Mon Dec 14 20:01:07 2020 +0900
+++ b/s4-world.sh	Wed Dec 16 08:55:04 2020 +0900
@@ -88,7 +88,7 @@
   else
     case "$prevsync" in
       [2-9][0-9][0-9][0-9]-[01][0-9]-[0-3][0-9]\ [012][0-9]:??:??)
-      SYNCCOND="WHERE name in (SELECT name FROM m.user_s WHERE key='wtime' AND val > '$prevsync')"
+      SYNCCOND="WHERE name in (SELECT name FROM m.user_s WHERE key='profupdate' AND val > '$prevsync')"
       err "prevsync=$prevsync"
       limited=`query "SELECT DISTINCT name FROM m.user_s $SYNCCOND;"`
       if [ -n "$limited" ]; then