Edgewall Software

Version 8 (modified by Christian Boos, 15 years ago) ( diff )

adapted SQL for deleting the tobedeleted tickets to PostgreSQL

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:
    -- (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)
Note: See TracWiki for help on using the wiki.