From aec57d7ad4a0eb3a62743d54e69e1a4cc3dd74ea Mon Sep 17 00:00:00 2001
From: Andrew Dolgov <fox@bah.spb.su>
Date: Mon, 26 Jan 2009 10:41:16 +0100
Subject: schema: add ttrss_labels2 color fields (bump schema)

---
 schema/versions/mysql/53.sql | 11 +++++++++++
 schema/versions/pgsql/53.sql | 15 +++++++++++++++
 2 files changed, 26 insertions(+)
 create mode 100644 schema/versions/mysql/53.sql
 create mode 100644 schema/versions/pgsql/53.sql

(limited to 'schema/versions')

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;
diff --git a/schema/versions/pgsql/53.sql b/schema/versions/pgsql/53.sql
new file mode 100644
index 000000000..adcf6fdec
--- /dev/null
+++ b/schema/versions/pgsql/53.sql
@@ -0,0 +1,15 @@
+begin;
+
+alter table ttrss_labels2 add column fg_color varchar(15);
+update ttrss_labels2 set fg_color = '';
+alter table ttrss_labels2 alter column fg_color set not null;
+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 alter column bg_color set not null;
+alter table ttrss_labels2 alter column bg_color set default '';
+
+update ttrss_version set schema_version = 53;
+
+commit;
-- 
cgit v1.2.3-54-g00ecf