sqlite> SELECT id, status, component, severity, priority, reporter, cc, version, milestone FROM ticket WHERE id = 1;
id|status|component|severity|priority|reporter|cc|version|milestone
1|new|Accounting||major|susmit|mrceresa, susmit||Packaging-wishlist

sqlite> SELECT ticket, strftime('%Y/%m/%d %H:%M:%S', time / 1000000, 'unixepoch', 'localtime') AS datetime, author, field, oldvalue, newvalue FROM ticket_change WHERE ticket = 1 ORDER BY time;
ticket|datetime|author|field|oldvalue|newvalue
1|2011/01/07 18:59:03|susmit|comment|1|
1|2011/01/07 18:59:03|susmit|milestone||Packaging-in-progress
1|2011/01/07 18:59:27|susmit|comment|2|
1|2011/01/07 18:59:27|susmit|component|General|Misc
1|2011/01/07 18:59:27|susmit|owner||
1|2011/01/07 19:10:52|susmit|cc||ankursinha, rakesh
1|2011/01/07 19:10:52|susmit|comment|3|
1|2011/01/07 19:17:17|susmit|comment|4|
1|2011/01/07 19:17:17|susmit|component|Misc|Accounting
1|2011/01/07 19:17:17|susmit|owner||
1|2011/04/28 12:11:17|ankursinha|comment|5|
1|2011/04/28 12:11:17|ankursinha|owner||rakesh
1|2011/07/17 19:58:55|ankursinha|cc|ankursinha, rakesh|mrceresa, susmit
1|2011/07/17 19:58:55|ankursinha|comment|6|I'm going to take this one over. 
1|2011/07/17 19:58:55|ankursinha|owner|rakesh|ankursinha
1|2011/07/17 19:58:55|ankursinha|status|new|assigned
1|2012/06/26 20:48:34|ankursinha|blockedby||
1|2012/06/26 20:48:34|ankursinha|blocking||
1|2012/06/26 20:48:34|ankursinha|comment|7|Review halted. Also looks like upstream has stalled. 

https://bugzilla.redhat.com/show_bug.cgi?id=732232
1|2012/06/26 20:48:34|ankursinha|milestone|Packaging-in-progress|Packaging-wishlist
1|2012/06/26 20:48:34|ankursinha|owner|ankursinha|
1|2012/06/26 20:48:34|ankursinha|status|assigned|new