sqlite> SELECT id, status, component, severity, priority, reporter, cc, version, milestone FROM ticket WHERE id = 31;
id|status|component|severity|priority|reporter|cc|version|milestone
31|new|Dental Practice||major|ankursinha|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 = 31 ORDER BY time;
ticket|datetime|author|field|oldvalue|newvalue
31|2011/05/09 15:02:05|ankursinha|comment|1|Additional Information

http://forums.opensuse.org/information-new-users/unreviewed-how-faq/398508-opendental-6-0-svn-running-opensuse-11-0-a.html
31|2011/06/24 07:02:18|ankursinha|cc||mrceresa, susmit
31|2011/06/24 07:02:18|ankursinha|comment|2|Mailed -devel requesting help
31|2011/06/24 07:02:18|ankursinha|milestone|Packaging-wishlist|Packaging-in-progress
31|2011/06/24 07:02:18|ankursinha|owner||ankursinha
31|2011/06/24 07:02:18|ankursinha|status|new|assigned
31|2012/06/26 21:12:20|ankursinha|blockedby||
31|2012/06/26 21:12:20|ankursinha|blocking||
31|2012/06/26 21:12:20|ankursinha|comment|3|Issue not solved. Wontfix :/
31|2012/06/26 21:12:20|ankursinha|milestone|Packaging-in-progress|Packaging-wishlist
31|2012/06/26 21:12:20|ankursinha|owner|ankursinha|
31|2012/06/26 21:12:20|ankursinha|status|assigned|new