]>
Commit | Line | Data |
---|---|---|
ba975b2e AD |
1 | begin; |
2 | ||
3 | alter table ttrss_filters add column cat_filter bool; | |
5ee7470d | 4 | update ttrss_filters set cat_filter = false; |
ba975b2e AD |
5 | alter table ttrss_filters change cat_filter cat_filter bool not null; |
6 | alter table ttrss_filters alter column cat_filter set default false; | |
7 | ||
8 | alter table ttrss_filters add column cat_id integer; | |
9 | ||
10 | alter table ttrss_filters add FOREIGN KEY (cat_id) REFERENCES ttrss_feed_categories(id) ON DELETE CASCADE; | |
11 | ||
12 | update ttrss_version set schema_version = 87; | |
13 | ||
14 | commit; |