From b9268fcc88f2f2ff03be2ec43f6206350cfc64f7 Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Fri, 12 Mar 2021 09:19:50 +0300 Subject: schema: add ttrss_users.last_auth_attempt --- sql/pgsql/migrations/145.sql | 2 ++ sql/pgsql/schema.sql | 1 + 2 files changed, 3 insertions(+) create mode 100644 sql/pgsql/migrations/145.sql (limited to 'sql/pgsql') diff --git a/sql/pgsql/migrations/145.sql b/sql/pgsql/migrations/145.sql new file mode 100644 index 000000000..754d06963 --- /dev/null +++ b/sql/pgsql/migrations/145.sql @@ -0,0 +1,2 @@ +alter table ttrss_users add column last_auth_attempt timestamp; +alter table ttrss_users alter column last_auth_attempt set default null; diff --git a/sql/pgsql/schema.sql b/sql/pgsql/schema.sql index 6130b633c..50bf375f2 100644 --- a/sql/pgsql/schema.sql +++ b/sql/pgsql/schema.sql @@ -52,6 +52,7 @@ create table ttrss_users (id serial not null primary key, otp_enabled boolean not null default false, otp_secret varchar(250) default null, resetpass_token varchar(250) default null, + last_auth_attempt timestamp default null, created timestamp default null); insert into ttrss_users (login,pwd_hash,access_level) values ('admin', -- cgit v1.2.3-54-g00ecf