summaryrefslogtreecommitdiff
path: root/schema/versions
diff options
context:
space:
mode:
authorAndrew Dolgov <[email protected]>2013-04-15 14:54:17 +0400
committerAndrew Dolgov <[email protected]>2013-04-15 14:54:17 +0400
commit14118af36f2ba65a4e5151ee33b6ad565492cbf0 (patch)
treeac4dc7c130dcce952e6b059022a7259ee720eecb /schema/versions
parent2cfbb448fb197837c063c377c042beb3ba704a52 (diff)
fix schema for favicon_avg_color
Diffstat (limited to 'schema/versions')
-rw-r--r--schema/versions/mysql/117.sql3
1 files changed, 2 insertions, 1 deletions
diff --git a/schema/versions/mysql/117.sql b/schema/versions/mysql/117.sql
index 008f819ed..da3d056cc 100644
--- 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;