[tt-rss.git] / schema / upgrade-1.2.3-1.2.4-pgsql.sql

begin;

delete FROM ttrss_user_prefs WHERE pref_name = 'DISPLAY_HEADER';
delete FROM ttrss_user_prefs WHERE pref_name = 'DISPLAY_FOOTER';
delete FROM ttrss_user_prefs WHERE pref_name = 'ENABLE_SEARCH_TOOLBAR';
delete FROM ttrss_user_prefs WHERE pref_name = 'USE_COMPACT_STYLESHEET';

delete FROM ttrss_prefs WHERE pref_name = 'DISPLAY_HEADER';
delete FROM ttrss_prefs WHERE pref_name = 'DISPLAY_FOOTER';
delete FROM ttrss_prefs WHERE pref_name = 'ENABLE_SEARCH_TOOLBAR';
delete FROM ttrss_prefs WHERE pref_name = 'USE_COMPACT_STYLESHEET';

insert into ttrss_themes (theme_name, theme_path) values ('Graycube', 'graycube');
insert into ttrss_themes (theme_name, theme_path) values ('Default (Compact)', 'compact');

update ttrss_version set schema_version = 11;

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