diff options
| author | Andrew Dolgov <fox@fakecake.org> | 2026-06-21 14:37:09 +0300 |
|---|---|---|
| committer | Andrew Dolgov <fox@fakecake.org> | 2026-06-21 14:37:09 +0300 |
| commit | 5a2b451afb7a5c794b5da19dd22b4ba40c256b03 (patch) | |
| tree | 7e2ae0bf2a8cd88ccc70fefdee2d4c3c288e9a92 /sql/pgsql | |
| parent | 1215afa6ef28a6e0a53aab98263e922b7c66a580 (diff) | |
| download | the-epube-5a2b451afb7a5c794b5da19dd22b4ba40c256b03.tar.gz the-epube-5a2b451afb7a5c794b5da19dd22b4ba40c256b03.tar.xz | |
rework login throttling to use database field check instead of APCu
Diffstat (limited to 'sql/pgsql')
| -rw-r--r-- | sql/pgsql/migrations/3.sql | 2 | ||||
| -rw-r--r-- | sql/pgsql/schema.sql | 3 |
2 files changed, 4 insertions, 1 deletions
diff --git a/sql/pgsql/migrations/3.sql b/sql/pgsql/migrations/3.sql new file mode 100644 index 0000000..450a5f1 --- /dev/null +++ b/sql/pgsql/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/pgsql/schema.sql b/sql/pgsql/schema.sql index 2d02190..950bfad 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, |
