schema/versions/mysql/95.sql

   1 begin;
   2
   3 update ttrss_prefs set short_desc = 'Purge articles after this number of days (0 - disables)'
   4 where pref_name = 'PURGE_OLD_DAYS';
   5
   6 update ttrss_prefs set section_id = 1 where pref_name = 'ENABLE_API_ACCESS';
   7
   8 update ttrss_prefs set section_id = 2 where pref_name = 'CONFIRM_FEED_CATCHUP';
   9 update ttrss_prefs set section_id = 2 where pref_name = 'CDM_EXPANDED';
  10 update ttrss_prefs set section_id = 2 where pref_name = 'CDM_AUTO_CATCHUP';
  11 update ttrss_prefs set section_id = 2 where pref_name = 'SORT_HEADLINES_BY_FEED_DATE';
  12 update ttrss_prefs set section_id = 2 where pref_name = 'HIDE_READ_SHOWS_SPECIAL';
  13
  14 insert into ttrss_prefs_sections (id, section_name) values (4, 'Digest');
  15
  16 update ttrss_prefs set section_id = 4 where pref_name = 'DIGEST_ENABLE';
  17 update ttrss_prefs set section_id = 4 where pref_name = 'DIGEST_PREFERRED_TIME';
  18 update ttrss_prefs set section_id = 4 where pref_name = 'DIGEST_CATCHUP';
  19
  20 alter table ttrss_prefs_sections add column order_id integer;
  21 update ttrss_prefs_sections set order_id = 0;
  22 alter table ttrss_prefs_sections change order_id order_id int not null;
  23
  24 update ttrss_prefs_sections set order_id = 0 where id = 1;
  25 update ttrss_prefs_sections set order_id = 1 where id = 2;
  26 update ttrss_prefs_sections set order_id = 2 where id = 4;
  27 update ttrss_prefs_sections set order_id = 3 where id = 3;
  28
  29 update ttrss_prefs set access_level = 1 where pref_name in ('ON_CATCHUP_SHOW_NEXT_FEED',
  30         'SORT_HEADLINES_BY_FEED_DATE',
  31         'VFEED_GROUP_BY_FEED',
  32         'FRESH_ARTICLE_MAX_AGE',
  33         'CDM_EXPANDED',
  34         'SHOW_CONTENT_PREVIEW',
  35         'HIDE_READ_SHOWS_SPECIAL');
  36
  37 update ttrss_version set schema_version = 95;
  38
  39 commit;