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/schema.sql | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) (limited to 'sql/pgsql/schema.sql') 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