summaryrefslogtreecommitdiff
path: root/schema
diff options
context:
space:
mode:
authorAndrew Dolgov <[email protected]>2006-05-18 02:20:43 +0100
committerAndrew Dolgov <[email protected]>2006-05-18 02:20:43 +0100
commitdd7d31871e2349edd9a488922eba8f2abfbc3dce (patch)
tree931d5d80f16328da426510d23948c00f76e1fbf3 /schema
parentadba6b8509635496615045bf0bae5998fc0eb412 (diff)
new filter action: set starred, rename add filter button
Diffstat (limited to 'schema')
-rw-r--r--schema/ttrss_schema_mysql.sql3
-rw-r--r--schema/ttrss_schema_pgsql.sql3
-rw-r--r--schema/upgrade-1.1.5-1.1.7-mysql.sql3
-rw-r--r--schema/upgrade-1.1.5-1.1.7-pgsql.sql3
4 files changed, 12 insertions, 0 deletions
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;