diff options
author | b1galez <b1galez@fbcee277-3294-991b-8290-beb7048acdd6> | 2010-12-14 10:40:58 +0000 |
---|---|---|
committer | b1galez <b1galez@fbcee277-3294-991b-8290-beb7048acdd6> | 2010-12-14 10:40:58 +0000 |
commit | 14c76e5b936e3c91d88d21e30558d4eee1ab98ef (patch) | |
tree | 3c5d639ef203e7d43154f58edeac4172ce084a2f /src/dump.sqlite | |
parent | Fixed version identification in headers sent to client. (diff) | |
download | yubico-yubiserve-14c76e5b936e3c91d88d21e30558d4eee1ab98ef.tar.gz yubico-yubiserve-14c76e5b936e3c91d88d21e30558d4eee1ab98ef.tar.bz2 yubico-yubiserve-14c76e5b936e3c91d88d21e30558d4eee1ab98ef.zip |
3.0 Release, added MySQL support, various fixes.
git-svn-id: http://yubico-yubiserve.googlecode.com/svn/trunk@29 fbcee277-3294-991b-8290-beb7048acdd6
Diffstat (limited to 'src/dump.sqlite')
-rwxr-xr-x | src/dump.sqlite | 25 |
1 files changed, 25 insertions, 0 deletions
diff --git a/src/dump.sqlite b/src/dump.sqlite new file mode 100755 index 0000000..7cb972e --- /dev/null +++ b/src/dump.sqlite @@ -0,0 +1,25 @@ +BEGIN TRANSACTION; +create table yubikeys( + nickname varchar(16) unique not null, + publicname varchar(16) unique not null, + created varchar(24) not null, + internalname varchar(12) not null, + aeskey varchar(32) not null, + active boolean default true, + counter integer not null default 1, + time integer not null default 1 +); +create table oathtokens( + nickname varchar(16) unique not null, + publicname varchar(12) unique not null, + created varchar(24) not null, + secret varchar(40) not null, + active boolean default true, + counter integer not null default 1 +); +create table apikeys( + nickname varchar(16), + secret varchar(28), + id integer primary key +); +COMMIT; |