rework zpm-note

[zpackage] / schema / main.sql

diff --git a/schema/main.sql b/schema/main.sql
index c9c79a26e0f338920d9bfcf0894066a2ef23cc47..b0675509e1a6884e8b2ba6560a91350111bed3fd 100644 (file)
--- a/schema/main.sql
+++ b/schema/main.sql
@@ -372,7 +372,7 @@ create table zpmlog (
 
 create table notes (
        id      integer primary key, -- rowid alias
-       ts      text default (strftime('%Y-%m-%d %H:%M:%f', 'now')),
+       ts      text default (strftime('%Y-%m-%dT%H:%M:%f', 'now')),
        note    text not null,
        pkgid   text, -- package
        path    text, -- file path involved