File: 87.sql

package info (click to toggle)
tt-rss 21~git20210204.b4cbc79%2Bdfsg-1.2
  • links: PTS, VCS
  • area: main
  • in suites: bookworm
  • size: 12,428 kB
  • sloc: php: 29,355; javascript: 13,884; sql: 2,341; sh: 315; makefile: 81; perl: 9
file content (14 lines) | stat: -rw-r--r-- 477 bytes parent folder | download | duplicates (4) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
 
begin;

alter table ttrss_filters add column cat_filter boolean;
update ttrss_filters set cat_filter = false;
alter table ttrss_filters alter column cat_filter set not null;
alter table ttrss_filters alter column cat_filter set default false;

alter table ttrss_filters add column cat_id integer;

alter table ttrss_filters add constraint "$5" FOREIGN KEY (cat_id) REFERENCES ttrss_feed_categories(id) ON DELETE CASCADE;

update ttrss_version set schema_version = 87;

commit;