fix schema for favicon_avg_color

[tt-rss.git] / schema / versions / mysql / 117.sql

diff --git a/schema/versions/mysql/117.sql b/schema/versions/mysql/117.sql
index 008f819edb1ed4a55eba0120ccd77cfa9eac0d7f..da3d056cc7a6959d4e2b1eec043539f2e37aa5dc 100644 (file)
--- a/schema/versions/mysql/117.sql
+++ b/schema/versions/mysql/117.sql
@@ -1,6 +1,7 @@
 begin;
 
-ALTER TABLE `ttrss_feeds` ADD favicon_avg_color VARCHAR(11)
+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;