X-Git-Url: https://pd.if.org/git/?p=zpackage;a=blobdiff_plain;f=schema%2Fmain.sql;h=b0675509e1a6884e8b2ba6560a91350111bed3fd;hp=c9c79a26e0f338920d9bfcf0894066a2ef23cc47;hb=d697639ca6483bdee0ab043f85a2266fe7c62956;hpb=f523c503b7afe9964eb2c659f42c3cabbe725ae2

diff --git a/schema/main.sql b/schema/main.sql
index c9c79a2..b067550 100644
--- 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