schema/obsolete/upgrade-1.1.4-1.1.5-pgsql.sql

   1 begin;
   2
   3 alter table ttrss_feeds add column rtl_content boolean;
   4
   5 update ttrss_feeds set rtl_content = false;
   6
   7 alter table ttrss_feeds alter column rtl_content set not null;
   8 alter table ttrss_feeds alter column rtl_content set default false;
   9
  10 alter table ttrss_sessions drop column ip_address;
  11
  12 delete from ttrss_user_prefs where pref_name = 'DISPLAY_FEEDLIST_ACTIONS';
  13 delete from ttrss_prefs where pref_name = 'DISPLAY_FEEDLIST_ACTIONS';
  14
  15 delete from ttrss_user_prefs where pref_name = 'ENABLE_PREFS_CATCHUP_UNCATCHUP';
  16 delete from ttrss_prefs where pref_name = 'ENABLE_PREFS_CATCHUP_UNCATCHUP';
  17
  18 alter table ttrss_filters drop column description;
  19
  20 update ttrss_version set schema_version = 7;
  21
  22 commit;