# HG changeset patch # User HIROSE Yuuji # Date 1693093979 -32373 # Node ID 2fd483245e8ead71aa0d317383d892dd2c6c1cf0 # Parent f5b97df8d824cc8a024a16847afdcd3b8b45bf67 Delete user from grp_adm* table as well as from grp_mem*. diff -r f5b97df8d824 -r 2fd483245e8e s4-funcs.sh --- a/s4-funcs.sh Thu Aug 24 09:51:54 2023 +0900 +++ b/s4-funcs.sh Sun Aug 27 08:52:32 2023 +0859 @@ -3035,7 +3035,8 @@ if [ x"$rm$cfm" = x"yesyes" ]; then # Eliminate cond="where gname=(select gname from grp where rowid=$grid) and user in (select name from user where rowid in ($uids))" - for tbl in grp_mem grp_mem_s grp_mem_m; do + for tbl in grp_mem grp_mem_s grp_mem_m grp_adm grp_adm_s grp_adm_m + do sql="delete from $tbl $cond;" # echo "sql=$sql" query "$sql"