-- ============================================================================ -- 清空「数据测试」案件(case_info.id = 9)的电子数据业务数据 -- 目标库:案件 DuckDB -- E:\workspace\zsjz-ai\QingJian\workspace\9\ylzkBGZJ9 -- 执行时机:停止后端 / 退出案件后执行(DuckDB 单文件单写锁) -- 保留固定数据:eds_tree(旧名 eds_dir_tree,目录树,71 行)、eds_dict(字典,2873 行) -- 清空:EDS 附属业务表 + 全部 wa_mforensics_* 检材数据表 -- ============================================================================ BEGIN TRANSACTION; -- ---------------------------- 附属业务表 ---------------------------- -- 检材登记(治理树 EDS 节点由本表动态生成) DELETE FROM eds_material; -- 数据包上传 / 解析进度 DELETE FROM eds_material_process; -- 媒体文件索引(磁盘上的媒体文件不在此脚本删除范围内) DELETE FROM eds_media_file; -- 目录树节点数据量统计 DELETE FROM eds_tree_count; -- ------------------------ 检材数据表(108 张) ------------------------ DELETE FROM wa_mforensics_010100; DELETE FROM wa_mforensics_010200; DELETE FROM wa_mforensics_010201; DELETE FROM wa_mforensics_010202; DELETE FROM wa_mforensics_010300; DELETE FROM wa_mforensics_010400; DELETE FROM wa_mforensics_010500; DELETE FROM wa_mforensics_010600; DELETE FROM wa_mforensics_010700; DELETE FROM wa_mforensics_010800; DELETE FROM wa_mforensics_010900; DELETE FROM wa_mforensics_011000; DELETE FROM wa_mforensics_011100; DELETE FROM wa_mforensics_011200; DELETE FROM wa_mforensics_020100; DELETE FROM wa_mforensics_020200; DELETE FROM wa_mforensics_020300; DELETE FROM wa_mforensics_020400; DELETE FROM wa_mforensics_020500; DELETE FROM wa_mforensics_020600; DELETE FROM wa_mforensics_020700; DELETE FROM wa_mforensics_020800; DELETE FROM wa_mforensics_030100; DELETE FROM wa_mforensics_030200; DELETE FROM wa_mforensics_030300; DELETE FROM wa_mforensics_030400; DELETE FROM wa_mforensics_030500; DELETE FROM wa_mforensics_040100; DELETE FROM wa_mforensics_040200; DELETE FROM wa_mforensics_040300; DELETE FROM wa_mforensics_040400; DELETE FROM wa_mforensics_040500; DELETE FROM wa_mforensics_050100; DELETE FROM wa_mforensics_050200; DELETE FROM wa_mforensics_050300; DELETE FROM wa_mforensics_050400; DELETE FROM wa_mforensics_050500; DELETE FROM wa_mforensics_050600; DELETE FROM wa_mforensics_050700; DELETE FROM wa_mforensics_060100; DELETE FROM wa_mforensics_060200; DELETE FROM wa_mforensics_060300; DELETE FROM wa_mforensics_060400; DELETE FROM wa_mforensics_060500; DELETE FROM wa_mforensics_060600; DELETE FROM wa_mforensics_060700; DELETE FROM wa_mforensics_060800; DELETE FROM wa_mforensics_070100; DELETE FROM wa_mforensics_070200; DELETE FROM wa_mforensics_070300; DELETE FROM wa_mforensics_070400; DELETE FROM wa_mforensics_070500; DELETE FROM wa_mforensics_070600; DELETE FROM wa_mforensics_070700; DELETE FROM wa_mforensics_070800; DELETE FROM wa_mforensics_080100; DELETE FROM wa_mforensics_080200; DELETE FROM wa_mforensics_080300; DELETE FROM wa_mforensics_080400; DELETE FROM wa_mforensics_080500; DELETE FROM wa_mforensics_080600; DELETE FROM wa_mforensics_080700; DELETE FROM wa_mforensics_090100; DELETE FROM wa_mforensics_090200; DELETE FROM wa_mforensics_090300; DELETE FROM wa_mforensics_090400; DELETE FROM wa_mforensics_090500; DELETE FROM wa_mforensics_090600; DELETE FROM wa_mforensics_110100; DELETE FROM wa_mforensics_110200; DELETE FROM wa_mforensics_110300; DELETE FROM wa_mforensics_110400; DELETE FROM wa_mforensics_120100; DELETE FROM wa_mforensics_120200; DELETE FROM wa_mforensics_130100; DELETE FROM wa_mforensics_130200; DELETE FROM wa_mforensics_140100; DELETE FROM wa_mforensics_140200; DELETE FROM wa_mforensics_140300; DELETE FROM wa_mforensics_140400; DELETE FROM wa_mforensics_150100; DELETE FROM wa_mforensics_160100; DELETE FROM wa_mforensics_160200; DELETE FROM wa_mforensics_160300; DELETE FROM wa_mforensics_160400; DELETE FROM wa_mforensics_160500; DELETE FROM wa_mforensics_170100; DELETE FROM wa_mforensics_170200; DELETE FROM wa_mforensics_170300; DELETE FROM wa_mforensics_170400; DELETE FROM wa_mforensics_170500; DELETE FROM wa_mforensics_170600; DELETE FROM wa_mforensics_170700; DELETE FROM wa_mforensics_170800; DELETE FROM wa_mforensics_170900; DELETE FROM wa_mforensics_171000; DELETE FROM wa_mforensics_171100; DELETE FROM wa_mforensics_171200; DELETE FROM wa_mforensics_171300; DELETE FROM wa_mforensics_180100; DELETE FROM wa_mforensics_180200; DELETE FROM wa_mforensics_180300; DELETE FROM wa_mforensics_180400; DELETE FROM wa_mforensics_ext_616; DELETE FROM wa_mforensics_ext_621; DELETE FROM wa_mforensics_ext_625; DELETE FROM wa_mforensics_ext_625_1; DELETE FROM wa_mforensics_ext_627; -- 可选:同步清理「导入文件列表」中的电子数据包记录(本案件当前无此类记录) -- DELETE FROM file_info WHERE fileType = 'eds'; COMMIT; -- 把删除结果刷入主库文件,便于随后直接备份 / 拷贝 CHECKPOINT; -- 校验:eds_tree=71、eds_dict=2873,其余 4 张附属业务表应为 0 SELECT 'eds_tree' AS table_name, count(*) AS row_count FROM eds_tree UNION ALL SELECT 'eds_dict', count(*) FROM eds_dict UNION ALL SELECT 'eds_material', count(*) FROM eds_material UNION ALL SELECT 'eds_material_process', count(*) FROM eds_material_process UNION ALL SELECT 'eds_media_file', count(*) FROM eds_media_file UNION ALL SELECT 'eds_tree_count', count(*) FROM eds_tree_count;