Collaboration - Mail システム管理者ガイド

[目次][用語][索引][前へ][次へ]

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