From dd7d31871e2349edd9a488922eba8f2abfbc3dce Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Thu, 18 May 2006 02:20:43 +0100 Subject: new filter action: set starred, rename add filter button --- schema/ttrss_schema_mysql.sql | 3 +++ schema/ttrss_schema_pgsql.sql | 3 +++ schema/upgrade-1.1.5-1.1.7-mysql.sql | 3 +++ schema/upgrade-1.1.5-1.1.7-pgsql.sql | 3 +++ 4 files changed, 12 insertions(+) (limited to 'schema') diff --git a/schema/ttrss_schema_mysql.sql b/schema/ttrss_schema_mysql.sql index d53eb60cd..e1d61009c 100644 --- a/schema/ttrss_schema_mysql.sql +++ b/schema/ttrss_schema_mysql.sql @@ -137,6 +137,9 @@ insert into ttrss_filter_actions (id,name,description) values (1, 'filter', insert into ttrss_filter_actions (id,name,description) values (2, 'catchup', 'Mark as read'); +insert into ttrss_filter_actions (id,name,description) values (3, 'mark', + 'Set starred'); + 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 b8c813c47..1726ecc8e 100644 --- a/schema/ttrss_schema_pgsql.sql +++ b/schema/ttrss_schema_pgsql.sql @@ -131,6 +131,9 @@ insert into ttrss_filter_actions (id,name,description) values (1, 'filter', insert into ttrss_filter_actions (id,name,description) values (2, 'catchup', 'Mark as read'); +insert into ttrss_filter_actions (id,name,description) values (3, 'mark', + 'Set starred'); + 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.1.5-1.1.7-mysql.sql b/schema/upgrade-1.1.5-1.1.7-mysql.sql index aa74eb343..bfccc3358 100644 --- a/schema/upgrade-1.1.5-1.1.7-mysql.sql +++ b/schema/upgrade-1.1.5-1.1.7-mysql.sql @@ -3,5 +3,8 @@ insert into ttrss_themes (theme_name, theme_path) values ('Old-skool', 'compat') insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id,help_text) values('ON_CATCHUP_SHOW_NEXT_FEED', 1, 'false', 'On catchup show next feed',2, 'When "Mark as read" button is clicked in toolbar, automatically open next feed with unread articles.'); +insert into ttrss_filter_actions (id,name,description) values (3, 'mark', + 'Set starred'); + update ttrss_version set schema_version = 8; diff --git a/schema/upgrade-1.1.5-1.1.7-pgsql.sql b/schema/upgrade-1.1.5-1.1.7-pgsql.sql index 88b1ecf35..4a2237a3f 100644 --- a/schema/upgrade-1.1.5-1.1.7-pgsql.sql +++ b/schema/upgrade-1.1.5-1.1.7-pgsql.sql @@ -5,6 +5,9 @@ insert into ttrss_themes (theme_name, theme_path) values ('Old-skool', 'compat') insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id,help_text) values('ON_CATCHUP_SHOW_NEXT_FEED', 1, 'false', 'On catchup show next feed',2, 'When "Mark as read" button is clicked in toolbar, automatically open next feed with unread articles.'); +insert into ttrss_filter_actions (id,name,description) values (3, 'mark', + 'Set starred'); + update ttrss_version set schema_version = 8; commit; -- cgit v1.2.3