diff options
| author | Andrew Dolgov <[email protected]> | 2021-03-12 09:19:50 +0300 |
|---|---|---|
| committer | Andrew Dolgov <[email protected]> | 2021-03-12 09:19:50 +0300 |
| commit | b9268fcc88f2f2ff03be2ec43f6206350cfc64f7 (patch) | |
| tree | 2e7324ed95d2110070ec5636cde8356d2b733260 /sql | |
| parent | 96d89fe912fa059377428b777dba7de97d8675c3 (diff) | |
schema: add ttrss_users.last_auth_attempt
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/mysql/migrations/145.sql | 2 | ||||
| -rw-r--r-- | sql/mysql/schema.sql | 3 | ||||
| -rw-r--r-- | sql/pgsql/migrations/145.sql | 2 | ||||
| -rw-r--r-- | sql/pgsql/schema.sql | 1 |
4 files changed, 7 insertions, 1 deletions
diff --git a/sql/mysql/migrations/145.sql b/sql/mysql/migrations/145.sql new file mode 100644 index 000000000..b49eccafc --- /dev/null +++ b/sql/mysql/migrations/145.sql @@ -0,0 +1,2 @@ +alter table ttrss_users add column last_auth_attempt datetime; +alter table ttrss_users alter column last_auth_attempt set default null; diff --git a/sql/mysql/schema.sql b/sql/mysql/schema.sql index 7ecaff32b..d8e6e270a 100644 --- a/sql/mysql/schema.sql +++ b/sql/mysql/schema.sql @@ -54,7 +54,8 @@ create table ttrss_users (id integer primary key not null auto_increment, twitter_oauth longtext default null, otp_enabled boolean not null default false, otp_secret varchar(250) default null, - resetpass_token varchar(250) default null) ENGINE=InnoDB DEFAULT CHARSET=UTF8; + resetpass_token varchar(250) default null, + last_auth_attempt datetime default null) ENGINE=InnoDB DEFAULT CHARSET=UTF8; insert into ttrss_users (login,pwd_hash,access_level) values ('admin', 'SHA1:5baa61e4c9b93f3f0682250b6cf8331b7ee68fd8', 10); 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', |