= ToDo for the TracProject (trac.edgewall.org, a.k.a. teo) = 


== Maintenance ==

 - Purge all the dummy tickets marked for deletion:
   {{{
#!sql
-- (for PostgreSQL)
create view tobedeleted as
  select id, summary, 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 CAST(id AS text) from tobedeleted);
delete from ticket where id in (select id from tobedeleted);
   }}}
   - done 2011-08-08


== The //"project"// tickets
[[TicketQuery(component=project,status!=closed)]]