diff options
| author | Andrew Dolgov <[email protected]> | 2020-09-28 14:14:06 +0300 |
|---|---|---|
| committer | Andrew Dolgov <[email protected]> | 2020-09-28 14:14:06 +0300 |
| commit | de22464ea818b2e6094ce92d0432090d47936ea9 (patch) | |
| tree | 23a3bc7e732902c1a84cf2fa81ecdaaf363e791c /schema/versions | |
| parent | 97d7e5a42a79fdd8fb54baf73a3d715385dccddf (diff) | |
schema: add ttrss_feeds.last_successful_update
Diffstat (limited to 'schema/versions')
| -rw-r--r-- | schema/versions/mysql/140.sql | 4 | ||||
| -rw-r--r-- | schema/versions/pgsql/140.sql | 4 |
2 files changed, 8 insertions, 0 deletions
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; |