try putting
Qt Code: 
  1. timestamp DATE DEFAULT (datetime('now','localtime')),
To copy to clipboard, switch view to plain text mode 

in your sqlite schema