schema/upgrade-1.2.3-1.2.4-pgsql.sql

   1 begin;
   2
   3 delete FROM ttrss_user_prefs WHERE pref_name = 'DISPLAY_HEADER';
   4 delete FROM ttrss_user_prefs WHERE pref_name = 'DISPLAY_FOOTER';
   5 delete FROM ttrss_user_prefs WHERE pref_name = 'ENABLE_SEARCH_TOOLBAR';
   6
   7 delete FROM ttrss_prefs WHERE pref_name = 'DISPLAY_HEADER';
   8 delete FROM ttrss_prefs WHERE pref_name = 'DISPLAY_FOOTER';
   9 delete FROM ttrss_prefs WHERE pref_name = 'ENABLE_SEARCH_TOOLBAR';
  10
  11 insert into ttrss_themes (theme_name, theme_path)
  12         values ('Graycube', 'graycube');
  13
  14 update ttrss_version set schema_version = 11;
  15
  16 commit;