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.sql | 66 +++++++++++++++++++++++++++++++++
1 files changed, 66 insertions(+), 0 deletions(-)
diff --git a/docker/postgres/migration/product-baseline-cleanup.sql b/docker/postgres/migration/product-baseline-cleanup.sql
new file mode 100644
index 0000000..5e3e533
--- /dev/null
+++ b/docker/postgres/migration/product-baseline-cleanup.sql
@@ -0,0 +1,66 @@
+-- 浜у搧姣嶇増娲楁暟鎹紙docs/adr-multi-customer-db-isolation.md 搂6.2锛�
+--
+-- 鍙湪姣嶇増瀹炰緥 cx-pg-template 鐨� jnpf_init 涓婅窇銆傚箓绛夊彲閲嶆斁銆�
+-- 鐢ㄦ硶锛歞ocker exec -i cx-pg-template psql -U postgres -d jnpf_init -v ON_ERROR_STOP=1 < 鏈枃浠�
+--
+-- 鈺愨晲鈺� 涓轰粈涔堟槸鐧藉悕鍗曪紙鏋氫妇淇濈暀锛夛紝涓嶆槸榛戝悕鍗曪紙鏋氫妇娓呯┖锛夆晲鈺愨晲
+-- 涓や釜鏂瑰悜鐨勯敊璇悗鏋滀笉瀵圭О锛�
+-- 婕忔竻涓�寮犱笟鍔¤〃 鈫� 瀹㈡埛1 鐨勬暟鎹祦鍒版柊瀹㈡埛锛屽彲鑳藉緢涔呮墠琚彂鐜帮紱
+-- 璇竻涓�寮犻厤缃〃 鈫� 鏂板鎴峰皯涓�浠介厤缃紝瑁呭畬灏卞彂鐜般��
+-- 鎵�浠ユ灇涓俱�屼繚鐣欎粈涔堛�嶏紝鍏朵綑涓�寰嬫竻绌恒�傛柊澧炰笟鍔¤〃涓嶇敤鏀规湰鏂囦欢锛堥粯璁よ娓咃級锛�
+-- 鏂板銆愰厤缃被銆戣〃鎵嶉渶瑕佸姞杩� keep[]銆�
+--
+-- 鈺愨晲鈺� 淇濈暀/娓呯┖鐨勪骇鍝佸喅绛栵紙鐢ㄦ埛 2026-08-04 鎷嶆澘锛夆晲鈺愨晲
+-- 路 LIMS 鍩虹妗ｆ锛堟楠岄」鐩�/璇烽獙绫诲瀷/鍗曚綅/璐ㄩ噺鏍囧噯/鍌ㄥ瓨鏉′欢锛夆啋 涓嶅垎鍙戯紝娓呯┖銆�
+-- 鐞嗙敱锛氬鎴�1 鐨勬。妗堝甫缁欏鎴�2 澶ф鐜囨槸閿欑殑锛岃�屼笖閿欏緱涓嶆槑鏄撅紱鏂板鎴锋寜鍏跺疄闄呮爣鍑嗗綍鍏ャ��
+-- 路 JNPF 鑷甫 demo 鏁版嵁锛坋xt_* 10 寮� / wform_* 6 寮狅級鈫� 娓呯┖銆傚钩鍙扮ず渚嬶紝闈炰骇鍝佽祫浜с��
+-- 路 缁勭粐鏋舵瀯涓庤鑹叉巿鏉冿紙base_organize/base_position/base_role/base_authorize锛夆啋 鍏ㄦ竻銆�
+-- 鏂板鎴风粍缁囩粨鏋勫繀鐒朵笉鍚岋紱admin 鏄秴绠★紝涓嶄緷璧� role 涔熻兘鐧诲綍骞堕厤鏉冮檺銆�
+--
+-- 鈿狅笍 鏈枃浠跺繀椤讳笌 jnpf_flow 渚х殑娓呯悊銆愭垚濂楁墽琛屻�戯細
+-- workflow_template.f_flowable_id 寮曠敤 act_re_deployment.id_锛屽彧娲椾竴杈�
+-- 绛変簬浜轰负鍒堕�� ADR 搂4 鐨勫崐鍒囨晠闅溿�傞厤濂楄剼鏈 product-baseline-cleanup-flow.sql銆�
+-- 鈿狅笍 璺戜箣鍓嶇‘璁ゆ病鏈� FK 鐨� parent 钀藉湪 keep[] 涓婏紙TRUNCATE ... CASCADE 浼氳繛甯︽竻绌猴級銆�
+-- 2026-08-04 瀹炴煡锛氬叏搴撲粎 4 鏉� FK锛屽叏鍦� lims_* 鍐呴儴涓斾负 RESTRICT锛屼笉娉㈠強 keep[]銆�
+
+BEGIN;
+
+DO $$
+DECLARE
+ keep text[] := ARRAY[
+ -- 鈶� 浣庝唬鐮佽〃鍗� / 娴佺▼ / 澶у睆 / 鎶ヨ〃銆愬畾涔夈�戔�斺�斾骇鍝佽祫浜ф牳蹇�
+ 'base_visual_dev','base_visual_release','base_visual_filter','base_visual_kit',
+ 'base_visual_link','base_visual_personal',
+ 'blade_visual','blade_visual_config','blade_visual_component','blade_visual_assets','blade_visual_map',
+ 'report_template','report_charts','report_version',
+ 'workflow_template','workflow_version','workflow_node','workflow_candidates','workflow_operator',
+ -- 鈶� 鑿滃崟 / 瀛楀吀 / 鏁版嵁鎺ュ彛 / 鎵撳嵃妯℃澘 / 闂ㄦ埛 / 绯荤粺閰嶇疆
+ 'base_module','base_module_button','base_module_data',
+ 'base_dictionary_type','base_dictionary_data',
+ 'base_data_interface','base_data_interface_oauth','base_data_set',
+ 'base_sys_config','base_system','base_system_top','base_common_fields','base_common_words',
+ 'base_bill_rule','base_code_num','base_print_template','base_print_version',
+ 'base_portal','base_portal_data','base_portal_manage','base_standing',
+ 'base_msg_template','base_msg_template_param','base_msg_send_template',
+ 'base_integrate','base_integrate_node','base_permission_group','base_action','base_sign_img',
+ -- 鈶� 骞冲彴鑷甫鍩虹鏁版嵁锛堜笌瀹㈡埛鏃犲叧鐨勫瓧鍏告�ф暟鎹級
+ 'base_province','base_province_atlas','base_language',
+ -- 鈶� 閮ㄥ垎淇濈暀锛氭暣琛ㄨ眮鍏� TRUNCATE锛屼笅闈㈢敤 DELETE 绮剧‘娓咃紙鍙暀 admin锛�
+ 'base_user','base_user_relation'
+ ];
+ 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 $$;
+
+-- 鈶� 鐨勭簿纭竻鐞嗭細鍙暀 admin 涓�涓处鍙峰強鍏跺叧鑱�
+DELETE FROM base_user_relation
+ WHERE f_user_id NOT IN (SELECT f_id FROM base_user WHERE f_account = 'admin');
+DELETE FROM base_user WHERE f_account <> 'admin';
+
+COMMIT;
--
Gitblit v1.8.0