From 7873d588227cba4c66e2535b1be631736415ef6f Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Sun, 17 Mar 2013 15:32:44 +0400 Subject: implement proper last_marked/last_published feeds for proper sorting of published and marked virtual feeds, remove sorting by last_read workaround api: add pubsubhubbub ping when article is being set published bump schema --- schema/versions/mysql/105.sql | 11 +++++++++++ 1 file changed, 11 insertions(+) create mode 100644 schema/versions/mysql/105.sql (limited to 'schema/versions/mysql') diff --git a/schema/versions/mysql/105.sql b/schema/versions/mysql/105.sql new file mode 100644 index 000000000..a96101784 --- /dev/null +++ b/schema/versions/mysql/105.sql @@ -0,0 +1,11 @@ +begin; + +alter table ttrss_user_entries add column last_marked datetime; +alter table ttrss_user_entries add column last_published datetime; + +update ttrss_user_entries set last_published = last_read where published = true; +update ttrss_user_entries set last_marked = last_read where marked = true; + +update ttrss_version set schema_version = 105; + +commit; -- cgit v1.2.3