about summary refs log tree commit diff stats
path: root/sql/pgsql/schema.sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql/pgsql/schema.sql')
-rw-r--r--sql/pgsql/schema.sql6
1 files changed, 4 insertions, 2 deletions
diff --git a/sql/pgsql/schema.sql b/sql/pgsql/schema.sql
index 2d02190..df76b16 100644
--- a/sql/pgsql/schema.sql
+++ b/sql/pgsql/schema.sql
@@ -1,7 +1,8 @@
 create table if not exists epube_users (
 	id serial not null primary key,
 	username varchar(100) not null unique,
-	pass varchar(200) not null);
+	pass varchar(200) not null,
+	last_auth_attempt bigint default null);
 
 create table if not exists epube_pagination (
 	id serial not null primary key,
@@ -26,4 +27,5 @@ create table if not exists epube_sessions (id varchar(250) not null primary key,
 	data text,
 	expire integer not null);
 
-create index epube_sessions_expire_index on epube_sessions(expire);
+create index if not exists epube_sessions_expire_index on epube_sessions(expire);
+create index if not exists epube_users_last_auth_attempt on epube_users(last_auth_attempt);