schema: add missing stuff

1 files changed, 2 insertions, 0 deletions

diff --git a/schema/ttrss_schema_pgsql.sql b/schema/ttrss_schema_pgsql.sql
index a0b76ab62..edd347cfd 100644
--- a/schema/ttrss_schema_pgsql.sql
+++ b/schema/ttrss_schema_pgsql.sql
@@ -60,6 +60,8 @@ create table ttrss_app_passwords (id serial not null primary key,
     title varchar(250) not null,
     pwd_hash text not null,
     service varchar(100) not null,
+    created timestamp not null,
+    last_used timestamp default null,
     owner_uid integer not null references ttrss_users(id) on delete cascade);
 
 create table ttrss_feed_categories(id serial not null primary key,