[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Gforge-commits] tools delete_deleted_group.sql,1.2,1.3
From: |
cbayle |
Subject: |
[Gforge-commits] tools delete_deleted_group.sql,1.2,1.3 |
Date: |
Fri, 09 Jul 2004 09:04:51 -0500 |
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' ;
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Gforge-commits] tools delete_deleted_group.sql,1.2,1.3,
cbayle <=