From f7f939b29c44fbc13e567c855bcb2a35e1083030 Mon Sep 17 00:00:00 2001
From: Andrew Dolgov <fox@madoka.spb.ru>
Date: Thu, 18 Sep 2008 06:02:43 +0100
Subject: alter ttrss_labels.sql_exp to text, bump schema (closes #221)

---
 schema/versions/pgsql/43.sql | 7 +++++++
 1 file changed, 7 insertions(+)
 create mode 100644 schema/versions/pgsql/43.sql

(limited to 'schema/versions/pgsql/43.sql')

diff --git a/schema/versions/pgsql/43.sql b/schema/versions/pgsql/43.sql
new file mode 100644
index 000000000..52bc365cc
--- /dev/null
+++ b/schema/versions/pgsql/43.sql
@@ -0,0 +1,7 @@
+alter table ttrss_labels rename column sql_exp to sql_exp_old;
+alter table ttrss_labels add column sql_exp text;
+update ttrss_labels set sql_exp = sql_exp_old;
+alter table ttrss_labels alter column sql_exp set not null;
+alter table ttrss_labels drop column sql_exp_old;
+
+update ttrss_version set schema_version = 43;
-- 
cgit v1.2.3

