[Gforge-commits] tools delete_deleted_group.sql, 1.3, 1.4 delete_deleted_user.sql, 1.1, 1.2

[cbayle]

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

Modified Files:
        delete_deleted_group.sql delete_deleted_user.sql 
Log Message:
some improvement on deleting record in impacted tables


Index: delete_deleted_group.sql
===================================================================
RCS file: /cvsroot/gforge/tools/delete_deleted_group.sql,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -d -r1.3 -r1.4
--- delete_deleted_group.sql    9 Jul 2004 14:04:48 -0000       1.3
+++ delete_deleted_group.sql    12 Oct 2004 16:46:26 -0000      1.4
@@ -24,6 +24,8 @@
 
 delete from project_task where group_project_id in (select group_project_id 
from project_group_list where group_id in (select group_id from groups where 
status = 'D'));
 
+delete from group_plugin where group_id in (select group_id from groups where 
status = 'D');
+
 delete from project_group_list where group_id in (select group_id from groups 
where status = 'D');
 
 delete from groups where status = 'D' ;

Index: delete_deleted_user.sql
===================================================================
RCS file: /cvsroot/gforge/tools/delete_deleted_user.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -d -r1.1 -r1.2
--- delete_deleted_user.sql     17 May 2004 18:06:59 -0000      1.1
+++ delete_deleted_user.sql     12 Oct 2004 16:46:26 -0000      1.2
@@ -17,6 +17,9 @@
 (select user_id  from users where status='D');
 
 
+delete from artifact_file where artifact_id in (select artifact_id from 
artifact where assigned_to 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'));
 
@@ -26,4 +29,10 @@
 delete from artifact where submitted_by in
 (select user_id  from users where status='D');
 
+delete from project_perm where user_id in
+(select user_id  from users where status='D');
+
+delete from forum_perm where user_id in
+(select user_id  from users where status='D');
+
 delete from users where status='D';