--- a/create_tj_db.tcl	Thu Feb 11 16:23:45 2021 +0200
+++ b/create_tj_db.tcl	Mon Feb 15 13:42:10 2021 +0200
@@ -19,20 +19,23 @@
   lappend sch "uuser VARCHAR(32)"
 
   # created timestamp
-  lappend sch "ucreated INT"
+  lappend sch "ucreated DATETIME"
+
+  # updated timestamp
+  lappend sch "uupdated DATETIME"
 
   # description
   lappend sch "udesc VARCHAR(1024)"
 
-  # 0 = TJ, 1 = one-time reminder, 2 = repeat reminder
-  lappend sch "utype INT"
-
   # unique identifier for type 0
   lappend sch "uid VARCHAR(32)"
 
   # target date/time
   lappend sch "utarget DATETIME"
 
+  # 0 = TJ, 1 = one-time reminder, 2 = repeat reminder
+  lappend sch "utype INT"
+
   utl_create_table dbh "$utable" [join $sch ","]
 }