schema/versions/mysql/107.sql

   1 begin;
   2
   3 alter table ttrss_filters2 add column inverse bool;
   4 update ttrss_filters2 set inverse = false;
   5 alter table ttrss_filters2 change inverse inverse bool not null;
   6 alter table ttrss_filters2 alter column inverse set default false;
   7
   8 alter table ttrss_filters2_rules add column inverse bool;
   9 update ttrss_filters2_rules set inverse = false;
  10 alter table ttrss_filters2_rules change inverse inverse bool not null;
  11 alter table ttrss_filters2_rules alter column inverse set default false;
  12
  13 update ttrss_version set schema_version = 107;
  14
  15 commit;