From 5263a07f61698eb26e0482129d66c5ab4be1c9c5 Mon Sep 17 00:00:00 2001
From: Andrew Dolgov <fox@fakecake.org>
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

