| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146 |
- -- ============================================================================
- -- 清空「数据测试」案件(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;
|