schema/upgrade-1.1.1-1.1.2-pgsql.sql

   1 begin;
   2
   3 alter table ttrss_feeds add column parent_feed integer;
   4 alter table ttrss_feeds add foreign key (parent_feed) references ttrss_feeds(id) on delete set null;
   5
   6 alter table ttrss_feeds add column private boolean;
   7
   8 update ttrss_feeds set private = false;
   9
  10 alter table ttrss_feeds alter column private set not null;
  11 alter table ttrss_feeds alter column private set default false;
  12
  13 insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id) values('HIDE_READ_FEEDS', 1, 'false', 'Hide feeds with no unread messages',2);
  14
  15 update ttrss_version set schema_version = 4;
  16
  17 commit;