diff options
author | Andrew Dolgov <[email protected]> | 2013-03-17 15:32:44 +0400 |
---|---|---|
committer | Andrew Dolgov <[email protected]> | 2013-03-17 15:38:21 +0400 |
commit | 7873d588227cba4c66e2535b1be631736415ef6f (patch) | |
tree | 362182a8794f2cd3b094a7d66c088150527ba58f /schema/versions/pgsql/105.sql | |
parent | f01c8ec4f1324ed8b68e912220735af96c86883c (diff) |
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
Diffstat (limited to 'schema/versions/pgsql/105.sql')
-rw-r--r-- | schema/versions/pgsql/105.sql | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/schema/versions/pgsql/105.sql b/schema/versions/pgsql/105.sql new file mode 100644 index 000000000..11ef679f1 --- /dev/null +++ b/schema/versions/pgsql/105.sql @@ -0,0 +1,11 @@ +begin; + +alter table ttrss_user_entries add column last_marked timestamp; +alter table ttrss_user_entries add column last_published timestamp; + +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; |