データベース上の不要なメール保存用のフォルダを削除するには,次に示すSQLを実行します。SQL中の「ユーザID」には,削除したいユーザのユーザIDを記述します。ユーザIDを記述するときは,誤りのないように注意してください。
delete from tbl_apdfile where
fid=(select fid from tbl_forum where userid='ユーザID');
delete from tbl_aldyread where
fid=(select fid from tbl_forum where userid='ユーザID');
delete from tbl_contents where
fid=(select fid from tbl_forum where userid='ユーザID');
delete from tbl_opinion where
fid=(select fid from tbl_forum where userid='ユーザID');
delete from tbl_state where
fid=(select fid from tbl_forum where userid='ユーザID');
delete from tbl_attribute where
fid=(select fid from tbl_forum where userid='ユーザID');
delete from tbl_importance where
fid=(select fid from tbl_forum where userid='ユーザID');
delete from tbl_uaccess where
fid=(select fid from tbl_forum where userid='ユーザID');
delete from tbl_sequence2 where
category=(select fid from tbl_forum where userid='ユーザID');
delete from tbl_sequence1 where
category=(select fid from tbl_forum where userid='ユーザID');
delete from tbl_mainforum where
fid=(select fid from tbl_forum where userid='ユーザID');
delete from tbl_forum where userid='ユーザID';