clean obsolete options from schema (bump schema version)

1 files changed, 15 insertions, 0 deletions

diff --git a/schema/versions/mysql/78.sql b/schema/versions/mysql/78.sql
new file mode 100644
index 000000000..80e9e782a
--- /dev/null
+++ b/schema/versions/mysql/78.sql
@@ -0,0 +1,15 @@
+begin;
+
+delete from ttrss_user_prefs where pref_name in ('HIDE_FEEDLIST', 'SYNC_COUNTERS', 'ENABLE_LABELS',
+	'ENABLE_SEARCH_TOOLBAR', 'ENABLE_FEED_ICONS', 
+	'ENABLE_OFFLINE_READING', 'EXTENDED_FEEDLIST', 'OPEN_LINKS_IN_NEW_WINDOW', 
+	'USER_STYLESHEET_URL', 'ENABLE_FLASH_PLAYER');
+
+delete from ttrss_prefs where pref_name in ('HIDE_FEEDLIST', 'SYNC_COUNTERS', 'ENABLE_LABELS',
+	'ENABLE_SEARCH_TOOLBAR', 'ENABLE_FEED_ICONS', 
+	'ENABLE_OFFLINE_READING', 'EXTENDED_FEEDLIST', 'OPEN_LINKS_IN_NEW_WINDOW', 
+	'USER_STYLESHEET_URL', 'ENABLE_FLASH_PLAYER');
+
+update ttrss_version set schema_version = 78;
+
+commit;