title: on update current_timestamp with SQLite
body: <p>I want to update a field with the current timestamp whenever the row is updated.</p>
  
  <p>In MySQL I would do, when declaring the table</p>
  
  <pre><code>LastUpdate TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL ON UPDATE CURRENT_TIMESTAMP
  </code></pre>
  
  <p>But the "on update" part does not work with SQLite.
  I could not find a way to do it automatically, do I need to declare a trigger?</p>
  
  <p><strong>EDIT</strong>: For the record, here is my current trigger:</p>
  
  <pre><code>CREATE TRIGGER [UpdateLastTime]
  AFTER UPDATE
  ON Package
  FOR EACH ROW
  BEGIN
  UPDATE Package SET LastUpdate = CURRENT_TIMESTAMP WHERE ActionId = old.ActionId;
  END
  </code></pre>
  
  <p>Thanks</p>