diff options
author | Andrew Dolgov <[email protected]> | 2012-08-30 13:06:58 +0400 |
---|---|---|
committer | Andrew Dolgov <[email protected]> | 2012-08-30 13:10:28 +0400 |
commit | f9ebb32ca0a84ec5553d0494cdfc628753fcb36a (patch) | |
tree | a6b1125795ef4fdbd3e399f182bc0bc2f2379166 /schema/versions/pgsql/95.sql | |
parent | 2a3d00bbf5d5b47fec3a4e4e39cabe3a19108fe2 (diff) |
hide more obscure preferences under "show more" checkbox in pref-prefs,
bump schema
Diffstat (limited to 'schema/versions/pgsql/95.sql')
-rw-r--r-- | schema/versions/pgsql/95.sql | 39 |
1 files changed, 39 insertions, 0 deletions
diff --git a/schema/versions/pgsql/95.sql b/schema/versions/pgsql/95.sql new file mode 100644 index 000000000..014463a85 --- /dev/null +++ b/schema/versions/pgsql/95.sql @@ -0,0 +1,39 @@ +begin; + +update ttrss_prefs set short_desc = 'Purge articles after this number of days (0 - disables)' +where pref_name = 'PURGE_OLD_DAYS'; + +update ttrss_prefs set section_id = 1 where pref_name = 'ENABLE_API_ACCESS'; + +update ttrss_prefs set section_id = 2 where pref_name = 'CONFIRM_FEED_CATCHUP'; +update ttrss_prefs set section_id = 2 where pref_name = 'CDM_EXPANDED'; +update ttrss_prefs set section_id = 2 where pref_name = 'CDM_AUTO_CATCHUP'; +update ttrss_prefs set section_id = 2 where pref_name = 'SORT_HEADLINES_BY_FEED_DATE'; +update ttrss_prefs set section_id = 2 where pref_name = 'HIDE_READ_SHOWS_SPECIAL'; + +insert into ttrss_prefs_sections (id, section_name) values (4, 'Digest'); + +update ttrss_prefs set section_id = 4 where pref_name = 'DIGEST_ENABLE'; +update ttrss_prefs set section_id = 4 where pref_name = 'DIGEST_PREFERRED_TIME'; +update ttrss_prefs set section_id = 4 where pref_name = 'DIGEST_CATCHUP'; + +alter table ttrss_prefs_sections add column order_id integer; +update ttrss_prefs_sections set order_id = 0; +alter table ttrss_prefs_sections alter column order_id set not null; + +update ttrss_prefs_sections set order_id = 0 where id = 1; +update ttrss_prefs_sections set order_id = 1 where id = 2; +update ttrss_prefs_sections set order_id = 2 where id = 4; +update ttrss_prefs_sections set order_id = 3 where id = 3; + +update ttrss_prefs set access_level = 1 where pref_name in ('ON_CATCHUP_SHOW_NEXT_FEED', + 'SORT_HEADLINES_BY_FEED_DATE', + 'VFEED_GROUP_BY_FEED', + 'FRESH_ARTICLE_MAX_AGE', + 'CDM_EXPANDED', + 'SHOW_CONTENT_PREVIEW', + 'HIDE_READ_SHOWS_SPECIAL'); + +update ttrss_version set schema_version = 95; + +commit; |