s4
changeset 1018:2fd483245e8e
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 diff
1.1 --- a/s4-funcs.sh Thu Aug 24 09:51:54 2023 +0900 1.2 +++ b/s4-funcs.sh Sun Aug 27 08:52:32 2023 +0859 1.3 @@ -3035,7 +3035,8 @@ 1.4 if [ x"$rm$cfm" = x"yesyes" ]; then 1.5 # Eliminate 1.6 cond="where gname=(select gname from grp where rowid=$grid) and user in (select name from user where rowid in ($uids))" 1.7 - for tbl in grp_mem grp_mem_s grp_mem_m; do 1.8 + for tbl in grp_mem grp_mem_s grp_mem_m grp_adm grp_adm_s grp_adm_m 1.9 + do 1.10 sql="delete from $tbl $cond;" 1.11 # echo "sql=$sql" 1.12 query "$sql"