From 8e8c8934a9da12bf9e47316079407b8e62edcd7b Mon Sep 17 00:00:00 2001 From: Andrew Dolgov 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