Select Code to Download

created   TIMESTAMP     DEFAULT CURRENT_TIMESTAMP,

CREATE TRIGGER IF NOT EXISTS update_modification_time 
        AFTER UPDATE OF title, body ON items
        FOR EACH ROW BEGIN
            UPDATE items SET modified = DATETIME('NOW') WHERE id = new
+.id;
        END;