add new-style schema versions and updater

1 files changed, 14 insertions, 0 deletions

diff --git a/schema/versions/mysql/8.sql b/schema/versions/mysql/8.sql
new file mode 100644
index 000000000..39100450b
--- /dev/null
+++ b/schema/versions/mysql/8.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;
+