[tt-rss.git] / schema / versions / pgsql / 19.sql

insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id) values('_PREFS_PUBLISH_KEY', 2, '', '', 1);

alter table ttrss_user_entries add column published boolean;
update ttrss_user_entries set published = false;
alter table ttrss_user_entries alter column published set not null;
alter table ttrss_user_entries alter column published set default false;

update ttrss_version set schema_version = 19;
Commit	Line	Data
c59d33a3 AD	1	insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id) values('_PREFS_PUBLISH_KEY', 2, '', '', 1);
c59d33a3 AD	2
ffba8297 AD	3	alter table ttrss_user_entries add column published boolean;
	4	update ttrss_user_entries set published = false;
	5	alter table ttrss_user_entries alter column published set not null;
	6	alter table ttrss_user_entries alter column published set default false;
	7
c59d33a3	8	update ttrss_version set schema_version = 19;