about summary refs log tree commit diff stats
path: root/sql/sqlite
diff options
context:
space:
mode:
Diffstat (limited to 'sql/sqlite')
-rw-r--r--sql/sqlite/migrations/3.sql2
-rw-r--r--sql/sqlite/schema.sql3
2 files changed, 4 insertions, 1 deletions
diff --git a/sql/sqlite/migrations/3.sql b/sql/sqlite/migrations/3.sql
new file mode 100644
index 0000000..450a5f1
--- /dev/null
+++ b/sql/sqlite/migrations/3.sql
@@ -0,0 +1,2 @@
+alter table epube_users add column last_auth_attempt bigint default null;
+create index if not exists idx_epube_users_last_auth_attempt on epube_users(last_auth_attempt);
diff --git a/sql/sqlite/schema.sql b/sql/sqlite/schema.sql
index eeab2f9..f14bcf9 100644
--- a/sql/sqlite/schema.sql
+++ b/sql/sqlite/schema.sql
@@ -7,7 +7,8 @@ create table if not exists epube_pagination (
 create table if not exists epube_users (
 	id integer not null primary key autoincrement,
 	username varchar(100) not null,
-	pass varchar(200) not null);
+	pass varchar(200) not null,
+	last_auth_attempt bigint default null);
 
 create table if not exists epube_books (
 	id integer not null primary key autoincrement,