rate-limit requests for favicons when not present to conserve traffic (refs #457)

2 files changed, 16 insertions, 0 deletions

diff --git a/schema/versions/mysql/92.sql b/schema/versions/mysql/92.sql
new file mode 100644
index 000000000..8ebe81fe0
--- /dev/null
+++ b/schema/versions/mysql/92.sql
@@ -0,0 +1,8 @@
+begin;
+
+alter table ttrss_feeds add column favicon_last_checked datetime;
+alter table ttrss_feeds alter column favicon_last_checked set default null;
+
+update ttrss_version set schema_version = 92;
+
+commit;
diff --git a/schema/versions/pgsql/92.sql b/schema/versions/pgsql/92.sql
new file mode 100644
index 000000000..b683d514d
--- /dev/null
+++ b/schema/versions/pgsql/92.sql
@@ -0,0 +1,8 @@
+begin;
+
+alter table ttrss_feeds add column favicon_last_checked timestamp;
+alter table ttrss_feeds alter column favicon_last_checked set default null;
+
+update ttrss_version set schema_version = 92;
+
+commit;