From a268f52de695fffb29769960332bfb34fe3ac7b5 Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Fri, 2 May 2025 10:23:30 +0300 Subject: record task duration in seconds --- sql/pgsql/migrations/150.sql | 1 + sql/pgsql/schema.sql | 1 + 2 files changed, 2 insertions(+) (limited to 'sql') diff --git a/sql/pgsql/migrations/150.sql b/sql/pgsql/migrations/150.sql index 55d9609e9..c0aae3bdf 100644 --- a/sql/pgsql/migrations/150.sql +++ b/sql/pgsql/migrations/150.sql @@ -1,5 +1,6 @@ create table ttrss_scheduled_tasks( id serial not null primary key, task_name varchar(250) unique not null, + last_duration integer not null, last_rc integer not null, last_run timestamp not null default NOW()); diff --git a/sql/pgsql/schema.sql b/sql/pgsql/schema.sql index 3ff9a6674..7e995f915 100644 --- a/sql/pgsql/schema.sql +++ b/sql/pgsql/schema.sql @@ -398,6 +398,7 @@ create table ttrss_error_log( create table ttrss_scheduled_tasks( id serial not null primary key, task_name varchar(250) unique not null, + last_duration integer not null, last_rc integer not null, last_run timestamp not null default NOW()); -- cgit v1.2.3-54-g00ecf