[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Gforge-commits] tools delete_deleted_group.sql, 1.3, 1.4 delete_deleted
From: |
cbayle |
Subject: |
[Gforge-commits] tools delete_deleted_group.sql, 1.3, 1.4 delete_deleted_user.sql, 1.1, 1.2 |
Date: |
Tue, 12 Oct 2004 11:46:29 -0500 |
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';
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Gforge-commits] tools delete_deleted_group.sql, 1.3, 1.4 delete_deleted_user.sql, 1.1, 1.2,
cbayle <=