On 23 May 2016, at 11:14am, Olivier Mascia <om at integral.be> wrote:
> But am I missing some important detail that could hurt me later? I notice only one thing, but you're at the time when it's easy to change it. The 'type' you've picked for this column is 'timestamp'. SQLite has no such type. I recommend you use one of INTEGER, REAL or TEXT depending on the value that your 'now()' function returns. You won't have found a problem with it so far, but you may encounter one in other parts of your program which set or obtain a value in that column. Simon.