changeset 555:7e7b3b2822f6

Remove retiring user from grp-admin.
author HIROSE Yuuji <yuuji@gentei.org>
date Sat, 13 Apr 2019 15:00:21 +0900
parents 0c6e28f7a7a8
children 4a33f5424767
files s4-funcs.sh
diffstat 1 files changed, 8 insertions(+), 3 deletions(-) [+]
line wrap: on
line diff
--- a/s4-funcs.sh	Fri Apr 12 01:31:54 2019 +0900
+++ b/s4-funcs.sh	Sat Apr 13 15:00:21 2019 +0900
@@ -2993,9 +2993,14 @@
       fi
     fi
   else
-    query "delete from grp_mem $cond;
-delete from grp_mem_s $cond;
-delete from grp_mem_m $cond;"
+    query "begin;
+	delete from grp_mem $cond;
+	delete from grp_mem_s $cond;
+	delete from grp_mem_m $cond;
+	delete from grp_adm $cond;
+	delete from grp_adm_s $cond;
+	delete from grp_adm_m $cond;
+	end;"
     action="から脱退しました。"
   fi
   smail "$(collectemail `getgroupadmins $1`)" "Member change of $1"<<-EOF

yatex.org