From 092b9ee9294db6d2be440d32a3f3e643ced47ca2 Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Wed, 21 Nov 2007 13:33:06 +0100 Subject: [PATCH] add schema ver 27 --- schema/versions/mysql/27.sql | 4 ++++ schema/versions/pgsql/27.sql | 4 ++++ 2 files changed, 8 insertions(+) create mode 100644 schema/versions/mysql/27.sql create mode 100644 schema/versions/pgsql/27.sql diff --git a/schema/versions/mysql/27.sql b/schema/versions/mysql/27.sql new file mode 100644 index 00000000..fcd6e850 --- /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 00000000..d0baaebc --- /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; -- 2.39.2