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 delete FROM ttrss_user_prefs WHERE pref_name = 'USE_COMPACT_STYLESHEET';
   7
   8 delete FROM ttrss_prefs WHERE pref_name = 'DISPLAY_HEADER';
   9 delete FROM ttrss_prefs WHERE pref_name = 'DISPLAY_FOOTER';
  10 delete FROM ttrss_prefs WHERE pref_name = 'ENABLE_SEARCH_TOOLBAR';
  11 delete FROM ttrss_prefs WHERE pref_name = 'USE_COMPACT_STYLESHEET';
  12
  13 insert into ttrss_themes (theme_name, theme_path) values ('Graycube', 'graycube');
  14 insert into ttrss_themes (theme_name, theme_path) values ('Default (Compact)', 'compact');
  15
  16 update ttrss_version set schema_version = 11;
  17
  18 commit;