diff options
author | Andrew Dolgov <[email protected]> | 2012-08-30 18:50:56 +0400 |
---|---|---|
committer | Andrew Dolgov <[email protected]> | 2012-08-31 12:13:47 +0400 |
commit | 6aff7845751e1671f436da6686209b414fdcfcc4 (patch) | |
tree | 412bfad8bdb8d23eebb84ff96ba6077e901f6d8b /schema/versions/pgsql | |
parent | f9ebb32ca0a84ec5553d0494cdfc628753fcb36a (diff) |
implement multiple rule/action filters
Diffstat (limited to 'schema/versions/pgsql')
-rw-r--r-- | schema/versions/pgsql/96.sql | 23 |
1 files changed, 23 insertions, 0 deletions
diff --git a/schema/versions/pgsql/96.sql b/schema/versions/pgsql/96.sql new file mode 100644 index 000000000..86895e5e0 --- /dev/null +++ b/schema/versions/pgsql/96.sql @@ -0,0 +1,23 @@ +begin; + +create table ttrss_filters2(id serial not null primary key, + owner_uid integer not null references ttrss_users(id) on delete cascade, + match_any_rule boolean not null default false, + enabled boolean not null default true); + +create table ttrss_filters2_rules(id serial not null primary key, + filter_id integer not null references ttrss_filters2(id) on delete cascade, + reg_exp varchar(250) not null, + filter_type integer not null references ttrss_filter_types(id), + feed_id integer references ttrss_feeds(id) on delete cascade default null, + cat_id integer references ttrss_feed_categories(id) on delete cascade default null, + cat_filter boolean not null default false); + +create table ttrss_filters2_actions(id serial not null primary key, + filter_id integer not null references ttrss_filters2(id) on delete cascade, + action_id integer not null default 1 references ttrss_filter_actions(id) on delete cascade, + action_param varchar(250) not null default ''); + +update ttrss_version set schema_version = 95; + +commit; |