You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
This repository has been archived by the owner on Apr 24, 2021. It is now read-only.
The csv that the personalisation tool generates has a different column order then
the database that is created with ykksm-db.sql. This is annoying, because you have to rearrange the columns if you import the data directly by reading the CSV (I really don't see the point of gnupg-ing it and use ykksm-import if I can just copy/paste over ssh).
Small patch:
--- ykksm-db.sql.old 2013-10-09 15:46:29.839991462 +0200
+++ ykksm-db.sql 2013-10-09 15:47:22.575991460 +0200
@@ -3,14 +3,14 @@
serialnr int not null,
publicname varchar(16) unique not null,
- -- timestamps:
- created varchar(24) not null,
-
-- the data:
internalname varchar(12) not null,
aeskey varchar(32) not null,
lockcode varchar(12) not null,
+ -- timestamps:
+ created varchar(24) not null,
+
-- key creator, typically pgp key id of key generator
creator varchar(8) not null,
The text was updated successfully, but these errors were encountered:
The patch looks harmless to me, but I'd like to understand when this actually matters. Doesn't ykksm-import handle the CSV format generated by ykpers? It seems column ordering only matters if you would use mysqlimport or some other tool that doesn't understand the table semantics?
Sign up for freeto subscribe to this conversation on GitHub.
Already have an account?
Sign in.
The csv that the personalisation tool generates has a different column order then
the database that is created with
ykksm-db.sql
. This is annoying, because you have to rearrange the columns if you import the data directly by reading the CSV (I really don't see the point of gnupg-ing it and use ykksm-import if I can just copy/paste over ssh).Small patch:
The text was updated successfully, but these errors were encountered: