diff options
author | Andrew Dolgov <[email protected]> | 2006-07-25 08:36:34 +0100 |
---|---|---|
committer | Andrew Dolgov <[email protected]> | 2006-07-25 08:36:34 +0100 |
commit | 5cfc8713d2f78ba89ee0c320a04012add965771b (patch) | |
tree | 62e5ced7e25102a26059daedc22db95264dae609 /schema/obsolete | |
parent | 831ff047dde75862c01d8e4ebfe8b9f20bcb6925 (diff) |
move old schema upgrade files
Diffstat (limited to 'schema/obsolete')
-rw-r--r-- | schema/obsolete/upgrade-1.1.5-1.1.7-mysql.sql | 14 | ||||
-rw-r--r-- | schema/obsolete/upgrade-1.1.5-1.1.7-pgsql.sql | 17 |
2 files changed, 31 insertions, 0 deletions
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; |