Find file
Fetching contributors…
Cannot retrieve contributors at this time
17 lines (16 sloc) 256 Bytes
-- All Trac ticket comments to convert.
copy
(select
ticket,
time / 1000000 as PosixTime,
author,
newvalue
from
ticket_change
where
field = 'comment'
and newvalue <> ''
order
by ticket, time)
to '/tmp/comments.csv'
with CSV