diff options
author | Andrew Dolgov <[email protected]> | 2013-03-25 19:46:43 +0400 |
---|---|---|
committer | Andrew Dolgov <[email protected]> | 2013-03-25 19:46:43 +0400 |
commit | a3a896a127b90548d404d347f3665a7e6ac90f40 (patch) | |
tree | cc2650a5c396adf69e45b69f5862e14733765763 /schema/ttrss_schema_mysql.sql | |
parent | aff02f89c112dc147213a877d582c873ae981514 (diff) |
let us rejoice on being able to create double negative filters (refs #631)
Diffstat (limited to 'schema/ttrss_schema_mysql.sql')
-rw-r--r-- | schema/ttrss_schema_mysql.sql | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/schema/ttrss_schema_mysql.sql b/schema/ttrss_schema_mysql.sql index 438865478..0d3358748 100644 --- a/schema/ttrss_schema_mysql.sql +++ b/schema/ttrss_schema_mysql.sql @@ -274,12 +274,14 @@ create table ttrss_filters2(id integer primary key auto_increment, owner_uid integer not null, match_any_rule boolean not null default false, enabled boolean not null default true, + inverse bool not null default false, index(owner_uid), foreign key (owner_uid) references ttrss_users(id) ON DELETE CASCADE) ENGINE=InnoDB DEFAULT CHARSET=UTF8; create table ttrss_filters2_rules(id integer primary key auto_increment, filter_id integer not null references ttrss_filters2(id) on delete cascade, reg_exp varchar(250) not null, + inverse bool not null default false, filter_type integer not null, feed_id integer default null, cat_id integer default null, @@ -313,7 +315,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 (106); +insert into ttrss_version values (107); create table ttrss_enclosures (id integer primary key auto_increment, content_url text not null, |