> ... CURRENT_TIMESTAMP is broken ... I don't think it's broken; I think it's just never been implemented.
> ... best way to substitute for it ...
It's simple to write a trigger to do almost the same thing.
<http://www.sqlite.org/lang.html#createtrigger>
<http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions>
Regards
