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

2 files changed, 9 insertions, 1 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;
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;