From 30b6ee8c08a5c5d0201be95864706ab529298a70 Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Mon, 29 Nov 2010 13:02:44 +0300 Subject: clean obsolete options from schema (bump schema version) --- schema/versions/mysql/78.sql | 15 +++++++++++++++ schema/versions/pgsql/78.sql | 15 +++++++++++++++ 2 files changed, 30 insertions(+) create mode 100644 schema/versions/mysql/78.sql create mode 100644 schema/versions/pgsql/78.sql (limited to 'schema/versions') 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; diff --git a/schema/versions/pgsql/78.sql b/schema/versions/pgsql/78.sql new file mode 100644 index 000000000..80e9e782a --- /dev/null +++ b/schema/versions/pgsql/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; -- cgit v1.2.3