From 5cfc8713d2f78ba89ee0c320a04012add965771b Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Tue, 25 Jul 2006 08:36:34 +0100 Subject: move old schema upgrade files --- schema/obsolete/upgrade-1.1.5-1.1.7-mysql.sql | 14 ++++++++++++++ schema/obsolete/upgrade-1.1.5-1.1.7-pgsql.sql | 17 +++++++++++++++++ 2 files changed, 31 insertions(+) create mode 100644 schema/obsolete/upgrade-1.1.5-1.1.7-mysql.sql create mode 100644 schema/obsolete/upgrade-1.1.5-1.1.7-pgsql.sql (limited to 'schema/obsolete') diff --git a/schema/obsolete/upgrade-1.1.5-1.1.7-mysql.sql b/schema/obsolete/upgrade-1.1.5-1.1.7-mysql.sql new file mode 100644 index 000000000..39100450b --- /dev/null +++ b/schema/obsolete/upgrade-1.1.5-1.1.7-mysql.sql @@ -0,0 +1,14 @@ +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_prefs (pref_name,type_id,def_value,short_desc,section_id) values('FEEDS_SORT_BY_UNREAD', 1, 'false', 'Sort feeds by unread articles count',2); + +insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id) values('EXTENDED_FEEDLIST', 1, 'false', 'Show additional information in feedlist',2); + +insert into ttrss_filter_actions (id,name,description) values (3, 'mark', + 'Set starred'); + +update ttrss_version set schema_version = 8; + diff --git a/schema/obsolete/upgrade-1.1.5-1.1.7-pgsql.sql b/schema/obsolete/upgrade-1.1.5-1.1.7-pgsql.sql new file mode 100644 index 000000000..ab7a7df33 --- /dev/null +++ b/schema/obsolete/upgrade-1.1.5-1.1.7-pgsql.sql @@ -0,0 +1,17 @@ +begin; + +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_prefs (pref_name,type_id,def_value,short_desc,section_id) values('FEEDS_SORT_BY_UNREAD', 1, 'false', 'Sort feeds by unread articles count',2); + +insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id) values('EXTENDED_FEEDLIST', 1, 'false', 'Show additional information in feedlist',2); + +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