3 -- This should work with at least PostgreSQL. Maybe more --
7 yubikey_id serial NOT NULL,
8 active boolean NOT NULL DEFAULT 'f',
9 public_id varchar, -- fixed public bit of the key's output, modhex encoded
10 secret_uid bytea NOT NULL, -- secret uid bit of the key
11 secret_key bytea NOT NULL,
16 INSERT INTO yubikey (active, public_id,
17 secret_uid, secret_key, session_counter, session_use) VALUES
19 E'\\000\\000\\000\\000\\000\\000',
20 decode('baef43c254e9d2217912e80ed71a7b4a', 'hex'),
23 CREATE TABLE shared_secret (
24 secret_id serial NOT NULL,
25 secret bytea NOT NULL,
26 active boolean NOT NULL DEFAULT 'f'
29 INSERT INTO shared_secret (secret, active) VALUES (decode('MQ6fOy1t/add/wisbu2O+LpPiMs=', 'base64'), 't');