From 8e8c8934a9da12bf9e47316079407b8e62edcd7b Mon Sep 17 00:00:00 2001
From: Andrew Dolgov <fox@madoka.volgo-balt.ru>
Date: Sun, 31 Mar 2013 16:14:42 +0400
Subject: add necessary schema plumbing to implement filter ordering also add
 filter titles

---
 schema/versions/mysql/112.sql | 15 +++++++++++++++
 1 file changed, 15 insertions(+)
 create mode 100644 schema/versions/mysql/112.sql

(limited to 'schema/versions/mysql/112.sql')

diff --git a/schema/versions/mysql/112.sql b/schema/versions/mysql/112.sql
new file mode 100644
index 000000000..a6f0b200b
--- /dev/null
+++ b/schema/versions/mysql/112.sql
@@ -0,0 +1,15 @@
+begin;
+
+alter table ttrss_filters2 add column order_id integer;
+update ttrss_filters2 set order_id = 0;
+alter table ttrss_filters2 change order_id order_id integer not null;
+alter table ttrss_filters2 alter column order_id set default 0;
+
+alter table ttrss_filters2 add column title varchar(250);
+update ttrss_filters2 set title = '';
+alter table ttrss_filters2 change title title varchar(250) not null;
+alter table ttrss_filters2 alter column title set default '';
+
+update ttrss_version set schema_version = 112;
+
+commit;
-- 
cgit v1.2.3

