add last_login field to ttrss_users

2 files changed, 2 insertions, 0 deletions

diff --git a/schema/ttrss_schema_mysql.sql b/schema/ttrss_schema_mysql.sql
index e8cf6e5eb..5e8b544ce 100644
--- a/schema/ttrss_schema_mysql.sql
+++ b/schema/ttrss_schema_mysql.sql
@@ -10,6 +10,7 @@ drop table if exists ttrss_users;
 create table ttrss_users (id integer primary key not null auto_increment,
 	login varchar(120) not null unique,
 	pwd_hash varchar(250) not null,
+	last_login timestamp default null,
 	access_level integer not null default 0) TYPE=InnoDB;
 
 insert into ttrss_users (login,pwd_hash,access_level) values ('admin', 'password', 10);
diff --git a/schema/ttrss_schema_pgsql.sql b/schema/ttrss_schema_pgsql.sql
index b6832040c..fdcd6105e 100644
--- a/schema/ttrss_schema_pgsql.sql
+++ b/schema/ttrss_schema_pgsql.sql
@@ -10,6 +10,7 @@ drop table ttrss_users;
 create table ttrss_users (id serial not null primary key,
 	login varchar(120) not null unique,
 	pwd_hash varchar(250) not null,
+	last_login timestamp default null,
 	access_level integer not null default 0);
 
 insert into ttrss_users (login,pwd_hash,access_level) values ('admin', 'password', 10);