Does anybody have any ideas/scripts for maintaining (cleaning) the roundcube database when mailboxes (or domains) are closed? I am not super familiar with the db schema but we are about to begin offering RoundCube webmail (in addition to squirrelmail -- so we'll utilize the squirrelmail_usercopy plugin) and we have a post-deletion script that does some filesystem maintenance. . . I want to extend it to keep cruft out of the roundcube database and it seems there are several tables that would obviously need rows removed (users, identities, contacts) and some other tables I guess (cache, messages.) What about the session table?
Now that I write this and look more closely I gues it's not too complicated for an invididual mailbox removal: The user_id column would be the key. . . For a domain removal, it's slightly more intelligent logic that would need to look for all users.username LIKE %@domain.org. . .
But I don't want to reinvent the wheel if someone's already put work/thought into this!
Ben _______________________________________________ List info: http://lists.roundcube.net/users/