summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--schema/versions/mysql/27.sql4
-rw-r--r--schema/versions/pgsql/27.sql4
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;