schema/versions/mysql/53.sql

   1 alter table ttrss_labels2 add column fg_color varchar(15);
   2 update ttrss_labels2 set fg_color = '';
   3 alter table ttrss_labels2 change fg_color fg_color varchar(15) not null;
   4 alter table ttrss_labels2 change fg_color fg_color varchar(15) set default '';
   5
   6 alter table ttrss_labels2 add column bg_color varchar(15);
   7 update ttrss_labels2 set bg_color = '';
   8 alter table ttrss_labels2 change bg_color bg_color varchar(15) not null;
   9 alter table ttrss_labels2 change fg_color bg_color varchar(15) set default '';
  10
  11 update ttrss_version set schema_version = 53;