1
2
3
4
5
6
7
8

-- rss-kakapo: per-feed state for polite polling.
--   feed_etag, feed_last_modified: validators from the last 200 response,
--     sent back as If-None-Match / If-Modified-Since so an unchanged feed
--     costs a 304 instead of a full download.
--   fetch_failures: consecutive failed checks, for exponential backoff.
ALTER TABLE accounts ADD COLUMN feed_etag TEXT NOT NULL DEFAULT '';
ALTER TABLE accounts ADD COLUMN feed_last_modified TEXT NOT NULL DEFAULT '';
ALTER TABLE accounts ADD COLUMN fetch_failures INTEGER NOT NULL DEFAULT 0;