From da7dd957342aa96b31f17e3d61792896e006d6e2 Mon Sep 17 00:00:00 2001
From: zjh <1084500556@qq.com>
Date: 星期一, 28 七月 2025 17:38:32 +0800
Subject: [PATCH] zjh20250728-1
---
ltkj-admin/src/main/resources/sql/陕健医.sql | 47 +++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 47 insertions(+), 0 deletions(-)
diff --git "a/ltkj-admin/src/main/resources/sql/\351\231\225\345\201\245\345\214\273.sql" "b/ltkj-admin/src/main/resources/sql/\351\231\225\345\201\245\345\214\273.sql"
index 181b431..92a606c 100644
--- "a/ltkj-admin/src/main/resources/sql/\351\231\225\345\201\245\345\214\273.sql"
+++ "b/ltkj-admin/src/main/resources/sql/\351\231\225\345\201\245\345\214\273.sql"
@@ -35,3 +35,50 @@
pdf_base64 text NULL COMMENT 'pdf鎶ュ憡鍗昩ase64涓�',
jpg_base64 text NULL COMMENT 'jpg鎶ュ憡鍗昩ase64涓�'
) COMMENT '澶栭�丳DF鍥炰紶';
+
+# 娓呭簱
+TRUNCATE TABLE tb_transition;
+TRUNCATE TABLE tj_order;
+TRUNCATE TABLE tj_order_ycxm;
+TRUNCATE TABLE tj_order_detail;
+TRUNCATE TABLE tj_order_remark;
+TRUNCATE TABLE tj_order_detail_rules;
+TRUNCATE TABLE ltkj_hysqd;
+TRUNCATE TABLE ltkj_hybgd;
+TRUNCATE TABLE ltkj_exam_jcsqd;
+TRUNCATE TABLE ltkj_exam_jcbgd;
+TRUNCATE TABLE tj_jcycxm;
+TRUNCATE TABLE tj_sampling;
+TRUNCATE TABLE tj_report;
+TRUNCATE TABLE tj_reservation;
+TRUNCATE TABLE tj_wsxm;
+TRUNCATE TABLE tj_zhxm;
+TRUNCATE TABLE tj_xd_picture;
+TRUNCATE TABLE tj_xdtgmdjg;
+TRUNCATE TABLE tj_report_print;
+TRUNCATE TABLE tj_flowing_water;
+TRUNCATE TABLE tj_flowing_water_his;
+TRUNCATE TABLE tj_dw_grouping;
+TRUNCATE TABLE tj_grouping_pro;
+TRUNCATE TABLE tj_customer;
+TRUNCATE TABLE tj_dw_dept;
+TRUNCATE TABLE tj_customer_black;
+TRUNCATE TABLE tj_ask_historys;
+TRUNCATE TABLE tj_ask_medical_history;
+TRUNCATE TABLE tj_ask_work_log;
+TRUNCATE TABLE dict_user_info;
+
+# 鏌ヨ鍓嶇紑鍊�
+SELECT * FROM (
+ SELECT config_value,'sqyy' as hosp FROM ltkjpeis10_sqyy.`sys_config` WHERE config_key = 'make_lis_tmh_prefix' union all
+ SELECT config_value,'bjfhyy' as hosp FROM ltkjpeis10_bjfhyy.`sys_config` WHERE config_key = 'make_lis_tmh_prefix' union all
+ SELECT config_value,'bjxjyy' as hosp FROM ltkjpeis10_bjxjyy.`sys_config` WHERE config_key = 'make_lis_tmh_prefix' union all
+ SELECT config_value,'chkwyy' as hosp FROM ltkjpeis10_chkwyy.`sys_config` WHERE config_key = 'make_lis_tmh_prefix' union all
+ SELECT config_value,'jdczgzyy' as hosp FROM ltkjpeis10_jdczgzyy.`sys_config` WHERE config_key = 'make_lis_tmh_prefix' union all
+ SELECT config_value,'pbkwyy' as hosp FROM ltkjpeis10_pbkwyy.`sys_config` WHERE config_key = 'make_lis_tmh_prefix' union all
+ SELECT config_value,'ssyjyy' as hosp FROM ltkjpeis10_ssyjyy.`sys_config` WHERE config_key = 'make_lis_tmh_prefix' union all
+ SELECT config_value,'wbzxyy' as hosp FROM ltkjpeis10_wbzxyy.`sys_config` WHERE config_key = 'make_lis_tmh_prefix' union all
+ SELECT config_value,'xamjyy' as hosp FROM ltkjpeis10_xamjyy.`sys_config` WHERE config_key = 'make_lis_tmh_prefix' union all
+ SELECT config_value,'xatlgcyy' as hosp FROM ltkjpeis10_xatlgcyy.`sys_config` WHERE config_key = 'make_lis_tmh_prefix'
+ ) a ORDER BY a.config_value DESC;
+
--
Gitblit v1.8.0