add default for log timestamps in database

[zpackage] / db.sql

diff --git a/db.sql b/db.sql
index 6a8f51ed05ec56e63b639cceeb5efb7c48f6284e..e8d39ea00c47a0c66e33f2064436b2996bd634c7 100644 (file)
--- a/db.sql
+++ b/db.sql
@@ -197,7 +197,8 @@ create table packagegroups (
 -- sub-invocations, probably an environment variable set if not
 -- already set by zpm, probably a uuid or a timestamp
 create table zpmlog (
-       ts      integer, -- timestamp of action, may need sub-second
+       ts      text default (strftime('%Y-%m-%d %H:%M:%f', 'now')),
+               -- timestamp of action
        action  text,
        target  text, -- packagename, repo name, etc
        info    text -- human readable