diff tj.tcl @ 631:9596cd122639

tj: Adjust database schema a bit, add new field 'uupdated'.
author Matti Hamalainen <ccr@tnsp.org>
date Mon, 15 Feb 2021 13:42:10 +0200
parents b7e3a47ed072
children 68b8cf87e86e
line wrap: on
line diff
--- a/tj.tcl	Thu Feb 11 16:23:45 2021 +0200
+++ b/tj.tcl	Mon Feb 15 13:42:10 2021 +0200
@@ -349,9 +349,10 @@
       return 1
     }
 
+    set ucreated [utl_sql_stamp_to_datetime [clock seconds]]
     if {$umode} {
       # Insert new entry
-      set usql "INSERT INTO tj (uid,uuser,ucreated,udesc,utype,utarget) VALUES ('[utl_escape $uid]', '[utl_escape $uhand]', [unixtime], '[utl_escape $rdesc]', 0, '$rdate')"
+      set usql "INSERT INTO tj (uid,uuser,ucreated,uupdated,udesc,utype,utarget) VALUES ('[utl_escape $uid]', '[utl_escape $uhand]', '$ucreated', '$ucreated', '[utl_escape $rdesc]', 0, '$rdate')"
       if {[catch {tj_dbh eval $usql} uerrmsg]} {
         tj_msg $upublic $unick $uchan "err_sql" [list $uerrmsg]
         tj_log "$uerrmsg on SQL:\n$usql"
@@ -364,6 +365,7 @@
     } else {
       # Update existing entry
       set usqlargs {}
+      lappend usqlargs "uupdated='$ucreated'"
       if {[string length $rdesc] > 0} {
         lappend usqlargs "udesc='[utl_escape $rdesc]'"
       }