From ac544c1d85c53e7f51e4ea76aa2489a14aef03d9 Mon Sep 17 00:00:00 2001
From: zjh <1084500556@qq.com>
Date: 星期五, 20 六月 2025 18:57:45 +0800
Subject: [PATCH] zjh20250620
---
ltkj-admin/src/main/resources/sql/陕健医.sql | 33 +++++++++++++++++++++++++++++++++
1 files changed, 33 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..762ea92 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,36 @@
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;
+
+
--
Gitblit v1.8.0