3.4.1 メール保存用のフォルダの削除

データベース上の不要なメール保存用のフォルダを削除するには,次に示すSQLを実行します。SQL中の「ユーザID」には,削除したいユーザのユーザIDを記述します。ユーザIDを記述するときは,誤りのないように注意してください。

実行するSQL

  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';