From 34981c30a78e8bbd7791131059a9210f9928b62c Mon Sep 17 00:00:00 2001
From: 刘光辉 <347230014@qq.com>
Date: 星期四, 17 九月 2026 09:24:09 +0800
Subject: [PATCH] Merge remote-tracking branch 'origin/master' into master
---
docker/postgres/migration/product-baseline-cleanup-flow.sql | 56 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 56 insertions(+), 0 deletions(-)
diff --git a/docker/postgres/migration/product-baseline-cleanup-flow.sql b/docker/postgres/migration/product-baseline-cleanup-flow.sql
new file mode 100644
index 0000000..a900676
--- /dev/null
+++ b/docker/postgres/migration/product-baseline-cleanup-flow.sql
@@ -0,0 +1,56 @@
+-- 浜у搧姣嶇増娲楁暟鎹� 路 娴佺▼寮曟搸搴撲晶锛坉ocs/adr-multi-customer-db-isolation.md 搂6.2锛�
+--
+-- 鍙湪姣嶇増瀹炰緥 cx-pg-template 鐨� jnpf_flow 涓婅窇銆傚箓绛夊彲閲嶆斁銆�
+-- 鐢ㄦ硶锛歞ocker exec -i cx-pg-template psql -U postgres -d jnpf_flow -v ON_ERROR_STOP=1 < 鏈枃浠�
+--
+-- 涓� product-baseline-cleanup.sql锛坖npf_init 渚э級銆愬繀椤绘垚濂楁墽琛屻�戯細
+-- workflow_template.f_flowable_id 寮曠敤 act_re_deployment.id_锛屽彧娲椾竴杈圭瓑浜庝汉涓哄埗閫�
+-- ADR 搂4 鐨勫崐鍒囨晠闅滐紙2026-08-03 灏卞洜姝よ娴嬭瘯鐜 44/49 娴佺▼鎶ャ�屾壘涓嶅埌娴佺▼妯℃澘銆嶏級銆�
+--
+-- 淇濈暀銆愭祦绋嬪畾涔夈�戯紝娓呯┖銆愯繍琛屾椂 + 鍘嗗彶 + 韬唤銆戙�傚悓鏍风敤鐧藉悕鍗曪細
+-- 婕忔竻 鈫� 瀹㈡埛1 鐨勬祦绋嬪疄渚嬫暟鎹祦鍒版柊瀹㈡埛锛涜娓� 鈫� 瀹氫箟娌′簡锛岃瀹屽氨鍙戠幇銆傞闄╀笉瀵圭О銆�
+--
+-- 鈿狅笍 涓ょ被琛ㄧ粷瀵逛笉鑳芥竻锛屾竻浜嗗紩鎿庝細宕╂垨閲嶈窇杩佺Щ锛�
+-- 路 *_databasechangelog / *_databasechangeloglock 鈥斺�� Liquibase 鐨� schema 鐗堟湰璐︽湰
+-- 路 act_ge_property 鈥斺�� 寮曟搸 schema 鐗堟湰
+-- 鈿狅笍 act_ge_bytearray 鍚屾椂瀛樸�愰儴缃茶祫婧愩�戜笌銆愯繍琛屾椂鍙橀噺 blob銆戯紝鏁磋〃娓呬細姣佹帀娴佺▼瀹氫箟銆�
+-- 2026-08-04 瀹炴煡瀹㈡埛1 搴擄細276 琛屻�愬叏閮ㄣ�戞湁 deployment_id_锛岃繍琛屾椂 blob 涓� 0 琛岋紝
+-- 鏁呮暣琛ㄤ繚鐣欎笉浼氬甫鍏ヤ笟鍔℃暟鎹�備粛淇濈暀涓嬫柟鎸� deployment_id_ IS NULL 鐨勫垹闄や綔涓洪�氬垯锛�
+-- 灏嗘潵鑻ュ嚭鐜拌繍琛屾椂 blob 浼氳鑷姩娓呮帀銆�
+-- 鈿狅笍 璺戝墠宸插疄鏌ワ細娌℃湁浠讳綍 keep 琛ㄧ殑 FK 鎸囧悜灏嗚娓呯┖鐨勮〃锛屾晠 TRUNCATE ... CASCADE 涓嶄細娉㈠強瀹氫箟銆�
+
+BEGIN;
+
+DO $$
+DECLARE
+ keep text[] := ARRAY[
+ -- 鈶� BPMN 娴佺▼瀹氫箟锛堟牳蹇冿細涓� jnpf_init.workflow_template.f_flowable_id 閰嶅鐨勫氨鏄畠锛�
+ 'act_re_deployment','act_re_procdef','act_re_model','act_procdef_info',
+ -- 鈶� 瀹氫箟璧勬簮涓庡紩鎿庣増鏈紙娓呬簡寮曟搸璧蜂笉鏉ワ級
+ 'act_ge_bytearray','act_ge_property',
+ -- 鈶� DMN / CMMN / App / Event 鐨勩�愬畾涔夈�戦儴鍒嗭紙瀵瑰簲鐨� hi_/ru_ 鍦ㄤ笅闈㈣娓咃級
+ 'act_dmn_decision','act_dmn_deployment','act_dmn_deployment_resource',
+ 'act_cmmn_casedef','act_cmmn_deployment','act_cmmn_deployment_resource',
+ 'act_app_appdef','act_app_deployment','act_app_deployment_resource',
+ 'flw_channel_definition','flw_event_definition','flw_event_deployment','flw_event_resource',
+ -- 鈶� Liquibase schema 鐗堟湰璐︽湰锛堟竻浜嗕細閲嶈窇杩佺Щ锛�
+ 'act_app_databasechangelog','act_app_databasechangeloglock',
+ 'act_cmmn_databasechangelog','act_cmmn_databasechangeloglock',
+ 'act_dmn_databasechangelog','act_dmn_databasechangeloglock',
+ 'flw_ev_databasechangelog','flw_ev_databasechangeloglock'
+ ];
+ t text;
+BEGIN
+ FOR t IN
+ SELECT tablename FROM pg_tables
+ WHERE schemaname = 'public' AND NOT (tablename = ANY(keep))
+ LOOP
+ EXECUTE format('TRUNCATE TABLE %I CASCADE', t);
+ END LOOP;
+END $$;
+
+-- act_ge_bytearray 鐨勭簿纭竻鐞嗭細鍙垹杩愯鏃跺彉閲� blob锛屼繚鐣欓儴缃茶祫婧愩��
+-- 閫氬垯褰㈠紡鑰岄潪鎸夊叿浣� id鈥斺�斿皢鏉ュ嚭鐜拌繍琛屾椂 blob 浼氳鑷姩娓呮帀銆�
+DELETE FROM act_ge_bytearray WHERE deployment_id_ IS NULL;
+
+COMMIT;
--
Gitblit v1.8.0