From 7ba27bddb45401521768da34764faced21187b98 Mon Sep 17 00:00:00 2001 From: Nathan Wagner Date: Sat, 4 Aug 2018 01:02:15 +0000 Subject: [PATCH] add default for log timestamps in database --- db.sql | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/db.sql b/db.sql index 6a8f51e..e8d39ea 100644 --- 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 -- 2.40.0