<commit_before>begin;

alter table ttrss_filters add column cat_filter bool;
update ttrss_filters set cat_filter = true;
alter table ttrss_filters change cat_filter cat_filter bool 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 FOREIGN KEY (cat_id) REFERENCES ttrss_feed_categories(id) ON DELETE CASCADE;

update ttrss_version set schema_version = 87;

commit;
<commit_msg>fix schema 87 script for mysql<commit_after>begin;

alter table ttrss_filters add column cat_filter bool;
update ttrss_filters set cat_filter = false;
alter table ttrss_filters change cat_filter cat_filter bool 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 FOREIGN KEY (cat_id) REFERENCES ttrss_feed_categories(id) ON DELETE CASCADE;

update ttrss_version set schema_version = 87;

commit;

{'fraction_non_alphanumeric': 0.036072144288577156, 'fraction_numerical': 0.006012024048096192, 'mean_word_length': 6.568181818181818, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '6691648', 'n_tokens_mistral': 318, 'n_tokens_neox': 309, 'n_words': 117}