summaryrefslogtreecommitdiff
path: root/schema/versions/pgsql/19.sql
blob: 79e62846482a9cfed3155a47e0730d9184355ee7 (plain)
1
2
3
4
5
6
7
8
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;