diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/pgsql/migrations/150.sql | 5 | ||||
| -rw-r--r-- | sql/pgsql/schema.sql | 7 |
2 files changed, 12 insertions, 0 deletions
diff --git a/sql/pgsql/migrations/150.sql b/sql/pgsql/migrations/150.sql new file mode 100644 index 000000000..55d9609e9 --- /dev/null +++ b/sql/pgsql/migrations/150.sql @@ -0,0 +1,5 @@ +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()); 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; |