summaryrefslogtreecommitdiff
path: root/sql/pgsql/schema.sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql/pgsql/schema.sql')
-rw-r--r--sql/pgsql/schema.sql7
1 files changed, 7 insertions, 0 deletions
diff --git a/sql/pgsql/schema.sql b/sql/pgsql/schema.sql
index acfa619c9..3ff9a6674 100644
--- a/sql/pgsql/schema.sql
+++ b/sql/pgsql/schema.sql
@@ -1,3 +1,4 @@
+drop table if exists ttrss_scheduled_tasks;
drop table if exists ttrss_error_log;
drop table if exists ttrss_plugin_storage;
drop table if exists ttrss_linked_feeds;
@@ -394,4 +395,10 @@ create table ttrss_error_log(
context text not null,
created_at timestamp not null);
+create table ttrss_scheduled_tasks(
+ id serial not null primary key,
+ task_name varchar(250) unique not null,
+ last_rc integer not null,
+ last_run timestamp not null default NOW());
+
commit;