<commit_before>-- delete ALL data from database
-- (leave Yii migration table as-is)
--
-- > mysql -uroot -p --show-warnings --verbose --force < ./clear_tables.sql
--
-- MUST match current migration schema
--

SET FOREIGN_KEY_CHECKS=0;

TRUNCATE TABLE `tbl_activity`;
TRUNCATE TABLE `tbl_currency`;
TRUNCATE TABLE `tbl_customer`;
TRUNCATE TABLE `tbl_file`;
TRUNCATE TABLE `tbl_issue`;
TRUNCATE TABLE `tbl_manufacturer`;
TRUNCATE TABLE `tbl_order`;
TRUNCATE TABLE `tbl_order_item`;
TRUNCATE TABLE `tbl_order_item_stock_assignment`;
TRUNCATE TABLE `tbl_part`;
TRUNCATE TABLE `tbl_part_cost`;
TRUNCATE TABLE `tbl_part_list`;
TRUNCATE TABLE `tbl_part_type`;
TRUNCATE TABLE `tbl_person`;
TRUNCATE TABLE `tbl_project`;
TRUNCATE TABLE `tbl_project_person_assignment`;
TRUNCATE TABLE `tbl_stock`;
TRUNCATE TABLE `tbl_stock_location`;
TRUNCATE TABLE `tbl_supplier`;
TRUNCATE TABLE `tbl_supplier_manufacturing_assignment`;<commit_msg>script refactoring<commit_after>-- delete ALL data from database
-- (leave Yii migration table as-is)
--
-- > mysql -uroot -p --show-warnings --verbose --force < ./clear_tables.sql
--
-- MUST match current migration schema
--

SET FOREIGN_KEY_CHECKS=0;

TRUNCATE TABLE `tbl_activity`;
TRUNCATE TABLE `tbl_currency`;
TRUNCATE TABLE `tbl_customer`;
TRUNCATE TABLE `tbl_file`;
TRUNCATE TABLE `tbl_issue`;
TRUNCATE TABLE `tbl_manufacturer`;
TRUNCATE TABLE `tbl_order`;
TRUNCATE TABLE `tbl_order_item`;
TRUNCATE TABLE `tbl_order_item_stock_assignment`;
TRUNCATE TABLE `tbl_part`;
TRUNCATE TABLE `tbl_part_cost`;
TRUNCATE TABLE `tbl_part_list`;
TRUNCATE TABLE `tbl_part_type`;
TRUNCATE TABLE `tbl_person`;
TRUNCATE TABLE `tbl_project`;
TRUNCATE TABLE `tbl_project_person_assignment`;
TRUNCATE TABLE `tbl_stock`;
TRUNCATE TABLE `tbl_stock_location`;
TRUNCATE TABLE `tbl_supplier`;
TRUNCATE TABLE `tbl_supplier_manufacturer_assignment`;
{'fraction_non_alphanumeric': 0.10367170626349892, 'fraction_numerical': 0.0010799136069114472, 'mean_word_length': 6.594262295081967, 'pattern_counts': {'":': 0, '<': 5, '<?xml version=': 0, '>': 5, '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': '3387947', 'n_tokens_mistral': 710, 'n_tokens_neox': 662, 'n_words': 170}