107.sql 544 B

123456789101112131415
  1. begin;
  2. alter table ttrss_filters2 add column inverse boolean;
  3. update ttrss_filters2 set inverse = false;
  4. alter table ttrss_filters2 alter column inverse set not null;
  5. alter table ttrss_filters2 alter column inverse set default false;
  6. alter table ttrss_filters2_rules add column inverse boolean;
  7. update ttrss_filters2_rules set inverse = false;
  8. alter table ttrss_filters2_rules alter column inverse set not null;
  9. alter table ttrss_filters2_rules alter column inverse set default false;
  10. update ttrss_version set schema_version = 107;
  11. commit;