From aec57d7ad4a0eb3a62743d54e69e1a4cc3dd74ea Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Mon, 26 Jan 2009 10:41:16 +0100 Subject: schema: add ttrss_labels2 color fields (bump schema) --- schema/versions/mysql/53.sql | 11 +++++++++++ 1 file changed, 11 insertions(+) create mode 100644 schema/versions/mysql/53.sql (limited to 'schema/versions/mysql') diff --git a/schema/versions/mysql/53.sql b/schema/versions/mysql/53.sql new file mode 100644 index 000000000..cd96853c1 --- /dev/null +++ b/schema/versions/mysql/53.sql @@ -0,0 +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 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 ''; + +update ttrss_version set schema_version = 53; -- cgit v1.2.3