From 6a40940ad6c6facea6c8e9d0dc1896885168c442 Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Fri, 2 May 2025 10:17:13 +0300 Subject: split housekeeping jobs to separate scheduled tasks on longer cooldown intervals, add table to record task execution timestamps, bump schema --- sql/pgsql/migrations/150.sql | 5 +++++ sql/pgsql/schema.sql | 7 +++++++ 2 files changed, 12 insertions(+) create mode 100644 sql/pgsql/migrations/150.sql (limited to 'sql') diff --git a/sql/pgsql/migrations/150.sql b/sql/pgsql/migrations/150.sql new file mode 100644 index 000000000..55d9609e9 --- /dev/null +++ b/sql/pgsql/migrations/150.sql @@ -0,0 +1,5 @@ +create table ttrss_scheduled_tasks( + id serial not null primary key, + task_name varchar(250) unique 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 acfa619c9..3ff9a6674 100644 --- a/sql/pgsql/schema.sql +++ b/sql/pgsql/schema.sql @@ -1,3 +1,4 @@ +drop table if exists ttrss_scheduled_tasks; drop table if exists ttrss_error_log; drop table if exists ttrss_plugin_storage; drop table if exists ttrss_linked_feeds; @@ -394,4 +395,10 @@ create table ttrss_error_log( context text not null, created_at timestamp not null); +create table ttrss_scheduled_tasks( + id serial not null primary key, + task_name varchar(250) unique not null, + last_rc integer not null, + last_run timestamp not null default NOW()); + commit; -- cgit v1.2.3-54-g00ecf