about summary refs log tree commit diff stats
path: root/sql/sqlite/schema.sql
diff options
context:
space:
mode:
authorAndrew Dolgov <fox@fakecake.org>2026-06-21 14:37:09 +0300
committerAndrew Dolgov <fox@fakecake.org>2026-06-21 14:37:09 +0300
commit5a2b451afb7a5c794b5da19dd22b4ba40c256b03 (patch)
tree7e2ae0bf2a8cd88ccc70fefdee2d4c3c288e9a92 /sql/sqlite/schema.sql
parent1215afa6ef28a6e0a53aab98263e922b7c66a580 (diff)
downloadthe-epube-5a2b451afb7a5c794b5da19dd22b4ba40c256b03.tar.gz
the-epube-5a2b451afb7a5c794b5da19dd22b4ba40c256b03.tar.xz
rework login throttling to use database field check instead of APCu
Diffstat (limited to 'sql/sqlite/schema.sql')
-rw-r--r--sql/sqlite/schema.sql3
1 files changed, 2 insertions, 1 deletions
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,