Changes between Version 1 and Version 2 of TracProject/ToDo

Timestamp:

May 11, 2007, 9:38:09 AM (17 years ago)

Author:

Christian Boos

Comment:

Add a sql snippet for purging all the tobedeleted tickets

TracProject/ToDo

@@ -3 +3 @@
 == Short Term ==
  - Fix #4087 (there's a patch -> needs testing and to be applied on t.e.o)
- 
+ - Purge all the dummy tickets marked for deletion:
+   {{{
+create view tobedeleted as
+  select id, status, resolution, keywords 
+  from ticket 
+  where keywords like '%tobedeleted%' and status='closed' and resolution='invalid'; 
+delete from ticket_change where ticket in (select id from tobedeleted);
+delete from attachment where type='ticket' and id in (select id from tobedeleted);
+delete from ticket where id in (select id from tobedeleted);
+   }}}
 
 == Longer Term ==