summaryrefslogtreecommitdiff
path: root/sql/pgsql/migrations/107.sql
blob: a4a537c2f7cb21cccfb43cdd5b8e0be86b40abb1 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
begin;

alter table ttrss_filters2 add column inverse boolean;
update ttrss_filters2 set inverse = false;
alter table ttrss_filters2 alter column inverse set not null;
alter table ttrss_filters2 alter column inverse set default false;

alter table ttrss_filters2_rules add column inverse boolean;
update ttrss_filters2_rules set inverse = false;
alter table ttrss_filters2_rules alter column inverse set not null;
alter table ttrss_filters2_rules alter column inverse set default false;

update ttrss_version set schema_version = 107;

commit;