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

== Short Term ==
 - '''raise min_karma to 2''' (quite some spam goes through at karma 0 or 1)
 - 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);
   }}}

== Longer Term ==

 - set up some test instances of Trac (#4163) (at least for 0.10-stable and 0.11dev)