# HG changeset patch
# User Ralph Meijer <ralphm@ik.nu>
# Date 1099940480 0
# Node ID b8958967f508aa9af898ef6cb9b1ece278a63a5b
# Parent  66fac7cd9edcadc025b65248fa25b637ff31f688
Introduced date field in items table.

diff -r 66fac7cd9edc -r b8958967f508 idavoll/pgsql_backend.py
--- a/idavoll/pgsql_backend.py	Mon Nov 08 14:06:54 2004 +0000
+++ b/idavoll/pgsql_backend.py	Mon Nov 08 19:01:20 2004 +0000
@@ -79,7 +79,7 @@
 
     def _store_item(self, cursor, node_id, item, publisher):
         data = item.toXml()
-        cursor.execute("""UPDATE items SET publisher=%s, data=%s
+        cursor.execute("""UPDATE items SET date=now(), publisher=%s, data=%s
                           FROM nodes
                           WHERE nodes.id = items.node_id AND
                                 nodes.node = %s and items.item=%s""",