From 7cb9311ba13df7fec30fe498578089398785e48d Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Fri, 8 Dec 2006 07:34:59 +0100 Subject: [PATCH] ttrss_filters: add tag action --- schema/ttrss_schema_mysql.sql | 3 +++ schema/ttrss_schema_pgsql.sql | 3 +++ schema/upgrade-1.2.4-1.2.6-mysql.sql | 3 +++ schema/upgrade-1.2.4-1.2.6-pgsql.sql | 3 +++ 4 files changed, 12 insertions(+) diff --git a/schema/ttrss_schema_mysql.sql b/schema/ttrss_schema_mysql.sql index 384bd1e8..b6516282 100644 --- a/schema/ttrss_schema_mysql.sql +++ b/schema/ttrss_schema_mysql.sql @@ -146,6 +146,9 @@ insert into ttrss_filter_actions (id,name,description) values (2, 'catchup', insert into ttrss_filter_actions (id,name,description) values (3, 'mark', 'Set starred'); +insert into ttrss_filter_actions (id,name,description) values (4, 'tag', + 'Assign tag'); + create table ttrss_filters (id integer not null primary key auto_increment, owner_uid integer not null, feed_id integer default null, diff --git a/schema/ttrss_schema_pgsql.sql b/schema/ttrss_schema_pgsql.sql index b0cd36d8..5bec8723 100644 --- a/schema/ttrss_schema_pgsql.sql +++ b/schema/ttrss_schema_pgsql.sql @@ -140,6 +140,9 @@ insert into ttrss_filter_actions (id,name,description) values (2, 'catchup', insert into ttrss_filter_actions (id,name,description) values (3, 'mark', 'Set starred'); +insert into ttrss_filter_actions (id,name,description) values (4, 'tag', + 'Assign tag'); + create table ttrss_filters (id serial not null primary key, owner_uid integer not null references ttrss_users(id) on delete cascade, feed_id integer references ttrss_feeds(id) on delete cascade default null, diff --git a/schema/upgrade-1.2.4-1.2.6-mysql.sql b/schema/upgrade-1.2.4-1.2.6-mysql.sql index 2b100d17..10b571d7 100644 --- a/schema/upgrade-1.2.4-1.2.6-mysql.sql +++ b/schema/upgrade-1.2.4-1.2.6-mysql.sql @@ -5,5 +5,8 @@ update ttrss_filters set action_param = ''; alter table ttrss_filters change action_param action_param varchar(200) not null; alter table ttrss_filters alter column action_param set default ''; +insert into ttrss_filter_actions (id,name,description) values (4, 'tag', + 'Assign tag'); + update ttrss_version set schema_version = 12; diff --git a/schema/upgrade-1.2.4-1.2.6-pgsql.sql b/schema/upgrade-1.2.4-1.2.6-pgsql.sql index 07ded63c..71b4634d 100644 --- a/schema/upgrade-1.2.4-1.2.6-pgsql.sql +++ b/schema/upgrade-1.2.4-1.2.6-pgsql.sql @@ -7,6 +7,9 @@ update ttrss_filters set action_param = ''; alter table ttrss_filters alter column action_param set not null; alter table ttrss_filters alter column action_param set default ''; +insert into ttrss_filter_actions (id,name,description) values (4, 'tag', + 'Assign tag'); + update ttrss_version set schema_version = 12; commit; -- 2.39.5