[Gforge-commits] tools delete_deleted_user.sql,NONE,1.1

[cbayle]

Update of /cvsroot/gforge/tools
In directory db.perdue.net:/tmp/cvs-serv20572

Added Files:
        delete_deleted_user.sql 
Log Message:
As the name says it tries to delete user marqued deleted


--- NEW FILE: delete_deleted_user.sql ---
delete from forum where posted_by in 
(select user_id  from users where status='D');

delete from project_messages where posted_by in 
(select user_id  from users where status='D');

delete from user_group where user_id in 
(select user_id  from users where status='D');

delete from artifact_perm where user_id in 
(select user_id  from users where status='D');

delete from artifact_history where artifact_id in (select artifact_id from 
artifact where assigned_to in
(select user_id  from users where status='D'));

delete from artifact_history where mod_by in
(select user_id  from users where status='D');


delete from artifact_message where artifact_id in (select artifact_id from 
artifact where assigned_to in
(select user_id  from users where status='D'));

delete from artifact where assigned_to in
(select user_id  from users where status='D');

delete from artifact where submitted_by in
(select user_id  from users where status='D');

delete from users where status='D';