record last cron expression (and stub owner_uid) used by scheduled task

1 files changed, 6 insertions, 0 deletions

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;