From 5263a07f61698eb26e0482129d66c5ab4be1c9c5 Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Sun, 4 May 2025 18:06:43 +0300 Subject: record last cron expression (and stub owner_uid) used by scheduled task --- sql/pgsql/migrations/151.sql | 6 ++++++ sql/pgsql/schema.sql | 4 +++- 2 files changed, 9 insertions(+), 1 deletion(-) create mode 100644 sql/pgsql/migrations/151.sql (limited to 'sql') diff --git a/sql/pgsql/migrations/151.sql b/sql/pgsql/migrations/151.sql new file mode 100644 index 000000000..c3d9c159b --- /dev/null +++ b/sql/pgsql/migrations/151.sql @@ -0,0 +1,6 @@ +alter table ttrss_scheduled_tasks add column owner_uid integer default null references ttrss_users(id) ON DELETE CASCADE; +alter table ttrss_scheduled_tasks add column last_cron_expression varchar(250); + +update ttrss_scheduled_tasks set last_cron_expression = ''; + +alter table ttrss_scheduled_tasks alter column last_cron_expression set not null; diff --git a/sql/pgsql/schema.sql b/sql/pgsql/schema.sql index 3145629fc..21e3fd83a 100644 --- a/sql/pgsql/schema.sql +++ b/sql/pgsql/schema.sql @@ -400,6 +400,8 @@ create table ttrss_scheduled_tasks( task_name varchar(250) unique not null, last_duration integer not null, last_rc integer not null, - last_run timestamp not null default NOW()); + last_run timestamp not null default NOW(), + last_cron_expression varchar(250) not null, + owner_uid integer default null references ttrss_users(id) ON DELETE CASCADE); commit; -- cgit v1.2.3-54-g00ecf