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/migrations/151.sql | 6 ++++++
 1 file changed, 6 insertions(+)
 create mode 100644 sql/pgsql/migrations/151.sql

(limited to 'sql/pgsql/migrations')

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;
-- 
cgit v1.2.3-54-g00ecf