add schema version 177 upgrade scripts

diff --git a/schema/versions/pgsql/117.sql b/schema/versions/pgsql/117.sql
new file mode 100644 (file)
index 0000000..da3d056
--- /dev/null
+++ b/schema/versions/pgsql/117.sql
@@ -0,0 +1,8 @@
+begin;
+
+ALTER TABLE ttrss_feeds ADD COLUMN favicon_avg_color VARCHAR(11);
+alter table ttrss_feeds alter column favicon_avg_color set default null;
+
+update ttrss_version set schema_version = 117;
+
+commit;