From 6fd39d8f9862a5125130022ba8fdbf5c3da78c78 Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Mon, 26 Jan 2009 10:42:44 +0100 Subject: [PATCH] fix mysql schema --- schema/versions/mysql/53.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/schema/versions/mysql/53.sql b/schema/versions/mysql/53.sql index cd96853c..345d968c 100644 --- a/schema/versions/mysql/53.sql +++ b/schema/versions/mysql/53.sql @@ -1,11 +1,11 @@ alter table ttrss_labels2 add column fg_color varchar(15); update ttrss_labels2 set fg_color = ''; alter table ttrss_labels2 change fg_color fg_color varchar(15) not null; -alter table ttrss_labels2 change fg_color fg_color varchar(15) not default ''; +alter table ttrss_labels2 change fg_color fg_color varchar(15) set default ''; alter table ttrss_labels2 add column bg_color varchar(15); update ttrss_labels2 set bg_color = ''; alter table ttrss_labels2 change bg_color bg_color varchar(15) not null; -alter table ttrss_labels2 change fg_color bg_color varchar(15) not default ''; +alter table ttrss_labels2 change fg_color bg_color varchar(15) set default ''; update ttrss_version set schema_version = 53; -- 2.39.5