about summary refs log tree commit diff stats
path: root/sql/sqlite/schema.sql
diff options
context:
space:
mode:
authorfox <fox@fakecake.org>2026-06-21 14:51:01 +0300
committerfox <fox@fakecake.org>2026-06-21 14:51:01 +0300
commit8e569855249dda7a17402e5ae20044e8149d992e (patch)
tree6a6acc9a378e2402d048a02e47b5ab99dc5247e2 /sql/sqlite/schema.sql
parent23ca9695d1b38c7a27cf132d517a6ed6b19f607a (diff)
parent17296a2ef8fa2658dca471285bce40ee67469179 (diff)
downloadthe-epube-8e569855249dda7a17402e5ae20044e8149d992e.tar.gz
the-epube-8e569855249dda7a17402e5ae20044e8149d992e.tar.xz
Merge branch 'dev' into 'master'
rework login throttling to use database field check instead of APCu

See merge request git/the-epube!64
Diffstat (limited to 'sql/sqlite/schema.sql')
-rw-r--r--sql/sqlite/schema.sql5
1 files changed, 4 insertions, 1 deletions
diff --git a/sql/sqlite/schema.sql b/sql/sqlite/schema.sql
index eeab2f9..dacb1f2 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,
@@ -21,3 +22,5 @@ create table if not exists epube_favorites(
 	id integer not null primary key autoincrement,
 	bookid integer not null,
 	owner varchar(200) not null);
+
+create index if not exists epube_users_last_auth_attempt on epube_users(last_auth_attempt);