schema/versions/pgsql/87.sql

   1 begin;
   2
   3 alter table ttrss_filters add column cat_filter boolean;
   4 update ttrss_filters set cat_filter = false;
   5 alter table ttrss_filters alter column cat_filter set 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 constraint "$5" FOREIGN KEY (cat_id) REFERENCES ttrss_feed_categories(id) ON DELETE CASCADE;
  11
  12 update ttrss_version set schema_version = 87;
  13
  14 commit;