From 9ebaec057c6c9e1644eb7673ddb3f709b9874bb8 Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Fri, 8 Dec 2006 07:31:49 +0100 Subject: ttrss_filters: add action_param field, bump schema version --- schema/ttrss_schema_pgsql.sql | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) (limited to 'schema/ttrss_schema_pgsql.sql') diff --git a/schema/ttrss_schema_pgsql.sql b/schema/ttrss_schema_pgsql.sql index 0bd4caad7..b0cd36d8e 100644 --- a/schema/ttrss_schema_pgsql.sql +++ b/schema/ttrss_schema_pgsql.sql @@ -146,7 +146,8 @@ create table ttrss_filters (id serial not null primary key, filter_type integer not null references ttrss_filter_types(id), reg_exp varchar(250) not null, enabled boolean not null default true, - action_id integer not null default 1 references ttrss_filter_actions(id) on delete cascade); + action_id integer not null default 1 references ttrss_filter_actions(id) on delete cascade, + action_param varchar(200) not null default ''); create table ttrss_labels (id serial not null primary key, owner_uid integer not null references ttrss_users(id) on delete cascade, @@ -170,7 +171,7 @@ create index ttrss_tags_owner_uid_index on ttrss_tags(owner_uid); create table ttrss_version (schema_version int not null); -insert into ttrss_version values (11); +insert into ttrss_version values (12); create table ttrss_prefs_types (id integer not null primary key, type_name varchar(100) not null); -- cgit v1.2.3