summaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorAndrew Dolgov <fox@fakecake.org>2025-05-02 10:23:30 +0300
committerAndrew Dolgov <fox@fakecake.org>2025-05-02 10:23:30 +0300
commita268f52de695fffb29769960332bfb34fe3ac7b5 (patch)
tree76aea12e8a45115da93dc7a53ee8b71038aeb4d9 /sql
parent6a40940ad6c6facea6c8e9d0dc1896885168c442 (diff)
record task duration in seconds
Diffstat (limited to 'sql')
-rw-r--r--sql/pgsql/migrations/150.sql1
-rw-r--r--sql/pgsql/schema.sql1
2 files changed, 2 insertions, 0 deletions
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());