diff options
-rw-r--r-- | schema/versions/mysql/27.sql | 4 | ||||
-rw-r--r-- | schema/versions/pgsql/27.sql | 4 |
2 files changed, 8 insertions, 0 deletions
diff --git a/schema/versions/mysql/27.sql b/schema/versions/mysql/27.sql new file mode 100644 index 000000000..fcd6e8509 --- /dev/null +++ b/schema/versions/mysql/27.sql @@ -0,0 +1,4 @@ +alter table ttrss_feeds add column last_viewed datetime; +alter table ttrss_feeds alter column last_viewed set default null; + +update ttrss_version set schema_version = 27; diff --git a/schema/versions/pgsql/27.sql b/schema/versions/pgsql/27.sql new file mode 100644 index 000000000..d0baaebc0 --- /dev/null +++ b/schema/versions/pgsql/27.sql @@ -0,0 +1,4 @@ +alter table ttrss_feeds add column last_viewed timestamp; +alter table ttrss_feeds alter column last_viewed set default null; + +update ttrss_version set schema_version = 27; |