<commit_before>-- remove old indexes 
-- this may be app specific 

-- catissue 
alter table QUERY_PARAMETERIZED_QUERY drop foreign key FKA272176BBC7298A9, drop index FKA272176BBC7298A9;
alter table QUERY_INTRA_MODEL_ASSOCIATION drop foreign key FKF1EDBDD3BC7298A9, drop index FKF1EDBDD3BC7298A9;
alter table QUERY_CONSTRAINTS drop foreign key FKE364FCFFD3C625EA, drop index FKE364FCFFD3C625EA;
alter table QUERY_PARAMETERIZED_CONDITION drop foreign key <KEY>, drop index FK9BE75A3EBC7298A9;
alter table QUERY_CONDITION drop foreign key FKACCE6246104CA7, drop index FKACCE6246104CA7;
alter table QUERY_RULE drop foreign key FK<KEY>, drop index FK14A6503365F8F4CB;
alter table QUERY_RULE drop foreign key <KEY>, drop index FK14A65033BC7298A9;
alter table QUERY drop foreign key FK<KEY>, drop index FK49D20A8251EDC5B;
alter table QUERY_LOGICAL_CONNECTOR drop foreign key FK<KEY>, drop index FKCF30478065F8F4CB;
alter table QUERY_EXPRESSION drop foreign key FK1B473A8FCA571190, drop index FK1B473A8FCA571190;
alter table QUERY_EXPRESSION drop foreign key FK1B473A8F9E19EF66, drop index FK1B473A8F9E19EF66;
alter table QUERY_EXPRESSION drop foreign key FK1B473A8F1CF7F689, drop index FK1B473A8F1CF7F689;
alter table QUERY_CONDITION_VALUES drop foreign key FK9997379DDA532516, drop index FK9997379DDA532516;
alter table QUERY_OUTPUT_ATTRIBUTE drop foreign key FK22C9DB75BF5EEB27, drop index FK22C9DB75BF5EEB27;
alter table QUERY_OUTPUT_ATTRIBUTE drop foreign key FK22C9DB75C4E818F8, drop index FK22C9DB75C4E818F8;
alter table QUERY_INTER_MODEL_ASSOCIATION drop foreign key FKD70658D1BC7298A9, drop index FKD70658D1BC7298A9;
alter table QUERY_EXPRESSION_OPERAND drop foreign key FKA3B976F965F8F4CB, drop index FKA3B976F965F8F4CB;
alter table QUERY_GRAPH_ENTRY drop foreign key FKF055E4EA955C60E6, drop index FKF055E4EA955C60E6;
alter table QUERY_GRAPH_ENTRY drop foreign key FKF055E4EAD3C625EA, drop index FKF055E4EAD3C625EA;
alter table QUERY_GRAPH_ENTRY drop foreign key F<KEY>, drop index FKF055E4EA7A5E6479;
alter table QUERY_GRAPH_ENTRY drop foreign key FKF055E4EAEE560703, drop index FKF055E4EAEE560703;
alter table QUERY_EXPRESSIONID drop foreign key FK6662DBEABC7298A9, drop index FK6662DBEABC7298A9;

-- rename of columns 
alter table query_condition_values change value_list VALUE varchar(255);
alter table query_condition_values change query_condition_id CONDITION_ID bigint;
alter table query change query_constraints_id CONSTRAINTS_ID bigint;<commit_msg>set storage engine as innodb<commit_after>-- remove old indexes 
-- this may be app specific 

-- catissue 
SET storage_engine=InnoDB

alter table QUERY_PARAMETERIZED_QUERY drop foreign key FKA<KEY>, drop index FKA272176BBC7298A9;
alter table QUERY_INTRA_MODEL_ASSOCIATION drop foreign key FKF1EDBDD3BC7298A9, drop index FKF1EDBDD3BC7298A9;
alter table QUERY_CONSTRAINTS drop foreign key FKE364FCFFD3C625EA, drop index FKE364FCFFD3C625EA;
alter table QUERY_PARAMETERIZED_CONDITION drop foreign key FK9BE75A3EBC7298A9, drop index FK9BE75A3EBC7298A9;
alter table QUERY_CONDITION drop foreign key FKACCE6246104CA7, drop index FKACCE6246104CA7;
alter table QUERY_RULE drop foreign key FK<KEY>, drop index FK14A6503365F8F4CB;
alter table QUERY_RULE drop foreign key FK14A65033BC7298A9, drop index FK14A65033BC7298A9;
alter table QUERY drop foreign key FK<KEY>, drop index FK49D20A8251EDC5B;
alter table QUERY_LOGICAL_CONNECTOR drop foreign key <KEY>, drop index FKCF30478065F8F4CB;
alter table QUERY_EXPRESSION drop foreign key FK1B473A8FCA571190, drop index FK1B473A8FCA571190;
alter table QUERY_EXPRESSION drop foreign key FK1B473A8F9E19EF66, drop index FK1B473A8F9E19EF66;
alter table QUERY_EXPRESSION drop foreign key FK1B473A8F1CF7F689, drop index FK1B473A8F1CF7F689;
alter table QUERY_CONDITION_VALUES drop foreign key FK9997379DDA532516, drop index FK9997379DDA532516;
alter table QUERY_OUTPUT_ATTRIBUTE drop foreign key FK22C9DB<KEY>, drop index FK22C9DB75BF5EEB27;
alter table QUERY_OUTPUT_ATTRIBUTE drop foreign key <KEY>, drop index FK22C9DB75C4E818F8;
alter table QUERY_INTER_MODEL_ASSOCIATION drop foreign key FKD70658D1BC7298A9, drop index FKD70658D1BC7298A9;
alter table QUERY_EXPRESSION_OPERAND drop foreign key F<KEY>, drop index FKA3B976F965F8F4CB;
alter table QUERY_GRAPH_ENTRY drop foreign key FKF055E4EA955C60E6, drop index FKF055E4EA955C60E6;
alter table QUERY_GRAPH_ENTRY drop foreign key FKF055E4EAD3C625EA, drop index FKF055E4EAD3C625EA;
alter table QUERY_GRAPH_ENTRY drop foreign key F<KEY>, drop index FKF055E4EA7A5E6479;
alter table QUERY_GRAPH_ENTRY drop foreign key FKF055E4EAEE560703, drop index FKF055E4EAEE560703;
alter table QUERY_EXPRESSIONID drop foreign key FK6662DBEABC7298A9, drop index FK6662DBEABC7298A9;

-- rename of columns 
alter table query_condition_values change value_list VALUE varchar(255);
alter table query_condition_values change query_condition_id CONDITION_ID bigint;
alter table query change query_constraints_id CONSTRAINTS_ID bigint;
{'fraction_non_alphanumeric': 0.03011317704122878, 'fraction_numerical': 0.14591754244139046, 'mean_word_length': 8.031021897810218, 'pattern_counts': {'":': 0, '<': 17, '<?xml version=': 0, '>': 17, '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': '4223564', 'n_tokens_mistral': 2273, 'n_tokens_neox': 1807, 'n_words': 513}