schema/upgrade-1.1.1-1.1.2-mysql.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 bool;
   7
   8 update ttrss_feeds set private = false;
   9
  10 alter table ttrss_feeds change private private bool not null;
  11 alter table ttrss_feeds alter column private set default 0;
  12
  13 update ttrss_version set schema_version = 4;
  14
  15 commit;