Mercurial > hgrepos > hgweb.cgi > s4
changeset 1018:2fd483245e8e draft
Delete user from grp_adm* table as well as from grp_mem*.
author | HIROSE Yuuji <yuuji@gentei.org> |
---|---|
date | Sun, 27 Aug 2023 08:52:32 +0859 |
parents | f5b97df8d824 |
children | 4952d9b79b7d |
files | s4-funcs.sh |
diffstat | 1 files changed, 2 insertions(+), 1 deletions(-) [+] |
line wrap: on
line diff
--- 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"