1 files changed, 23 insertions, 7 deletions
diff --git a/src/dump.sql b/src/dump.sql
index 859b68b..7cb972e 100644
--- a/src/dump.sql
+++ b/src/dump.sql
@@ -1,9 +1,25 @@
+BEGIN TRANSACTION;
 create table yubikeys(
-	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
+ 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;