File: ykksm-db.sql

package info (click to toggle)
yubikey-ksm 1.15-6
  • links: PTS, VCS
  • area: main
  • in suites: stretch
  • size: 268 kB
  • ctags: 91
  • sloc: perl: 416; php: 143; sh: 123; makefile: 87; sql: 12
file content (22 lines) | stat: -rw-r--r-- 479 bytes parent folder | download | duplicates (4)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
create table yubikeys (
  -- identities:
  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,

  -- key creator, typically pgp key id of key generator
  creator varchar(8) not null,

  -- various flags:
  active boolean default true,
  hardware boolean default true,

  primary key (publicname)
);