Skip to content
This repository has been archived by the owner on Apr 24, 2021. It is now read-only.

Order of db inconsistent with personalisation tool logging #9

Open
Mrten opened this issue Oct 9, 2013 · 1 comment
Open

Order of db inconsistent with personalisation tool logging #9

Mrten opened this issue Oct 9, 2013 · 1 comment

Comments

@Mrten
Copy link

Mrten commented Oct 9, 2013

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,
@jas4711
Copy link
Contributor

jas4711 commented Oct 9, 2013

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 free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Development

No branches or pull requests

2 participants