]>
git.wh0rd.org - tt-rss.git/blob - schema/versions/mysql/96.sql
3 create table ttrss_filters2(id integer primary key auto_increment
,
4 owner_uid
integer not null,
5 match_any_rule
boolean not null default false,
6 enabled
boolean not null default true,
8 foreign key (owner_uid
) references ttrss_users(id) ON DELETE CASCADE) ENGINE
=InnoDB
DEFAULT CHARSET
=UTF8
;
10 create table ttrss_filters2_rules(id integer primary key auto_increment
,
11 filter_id
integer not null references ttrss_filters2(id) on delete cascade,
12 reg_exp
varchar(250) not null,
13 filter_type
integer not null,
14 feed_id
integer default null,
15 cat_id
integer default null,
16 cat_filter
boolean not null default false,
18 foreign key (filter_id
) references ttrss_filters2(id) on delete cascade,
20 foreign key (filter_type
) references ttrss_filter_types(id) ON DELETE CASCADE,
22 foreign key (feed_id
) references ttrss_feeds(id) ON DELETE CASCADE,
24 foreign key (cat_id
) references ttrss_feed_categories(id) ON DELETE CASCADE) ENGINE
=InnoDB
DEFAULT CHARSET
=UTF8
;
26 create table ttrss_filters2_actions(id integer primary key auto_increment
,
27 filter_id
integer not null,
28 action_id
integer not null default 1 references ttrss_filter_actions(id) on delete cascade,
29 action_param
varchar(250) not null default '',
31 foreign key (filter_id
) references ttrss_filters2(id) on delete cascade,
33 foreign key (action_id
) references ttrss_filter_actions(id) ON DELETE CASCADE) ENGINE
=InnoDB
DEFAULT CHARSET
=UTF8
;
35 update ttrss_version
set schema_version
= 96;