++added:
 -- Remove mail notifications from deleted users
 DELETE FROM bugs_cc WHERE email IN (SELECT user_id FROM user WHERE 
email="[email protected]");
 DELETE FROM patch_cc WHERE email IN (SELECT user_id FROM user WHERE 
email="[email protected]");
 DELETE FROM support_cc WHERE email IN (SELECT user_id FROM user WHERE 
email="[email protected]");
 DELETE FROM task_cc WHERE email IN (SELECT user_id FROM user WHERE 
email="[email protected]");

--
forwarded from 
https://savannah.gnu.org/maintenance/savanetasks#msg20090112061215+0...@https://savannah.gnu.org/maintenance


_______________________________________________
Savannah-cvs mailing list
[email protected]
http://lists.gnu.org/mailman/listinfo/savannah-cvs

Reply via email to