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/ttrss_schema_mysql.sql | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) (limited to 'schema/ttrss_schema_mysql.sql') diff --git a/schema/ttrss_schema_mysql.sql b/schema/ttrss_schema_mysql.sql index dce3921d5..40d5c67f5 100644 --- a/schema/ttrss_schema_mysql.sql +++ b/schema/ttrss_schema_mysql.sql @@ -251,6 +251,8 @@ create table ttrss_filters2(id integer primary key auto_increment, match_any_rule boolean not null default false, enabled boolean not null default true, inverse bool not null default false, + title varchar(250) not null default '', + order_id integer not null default 0, index(owner_uid), foreign key (owner_uid) references ttrss_users(id) ON DELETE CASCADE) ENGINE=InnoDB DEFAULT CHARSET=UTF8; @@ -291,7 +293,7 @@ create table ttrss_tags (id integer primary key auto_increment, create table ttrss_version (schema_version int not null) ENGINE=InnoDB DEFAULT CHARSET=UTF8; -insert into ttrss_version values (111); +insert into ttrss_version values (112); create table ttrss_enclosures (id integer primary key auto_increment, content_url text not null, -- cgit v1.2.3-54-g00ecf