diff options
author | Andrew Dolgov <[email protected]> | 2009-01-26 10:41:16 +0100 |
---|---|---|
committer | Andrew Dolgov <[email protected]> | 2009-01-26 10:41:16 +0100 |
commit | aec57d7ad4a0eb3a62743d54e69e1a4cc3dd74ea (patch) | |
tree | bcb0eea42ce94df578e996b04174bca367d30bd6 /schema/versions/mysql/53.sql | |
parent | 56ff7564477b7c72a8c82fd64b59fe53e3321470 (diff) |
schema: add ttrss_labels2 color fields (bump schema)
Diffstat (limited to 'schema/versions/mysql/53.sql')
-rw-r--r-- | schema/versions/mysql/53.sql | 11 |
1 files changed, 11 insertions, 0 deletions
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; |