From de22464ea818b2e6094ce92d0432090d47936ea9 Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Mon, 28 Sep 2020 14:14:06 +0300 Subject: schema: add ttrss_feeds.last_successful_update --- schema/versions/mysql/140.sql | 4 ++++ schema/versions/pgsql/140.sql | 4 ++++ 2 files changed, 8 insertions(+) create mode 100644 schema/versions/mysql/140.sql create mode 100644 schema/versions/pgsql/140.sql (limited to 'schema/versions') diff --git a/schema/versions/mysql/140.sql b/schema/versions/mysql/140.sql new file mode 100644 index 000000000..91215eff1 --- /dev/null +++ b/schema/versions/mysql/140.sql @@ -0,0 +1,4 @@ +alter table ttrss_feeds add column last_successful_update datetime; +alter table ttrss_feeds alter column last_successful_update set default null; + +update ttrss_version set schema_version = 140; diff --git a/schema/versions/pgsql/140.sql b/schema/versions/pgsql/140.sql new file mode 100644 index 000000000..985e30241 --- /dev/null +++ b/schema/versions/pgsql/140.sql @@ -0,0 +1,4 @@ +alter table ttrss_feeds add column last_successful_update timestamp; +alter table ttrss_feeds alter column last_successful_update set default null; + +update ttrss_version set schema_version = 140; -- cgit v1.2.3-54-g00ecf