From fdd8e50ac73394a4d402a1ffae8ddcd6e25e8146 Mon Sep 17 00:00:00 2001
From: shicf <shi_chongfu@163.com>
Date: 星期三, 13 八月 2025 16:13:46 +0800
Subject: [PATCH] 解决创建表时有联合主键问题，多个字段用``括起来，成为一个字段，报Key column 'CO_ITEM_CODE,CO_ITEM_FACTORY' doesn't exist in table错误
---
product-server-data-center/src/main/java/com/product/data/center/service/JournalManagerService.java | 11 +++++++++++
1 files changed, 11 insertions(+), 0 deletions(-)
diff --git a/product-server-data-center/src/main/java/com/product/data/center/service/JournalManagerService.java b/product-server-data-center/src/main/java/com/product/data/center/service/JournalManagerService.java
index 5d8e677..3ded758 100644
--- a/product-server-data-center/src/main/java/com/product/data/center/service/JournalManagerService.java
+++ b/product-server-data-center/src/main/java/com/product/data/center/service/JournalManagerService.java
@@ -43,6 +43,17 @@
@Resource
MesExternalService mesExternalService;
+
+ public void timingClearDataCenterLog(){
+// select uuid from product_sys_data_center_log a
+// where created_utc_datetime<=date(date_add(now(),interval -7 day)) and (result=1 or (deal_flag=1 and deal_result=1)) and type>1
+// union all
+// select a.uuid from product_sys_data_center_log a
+// join product_sys_data_center_log b on a.uuid=b.pre_step_uuid
+// where a.type=1 and b.type=2 and (b.result=1 or (b.deal_flag=1 and b.deal_result=1))
+// and b.created_utc_datetime<=date(date_add(now(),interval -7 day))
+ }
+
/**
* 鏃ュ織鍒楄〃
*
--
Gitblit v1.9.2