diff options
author | Andrew Dolgov <[email protected]> | 2009-01-26 10:44:27 +0100 |
---|---|---|
committer | Andrew Dolgov <[email protected]> | 2009-01-26 10:44:27 +0100 |
commit | c218ceb82c23fc37179c792a6c67af5114f0d079 (patch) | |
tree | d719dd5b293dd8c95474c5cba63d33beb0a47eb1 /schema/versions/mysql | |
parent | 6fd39d8f9862a5125130022ba8fdbf5c3da78c78 (diff) |
fix mysql schema (2)
Diffstat (limited to 'schema/versions/mysql')
-rw-r--r-- | schema/versions/mysql/53.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/schema/versions/mysql/53.sql b/schema/versions/mysql/53.sql index 345d968c6..3db0cbd81 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) set default ''; +alter table ttrss_labels2 alter column fg_color 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) set default ''; +alter table ttrss_labels2 alter column bg_color set default ''; update ttrss_version set schema_version = 53; |