add a report for automatic install for TracLegos

[Jeff Hammel]

This should give changed tickets:

SELECT id AS ticket, summary, component, milestone, t.type AS type, severity,
t.time AS created_,
   tc.field AS field, tc.newvalue AS description_,
   changetime AS _changetime, reporter AS _reporter
  FROM ticket t, enum p
  OUTER JOIN ticket_change tc ON tc.ticket = t.id
  WHERE p.name = t.priority AND p.type = 'priority'
AND field <> 'resolution'
AND field <> 'milestone'
AND field <> 'component'
AND (field <> 'status' AND tc.newvalue <> 'closed')
 /* GROUP BY t.id*/
  ORDER BY tc.time DESC
LIMIT 40

[Jeff Hammel]

this doesn't seem relevent at the moment. please reopen with actionable details if desired