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

[cbayle]

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

Modified Files:
        delete_deleted_group.sql 
Log Message:
One more thing to delete


Index: delete_deleted_group.sql
===================================================================
RCS file: /cvsroot/gforge/tools/delete_deleted_group.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- delete_deleted_group.sql    20 Oct 2002 16:04:31 -0000      1.2
+++ delete_deleted_group.sql    9 Jul 2004 14:04:48 -0000       1.3
@@ -13,6 +13,17 @@
 delete from artifact_group where group_artifact_id in (select 
group_artifact_id from artifact_group_list where group_id in (select group_id 
from groups where status = 'D'));
 delete from artifact_category where group_artifact_id in (select 
group_artifact_id from artifact_group_list where group_id in (select group_id 
from groups where status = 'D'));
 delete from artifact_group_list where group_id in (select group_id from groups 
where status = 'D');
+
+
+delete from frs_file where release_id in ( select release_id from frs_release 
where package_id in ( select package_id from frs_package where group_id in 
(select group_id from groups where status = 'D')));
+
+
+delete from frs_release where package_id in ( select package_id from 
frs_package where group_id in (select group_id from groups where status = 'D'));
+
 delete from frs_package where group_id in (select group_id from groups where 
status = 'D');
 
+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 project_group_list where group_id in (select group_id from groups 
where status = 'D');
+
 delete from groups where status = 'D' ;