From b9cddce2ae8593383df2401ca44b52ec59d9c12d Mon Sep 17 00:00:00 2001
From: 云 <2163098428@qq.com>
Date: 星期一, 14 九月 2026 17:03:30 +0800
Subject: [PATCH] fix(config): 修复滑动验证码底图路径配置及数据库连接参数调整
---
sql/mysql/sp_clean_business_data.sql | 435 ++++++++++++++++++++++++++++++++++++++++++++++++++++++
yudao-server/src/main/resources/application-thzy.yaml | 13
yudao-server/src/main/resources/application.yaml | 6
3 files changed, 446 insertions(+), 8 deletions(-)
diff --git a/sql/mysql/sp_clean_business_data.sql b/sql/mysql/sp_clean_business_data.sql
new file mode 100644
index 0000000..7fe5cc2
--- /dev/null
+++ b/sql/mysql/sp_clean_business_data.sql
@@ -0,0 +1,435 @@
+-- ============================================================
+-- 涓氬姟鏁版嵁娓呯悊瀛樺偍杩囩▼锛堢洰鏍囧簱锛歮om-thzy锛�
+--
+-- 鐢ㄩ�旓細娓呯┖鍚勪笟鍔℃ā鍧楃殑娴佹按/浜嬪姟鏁版嵁锛屼繚鐣欑敤鎴枫�佽鑹层�佽彍鍗曘��
+-- 瀛楀吀銆佹祦绋嬪畾涔夈�佸熀纭�閰嶇疆涓庝富鏁版嵁妗ｆ銆�
+--
+-- 娉ㄦ剰锛�
+-- 1. TRUNCATE 涓� DDL 闅愬紡鎻愪氦锛屾棤娉曞洖婊氾紝鎵ц鍓嶈鍏堝浠姐��
+-- 2. 鎵ц鏂瑰紡锛歮ysql -uroot -p mom-thzy < sp_clean_business_data.sql
+-- 鎴栧湪瀹㈡埛绔腑鏁翠綋鎵ц鏈剼鏈紙鍚� DELIMITER锛夈��
+-- 3. 鎵ц娓呯悊锛欳ALL sp_clean_business_data();
+-- ============================================================
+
+DROP PROCEDURE IF EXISTS `sp_clean_business_data`;
+
+DELIMITER $$
+
+CREATE DEFINER=`root`@`%` PROCEDURE `sp_clean_business_data`()
+BEGIN
+ SET FOREIGN_KEY_CHECKS = 0;
+
+ -- ============================================================
+ -- 1. 绯荤粺杩愯鏁版嵁锛堟棩蹇� / Token / 楠岃瘉鐮� / 绔欏唴淇� / 绀句氦缁戝畾锛�
+ -- ============================================================
+ TRUNCATE TABLE system_login_log;
+ TRUNCATE TABLE system_operate_log;
+ TRUNCATE TABLE system_notify_message;
+ TRUNCATE TABLE system_oauth2_access_token;
+ TRUNCATE TABLE system_oauth2_refresh_token;
+ TRUNCATE TABLE system_oauth2_code;
+ TRUNCATE TABLE system_oauth2_approve;
+ TRUNCATE TABLE system_sms_code;
+ TRUNCATE TABLE system_sms_log;
+ TRUNCATE TABLE system_mail_log;
+ TRUNCATE TABLE system_social_user;
+ TRUNCATE TABLE system_social_user_bind;
+ TRUNCATE TABLE infra_api_access_log;
+ TRUNCATE TABLE infra_api_error_log;
+ TRUNCATE TABLE infra_job_log;
+
+ -- 鍒犻櫎涓庢湰椤圭洰鏃犲叧鐨勬鏋惰嚜甯﹀畾鏃朵换鍔★紙pay/mall/iot/demo锛夛紝
+ -- 淇濈暀鏃ュ織娓呯悊涓変欢濂楋細accessLogCleanJob / errorLogCleanJob / jobLogCleanJob
+ DELETE FROM infra_job
+ WHERE handler_name IN (
+ 'payNotifyJob', 'payOrderSyncJob', 'payOrderExpireJob',
+ 'payRefundSyncJob', 'payTransferSyncJob',
+ 'tradeOrderAutoCancelJob', 'tradeOrderAutoReceiveJob', 'tradeOrderAutoCommentJob',
+ 'brokerageRecordUnfreezeJob', 'combinationRecordExpireJob',
+ 'couponExpireJob', 'productStatisticsJob',
+ 'iotDeviceOfflineCheckJob', 'iotOtaUpgradeJob',
+ 'demoJob'
+ );
+
+ -- Quartz 璋冨害杩愯鏃舵暟鎹紙qrtz_locks 淇濈暀閿佽锛屾竻绌轰細瀵艰嚧璋冨害鍣ㄥ姞閿佹姤閿欙級
+ -- 娓呯悊鍚庡闇�鎭㈠淇濈暀浠诲姟鐨勮皟搴︽敞鍐岋紝鍦ㄣ�愬熀纭�璁炬柦-瀹氭椂浠诲姟銆戦〉闈㈢偣"鍚屾"鎴栬皟鐢�
+ -- POST /admin-api/infra/job/sync 浠� infra_job 閲嶅缓瑙﹀彂鍣�
+ TRUNCATE TABLE qrtz_blob_triggers;
+ TRUNCATE TABLE qrtz_calendars;
+ TRUNCATE TABLE qrtz_cron_triggers;
+ TRUNCATE TABLE qrtz_fired_triggers;
+ TRUNCATE TABLE qrtz_job_details;
+ TRUNCATE TABLE qrtz_paused_trigger_grps;
+ TRUNCATE TABLE qrtz_scheduler_state;
+ TRUNCATE TABLE qrtz_simple_triggers;
+ TRUNCATE TABLE qrtz_simprop_triggers;
+ TRUNCATE TABLE qrtz_triggers;
+
+ -- ============================================================
+ -- 2. 鏂囦欢涓庨檮浠�
+ -- ============================================================
+ TRUNCATE TABLE system_storage_attachment;
+ TRUNCATE TABLE system_storage_blob;
+ TRUNCATE TABLE storage_attachment;
+ TRUNCATE TABLE storage_blob;
+ TRUNCATE TABLE infra_file;
+ TRUNCATE TABLE infra_file_content;
+
+ -- ============================================================
+ -- 3. BPM 娴佺▼瀹炰緥涓庡鎵瑰巻鍙�
+ -- 淇濈暀锛氭祦绋嬪畾涔�/琛ㄥ崟/鍒嗙被/琛ㄨ揪寮�/鐩戝惉鍣�/鐢ㄦ埛缁�/涓氬姟闄勪欢閰嶇疆
+ -- 淇濈暀锛歛ct_re_* / act_ge_* / act_id_* / act_procdef_info锛堝畾涔変笌閮ㄧ讲璧勬簮锛�
+ -- ============================================================
+ TRUNCATE TABLE bpm_oa_leave;
+ TRUNCATE TABLE bpm_process_instance_copy;
+ TRUNCATE TABLE act_hi_procinst;
+ TRUNCATE TABLE act_hi_taskinst;
+ TRUNCATE TABLE act_hi_actinst;
+ TRUNCATE TABLE act_hi_varinst;
+ TRUNCATE TABLE act_hi_identitylink;
+ TRUNCATE TABLE act_hi_comment;
+ TRUNCATE TABLE act_hi_detail;
+ TRUNCATE TABLE act_hi_attachment;
+ TRUNCATE TABLE act_hi_entitylink;
+ TRUNCATE TABLE act_hi_tsk_log;
+ TRUNCATE TABLE act_ru_task;
+ TRUNCATE TABLE act_ru_execution;
+ TRUNCATE TABLE act_ru_actinst;
+ TRUNCATE TABLE act_ru_variable;
+ TRUNCATE TABLE act_ru_identitylink;
+ TRUNCATE TABLE act_ru_job;
+ TRUNCATE TABLE act_ru_timer_job;
+ TRUNCATE TABLE act_ru_deadletter_job;
+ TRUNCATE TABLE act_ru_suspended_job;
+ TRUNCATE TABLE act_ru_external_job;
+ TRUNCATE TABLE act_ru_history_job;
+ TRUNCATE TABLE act_ru_event_subscr;
+ TRUNCATE TABLE act_ru_entitylink;
+ TRUNCATE TABLE act_evt_log;
+ -- Flowable 鎵规杩愯鏃讹紙multi-instance 鎵瑰鐞嗭紝鍘熻剼鏈仐婕忥級
+ TRUNCATE TABLE flw_ru_batch;
+ TRUNCATE TABLE flw_ru_batch_part;
+
+ -- ============================================================
+ -- 4. MES 鐢熶骇妯″潡 鈥� 涓氬姟鏁版嵁
+ -- 淇濈暀锛歮es_pro_process / mes_pro_route*锛堝伐鑹轰笌璺嚎瀹氫箟锛�
+ -- ============================================================
+ TRUNCATE TABLE mes_pro_work_order_param_record_detail;
+ TRUNCATE TABLE mes_pro_work_order_param_record;
+ TRUNCATE TABLE mes_pro_work_order_process;
+ TRUNCATE TABLE mes_pro_work_order_bom;
+ TRUNCATE TABLE mes_pro_work_order;
+ TRUNCATE TABLE mes_pro_task_issue;
+ TRUNCATE TABLE mes_pro_task;
+ TRUNCATE TABLE mes_pro_task_pause_record; -- 鐢熶骇浠诲姟鍋滃伐璁板綍锛堝師鑴氭湰閬楁紡锛�
+ TRUNCATE TABLE mes_pro_feedback;
+ TRUNCATE TABLE mes_pro_mps_merge_item;
+ TRUNCATE TABLE mes_pro_mps;
+ TRUNCATE TABLE mes_pro_card_process;
+ TRUNCATE TABLE mes_pro_card;
+ TRUNCATE TABLE mes_pro_work_record_log;
+ TRUNCATE TABLE mes_pro_work_record;
+ TRUNCATE TABLE mes_pro_andon_record;
+ TRUNCATE TABLE mes_pro_scan_event; -- 琚嬬爜鎵爜鍏ュ簱浜嬩欢锛堝師鑴氭湰閬楁紡锛�
+
+ -- ============================================================
+ -- 5. MES 浠撳偍妯″潡 鈥� 涓氬姟鏁版嵁
+ -- 淇濈暀锛歮es_wm_warehouse / _area / _location / _barcode_config锛堜粨鍌ㄩ厤缃級
+ -- ============================================================
+ TRUNCATE TABLE mes_wm_transaction;
+ TRUNCATE TABLE mes_wm_stock_reserve;
+ TRUNCATE TABLE mes_wm_material_stock;
+ TRUNCATE TABLE mes_wm_material_stock_bag; -- 搴撳瓨琚嬬爜鏄庣粏锛堝師鑴氭湰閬楁紡锛�
+ TRUNCATE TABLE mes_wm_stock_warning; -- 搴撳瓨棰勮璁板綍锛堝師鑴氭湰閬楁紡锛�
+ TRUNCATE TABLE mes_wm_sn;
+ TRUNCATE TABLE mes_wm_batch;
+ TRUNCATE TABLE mes_wm_barcode;
+ TRUNCATE TABLE mes_wm_stock_taking_task_result;
+ TRUNCATE TABLE mes_wm_stock_taking_task_line;
+ TRUNCATE TABLE mes_wm_stock_taking_task;
+ TRUNCATE TABLE mes_wm_stock_taking_plan_param;
+ TRUNCATE TABLE mes_wm_stock_taking_plan;
+ TRUNCATE TABLE mes_wm_package_line;
+ TRUNCATE TABLE mes_wm_package;
+ TRUNCATE TABLE mes_wm_item_receipt_detail;
+ TRUNCATE TABLE mes_wm_item_receipt_line;
+ TRUNCATE TABLE mes_wm_item_receipt;
+ TRUNCATE TABLE mes_wm_item_consume_detail;
+ TRUNCATE TABLE mes_wm_item_consume_line;
+ TRUNCATE TABLE mes_wm_item_consume;
+ TRUNCATE TABLE mes_wm_product_produce_detail;
+ TRUNCATE TABLE mes_wm_product_produce_line;
+ TRUNCATE TABLE mes_wm_product_produce;
+ TRUNCATE TABLE mes_wm_product_issue_detail;
+ TRUNCATE TABLE mes_wm_product_issue_line;
+ TRUNCATE TABLE mes_wm_product_issue;
+ TRUNCATE TABLE mes_wm_product_receipt_detail;
+ TRUNCATE TABLE mes_wm_product_receipt_line;
+ TRUNCATE TABLE mes_wm_product_receipt;
+ TRUNCATE TABLE mes_wm_product_sales_detail;
+ TRUNCATE TABLE mes_wm_product_sales_line;
+ TRUNCATE TABLE mes_wm_product_sales;
+ TRUNCATE TABLE mes_wm_misc_receipt_detail;
+ TRUNCATE TABLE mes_wm_misc_receipt_line;
+ TRUNCATE TABLE mes_wm_misc_receipt;
+ TRUNCATE TABLE mes_wm_misc_issue_detail;
+ TRUNCATE TABLE mes_wm_misc_issue_line;
+ TRUNCATE TABLE mes_wm_misc_issue;
+ TRUNCATE TABLE mes_wm_outsource_receipt_detail;
+ TRUNCATE TABLE mes_wm_outsource_receipt_line;
+ TRUNCATE TABLE mes_wm_outsource_receipt;
+ TRUNCATE TABLE mes_wm_outsource_issue_detail;
+ TRUNCATE TABLE mes_wm_outsource_issue_line;
+ TRUNCATE TABLE mes_wm_outsource_issue;
+ TRUNCATE TABLE mes_wm_return_vendor_detail;
+ TRUNCATE TABLE mes_wm_return_vendor_line;
+ TRUNCATE TABLE mes_wm_return_vendor;
+ TRUNCATE TABLE mes_wm_return_issue_detail;
+ TRUNCATE TABLE mes_wm_return_issue_line;
+ TRUNCATE TABLE mes_wm_return_issue;
+ TRUNCATE TABLE mes_wm_return_sales_detail;
+ TRUNCATE TABLE mes_wm_return_sales_line;
+ TRUNCATE TABLE mes_wm_return_sales;
+ TRUNCATE TABLE mes_wm_sales_notice_line;
+ TRUNCATE TABLE mes_wm_sales_notice;
+ TRUNCATE TABLE mes_wm_transfer_detail;
+ TRUNCATE TABLE mes_wm_transfer_line;
+ TRUNCATE TABLE mes_wm_transfer;
+ TRUNCATE TABLE mes_wm_arrival_notice_line;
+ TRUNCATE TABLE mes_wm_arrival_notice;
+
+ -- ============================================================
+ -- 6. MES 璐ㄦ妯″潡 鈥� 涓氬姟鏁版嵁
+ -- 淇濈暀锛歮es_qc_template(_indicator/_item) / _indicator / _defect锛堣川妫�閰嶇疆涓庡瓧鍏革級
+ -- ============================================================
+ TRUNCATE TABLE mes_qc_indicator_result_detail;
+ TRUNCATE TABLE mes_qc_indicator_result;
+ TRUNCATE TABLE mes_qc_defect_record;
+ TRUNCATE TABLE mes_qc_ncr;
+ TRUNCATE TABLE mes_qc_iqc_line;
+ TRUNCATE TABLE mes_qc_iqc;
+ TRUNCATE TABLE mes_qc_ipqc_line;
+ TRUNCATE TABLE mes_qc_ipqc;
+ TRUNCATE TABLE mes_qc_oqc_line;
+ TRUNCATE TABLE mes_qc_oqc;
+ TRUNCATE TABLE mes_qc_rqc_line;
+ TRUNCATE TABLE mes_qc_rqc;
+ -- 绉嶅瓙璐ㄦ璁板綍锛堝師鑴氭湰閬楁紡锛�
+ TRUNCATE TABLE mes_qc_seed_quality_indicator;
+ TRUNCATE TABLE mes_qc_seed_quality_source;
+ TRUNCATE TABLE mes_qc_seed_quality;
+
+ -- ============================================================
+ -- 7. MES 杩芥函妯″潡 鈥� 浜嬩欢涓庨璀﹁褰曪紙鍘熻剼鏈仐婕忥級
+ -- 淇濈暀锛歮es_trace_anti_config锛堥槻浼獪閰嶇疆锛�
+ -- ============================================================
+ TRUNCATE TABLE mes_trace_consumer_scan_event;
+ TRUNCATE TABLE mes_trace_cross_region_warning;
+ TRUNCATE TABLE mes_trace_integrity_record;
+ TRUNCATE TABLE mes_trace_event;
+
+ -- ============================================================
+ -- 8. MES 璁惧妯″潡 鈥� 鐐规/淇濆吇/缁翠慨/璁￠噺妫�娴嬭褰�
+ -- 淇濈暀锛歮es_dv_machinery(_type) / _check_plan* / _subject / _metering锛堝彴璐︿笌璁″垝锛�
+ -- ============================================================
+ TRUNCATE TABLE mes_dv_check_record_line;
+ TRUNCATE TABLE mes_dv_check_record;
+ TRUNCATE TABLE mes_dv_mainten_record_line;
+ TRUNCATE TABLE mes_dv_mainten_record;
+ TRUNCATE TABLE mes_dv_repair_line;
+ TRUNCATE TABLE mes_dv_repair;
+ TRUNCATE TABLE mes_dv_metering_check;
+
+ -- ============================================================
+ -- 9. MES 宸ヨ壓/璁捐妯″潡 鈥� 涓氬姟鏁版嵁锛堢紪鐮佺敓鎴愯褰曚负娴佹按鏁版嵁锛�
+ -- 淇濈暀锛歮es_pd_process_param(_template/_detail)锛堝伐鑹哄弬鏁板畾涔夛級
+ -- / mes_md_auto_code_rule / _part锛堢紪鐮佽鍒欙級
+ -- ============================================================
+ TRUNCATE TABLE mes_pd_archive;
+ TRUNCATE TABLE mes_pd_document_audit;
+ TRUNCATE TABLE mes_pd_document;
+ TRUNCATE TABLE mes_pd_project;
+ TRUNCATE TABLE mes_md_auto_code_record;
+
+ -- ============================================================
+ -- 10. CRM 妯″潡 鈥� 涓氬姟鏁版嵁
+ -- 淇濈暀锛歝rm_customer / crm_contact / crm_business_status(_type)
+ -- / crm_contract_config / crm_customer_limit_config / crm_customer_pool_config
+ -- ============================================================
+ TRUNCATE TABLE crm_receivable_plan;
+ TRUNCATE TABLE crm_receivable;
+ TRUNCATE TABLE crm_contract_product;
+ TRUNCATE TABLE crm_contract;
+ TRUNCATE TABLE crm_sale_quotation_product;
+ TRUNCATE TABLE crm_sale_quotation;
+ TRUNCATE TABLE crm_business_product;
+ TRUNCATE TABLE crm_contact_business;
+ TRUNCATE TABLE crm_business;
+ TRUNCATE TABLE crm_clue;
+ TRUNCATE TABLE crm_follow_up_record;
+ TRUNCATE TABLE crm_invoice;
+ TRUNCATE TABLE crm_sales_target;
+ TRUNCATE TABLE crm_permission;
+
+ -- ============================================================
+ -- 11. 鍞悗妯″潡 鈥� 涓氬姟鏁版嵁
+ -- ============================================================
+ TRUNCATE TABLE after_sale_return_item;
+ TRUNCATE TABLE after_sale_return;
+ TRUNCATE TABLE after_sale_ticket_item;
+ TRUNCATE TABLE after_sale_ticket;
+ TRUNCATE TABLE after_sale_repair;
+ TRUNCATE TABLE after_sale_permission;
+
+ -- ============================================================
+ -- 12. ERP 妯″潡 鈥� 涓氬姟鏁版嵁
+ -- 淇濈暀锛歟rp_supplier / erp_account
+ -- ============================================================
+ TRUNCATE TABLE erp_finance_payment_item;
+ TRUNCATE TABLE erp_finance_payment;
+ TRUNCATE TABLE erp_finance_receipt_item;
+ TRUNCATE TABLE erp_finance_receipt;
+ TRUNCATE TABLE erp_purchase_order_items;
+ TRUNCATE TABLE erp_purchase_order;
+ TRUNCATE TABLE erp_purchase_request_items;
+ TRUNCATE TABLE erp_purchase_request;
+ TRUNCATE TABLE erp_sale_order_items;
+ TRUNCATE TABLE erp_sale_order;
+ TRUNCATE TABLE erp_purchase_invoice;
+
+ -- ============================================================
+ -- 13. SRM 妯″潡 鈥� 涓氬姟鏁版嵁
+ -- 淇濈暀锛歴rm_supplier / srm_supplier_contact / srm_supplier_category
+ -- / srm_tender_config
+ -- ============================================================
+ TRUNCATE TABLE srm_bid_award;
+ TRUNCATE TABLE srm_bid_evaluation;
+ TRUNCATE TABLE srm_bid_open;
+ TRUNCATE TABLE srm_tender_bid;
+ TRUNCATE TABLE srm_tender_material;
+ TRUNCATE TABLE srm_tender_project;
+ TRUNCATE TABLE srm_delivery_plan;
+ TRUNCATE TABLE srm_purchase_collaboration;
+ TRUNCATE TABLE srm_supplier_quote;
+ TRUNCATE TABLE srm_supplier_evaluation;
+ TRUNCATE TABLE srm_supplier_certificate;
+ TRUNCATE TABLE srm_supplier_apply;
+
+ -- ============================================================
+ -- 14. HRM 妯″潡 鈥� 涓氬姟鏁版嵁
+ -- 淇濈暀锛歨rm_employee 鍙婃。妗堝瓙琛紙鏁欒偛/宸ヤ綔缁忓巻/绱ф�ヨ仈绯讳汉/
+ -- 绀句繚鍏Н閲�/钖叕妗ｆ/鍚堝悓锛夈�佽�冨嫟鑺傚亣鏃�/瑙勫垯銆佽鍋囩被鍨嬮厤缃��
+ -- 钖叕缁撴瀯銆佺ぞ淇濆叕绉噾鏂规銆佷釜绋庣◣鐜囬厤缃�
+ -- ============================================================
+ TRUNCATE TABLE hrm_salary_payment_detail;
+ TRUNCATE TABLE hrm_salary_payment;
+ TRUNCATE TABLE hrm_salary_calculation;
+ TRUNCATE TABLE hrm_attendance_summary;
+ TRUNCATE TABLE hrm_attendance_record;
+ TRUNCATE TABLE hrm_attendance_exception;
+ TRUNCATE TABLE hrm_leave_application;
+ TRUNCATE TABLE hrm_resignation_application;
+ TRUNCATE TABLE hrm_transfer_application;
+
+ -- ============================================================
+ -- 15. AI 妯″潡 鈥� 瀵硅瘽涓庣敓鎴愬唴瀹�
+ -- 淇濈暀锛歛i_api_key / ai_model / ai_tool / ai_chat_role
+ -- / ai_knowledge(_document/_segment) / ai_workflow
+ -- ============================================================
+ TRUNCATE TABLE ai_chat_message;
+ TRUNCATE TABLE ai_chat_conversation;
+ TRUNCATE TABLE ai_image;
+ TRUNCATE TABLE ai_mind_map;
+ TRUNCATE TABLE ai_music;
+ TRUNCATE TABLE ai_write;
+
+ -- ============================================================
+ -- 16. IM 妯″潡 鈥� 浼氳瘽涓庢秷鎭�
+ -- 淇濈暀锛歩m_sensitive_word / im_face_pack / im_face_pack_item
+ -- ============================================================
+ TRUNCATE TABLE im_group_message_receipt;
+ TRUNCATE TABLE im_group_message;
+ TRUNCATE TABLE im_private_message;
+ TRUNCATE TABLE im_message_file;
+ TRUNCATE TABLE im_group_request;
+ TRUNCATE TABLE im_group_member;
+ TRUNCATE TABLE im_group;
+ TRUNCATE TABLE im_friend_request;
+ TRUNCATE TABLE im_friend;
+ TRUNCATE TABLE im_conversation_read;
+ TRUNCATE TABLE im_conversation;
+ TRUNCATE TABLE im_channel_message;
+ TRUNCATE TABLE im_channel_material;
+ TRUNCATE TABLE im_channel;
+ TRUNCATE TABLE im_rtc_participant;
+ TRUNCATE TABLE im_rtc_call;
+ TRUNCATE TABLE im_user_online;
+ TRUNCATE TABLE im_face_user_item;
+
+ -- ============================================================
+ -- 17. OA 宸茶/鎸囧畾浜哄叧鑱旓紙淇濈暀閫氱煡鍏憡鍐呭 oa_notice / system_notice锛�
+ -- ============================================================
+ TRUNCATE TABLE oa_notice_read;
+ TRUNCATE TABLE oa_notice_user;
+
+ -- ============================================================
+ -- 18. 绀轰緥鏁版嵁
+ -- ============================================================
+ TRUNCATE TABLE yudao_demo01_contact;
+ TRUNCATE TABLE yudao_demo02_category;
+ TRUNCATE TABLE yudao_demo03_course;
+ TRUNCATE TABLE yudao_demo03_grade;
+ TRUNCATE TABLE yudao_demo03_student;
+
+ -- ============================================================
+ -- 19. 鍩虹鏁版嵁涓庝竴琚嬩竴鐮佺鐞�
+ -- 鍩虹鏁版嵁锛氱墿鏂欑鐞� / 鐗╂枡鍒嗙被 / 璁￠噺鍗曚綅 / 鍝佺墝 / SKU
+ -- 涓�琚嬩竴鐮侊細浜х嚎缁存姢 / 鎵规鐢熶骇绠＄悊 / 璧嬬爜绠＄悊 / 鎵樼洏鐮佺鐞�
+ -- 鍝佺鏁版嵁婧愶細mes_md_item锛堜笌 mdm_item 鍚屾锛屾壒娆�/琚嬬爜閫夊搧绉嶄娇鐢級
+ -- 淇濈暀锛歮es_md_vendor锛堜緵搴斿晢锛屼笌 erp_supplier 绛栫暐涓�鑷达級
+ -- / mdm_warehouse锛堜粨搴擄紝涓� mes_wm_warehouse 绛栫暐涓�鑷达級
+ -- / mes_md_workshop / mes_md_workstation*锛堣溅闂村伐浣滅珯閰嶇疆锛�
+ -- ============================================================
+ -- 涓�琚嬩竴鐮侊細鍏堟竻寮曠敤鎵规鐨勬槑缁嗭紝鍐嶆竻鎵规涓庝骇绾�
+ TRUNCATE TABLE mes_pro_batch_worker;
+ TRUNCATE TABLE mes_pro_bag_code_replace; -- 琚嬬爜鏇挎崲璁板綍锛堝師鑴氭湰閬楁紡锛�
+ TRUNCATE TABLE mes_pro_bag_code;
+ TRUNCATE TABLE mes_pro_pallet;
+ TRUNCATE TABLE mes_pro_batch;
+ TRUNCATE TABLE mes_pro_line;
+ -- 鍝佺鏁版嵁婧愶紙MES 鐗╂枡浜у搧鍏宠仈閰嶇疆锛�
+ TRUNCATE TABLE mes_md_product_bom;
+ TRUNCATE TABLE mes_md_product_sop;
+ TRUNCATE TABLE mes_md_product_sip;
+ TRUNCATE TABLE mes_md_item_batch_config;
+ TRUNCATE TABLE mes_md_unit_measure; -- MES 璁￠噺鍗曚綅锛堝師鑴氭湰閬楁紡锛�
+ TRUNCATE TABLE mes_md_item;
+ -- 鍩虹鏁版嵁锛圡DM 鐗╂枡涓绘暟鎹� / 鍒嗙被 / 璁￠噺鍗曚綅 / 鍝佺墝 / SKU锛�
+ TRUNCATE TABLE mdm_item_batch_config;
+ TRUNCATE TABLE mdm_item_sku; -- 鐗╂枡 SKU锛坢dm_item 瀛愯〃锛屽師鑴氭湰閬楁紡锛�
+ TRUNCATE TABLE mdm_item;
+ TRUNCATE TABLE mdm_item_category; -- 鐗╂枡鍒嗙被锛堝師鑴氭湰閬楁紡锛�
+ TRUNCATE TABLE mdm_brand; -- 鍝佺墝锛堝師鑴氭湰閬楁紡锛�
+ TRUNCATE TABLE mes_md_item_type;
+ TRUNCATE TABLE mdm_unit_measure;
+ -- 鐗╂枡杩佺Щ鏄犲皠琛細濡傛竻鐞嗗悗闇�浠� ERP 閲嶆柊杩佺Щ鐗╂枡锛岃鏀惧紑涓嬮潰涓�琛�
+ -- TRUNCATE TABLE mdm_item_migration_map;
+
+ SET FOREIGN_KEY_CHECKS = 1;
+
+ -- ============================================================
+ -- 娓呯悊缁撴灉鏍￠獙锛堜唬琛ㄨ〃琛屾暟搴斿叏閮ㄤ负 0锛�
+ -- ============================================================
+ SELECT
+ (SELECT COUNT(*) FROM mes_pro_work_order) AS work_order_cnt,
+ (SELECT COUNT(*) FROM mes_wm_material_stock) AS stock_cnt,
+ (SELECT COUNT(*) FROM mes_qc_iqc) AS iqc_cnt,
+ (SELECT COUNT(*) FROM crm_contract) AS contract_cnt,
+ (SELECT COUNT(*) FROM erp_sale_order) AS sale_order_cnt,
+ (SELECT COUNT(*) FROM mdm_item) AS mdm_item_cnt,
+ (SELECT COUNT(*) FROM system_operate_log) AS operate_log_cnt;
+
+ SELECT '涓氬姟鏁版嵁娓呯悊瀹屾垚' AS result;
+END $$
+
+DELIMITER ;
diff --git a/yudao-server/src/main/resources/application-thzy.yaml b/yudao-server/src/main/resources/application-thzy.yaml
index 6d3ed1f..b79c886 100644
--- a/yudao-server/src/main/resources/application-thzy.yaml
+++ b/yudao-server/src/main/resources/application-thzy.yaml
@@ -55,11 +55,12 @@
min-idle: 1 # 鏈�灏忚繛鎺ユ睜鏁伴噺
max-active: 20 # 鏈�澶ц繛鎺ユ睜鏁伴噺
max-wait: 60000 # 閰嶇疆鑾峰彇杩炴帴绛夊緟瓒呮椂鐨勬椂闂达紝鍗曚綅锛氭绉掞紙1 鍒嗛挓锛�
- time-between-eviction-runs-millis: 60000 # 閰嶇疆闂撮殧澶氫箙鎵嶈繘琛屼竴娆℃娴嬶紝妫�娴嬮渶瑕佸叧闂殑绌洪棽杩炴帴锛屽崟浣嶏細姣锛�1 鍒嗛挓锛�
+ time-between-eviction-runs-millis: 30000 # 閰嶇疆闂撮殧澶氫箙鎵嶈繘琛屼竴娆℃娴嬶紝妫�娴嬮渶瑕佸叧闂殑绌洪棽杩炴帴锛屽崟浣嶏細姣锛�30 绉掞紝鍘嬬缉绌洪棽杩炴帴鏈妫�娴嬬殑缂濋殭锛�
min-evictable-idle-time-millis: 600000 # 閰嶇疆涓�涓繛鎺ュ湪姹犱腑鏈�灏忕敓瀛樼殑鏃堕棿锛屽崟浣嶏細姣锛�10 鍒嗛挓锛�
max-evictable-idle-time-millis: 1800000 # 閰嶇疆涓�涓繛鎺ュ湪姹犱腑鏈�澶х敓瀛樼殑鏃堕棿锛屽崟浣嶏細姣锛�30 鍒嗛挓锛�
validation-query: SELECT 1 FROM DUAL # 閰嶇疆妫�娴嬭繛鎺ユ槸鍚︽湁鏁�
test-while-idle: true
+ keepAlive: true # 绌洪棽杩炴帴瀹氭湡鍙戦�佹娴嬪寘淇濇椿锛岄伩鍏嶈鏈嶅姟绔� wait_timeout 鍥炴敹
test-on-borrow: false
test-on-return: false
pool-prepared-statements: true # 鏄惁寮�鍚� PreparedStatement 缂撳瓨
@@ -67,16 +68,16 @@
primary: master
datasource:
master:
- url: jdbc:mysql://172.17.0.1:9000/mom-thzy?useSSL=false&serverTimezone=Asia/Shanghai&allowPublicKeyRetrieval=true&nullCatalogMeansCurrent=true&rewriteBatchedStatements=true # MySQL Connector/J 8.X 杩炴帴鐨勭ず渚�
+ url: jdbc:mysql://172.17.0.2:3306/mom-thzynew?useSSL=false&serverTimezone=Asia/Shanghai&allowPublicKeyRetrieval=true&nullCatalogMeansCurrent=true&rewriteBatchedStatements=true # MySQL Connector/J 8.X 杩炴帴鐨勭ず渚�
username: root
password: thzy@123456..
# Redis 閰嶇疆銆俁edisson 榛樿鐨勯厤缃冻澶熶娇鐢紝涓�鑸笉闇�瑕佽繘琛岃皟浼�
data:
redis:
- host: 172.17.0.1 # 鍦板潃
- port: 10200 # 绔彛
- database: 1 # 鏁版嵁搴撶储寮�
+ host: 172.17.0.6 # 鍦板潃
+ port: 6379 # 绔彛
+ database: 3 # 鏁版嵁搴撶储寮�
# password: dev # 瀵嗙爜锛屽缓璁敓浜х幆澧冨紑鍚�
--- #################### 瀹氭椂浠诲姟鐩稿叧閰嶇疆 ####################
@@ -191,7 +192,7 @@
storage: # 鏂囦欢涓婁紶閰嶇疆
path: /home/mom/javaWork/file # 鏂囦欢瀛樺偍鏍圭洰褰�
url-prefix: /admin-api/system/storage-blob # URL璺緞鍓嶇紑
- domain: http://47.97.181.254:9001 # 鍩熷悕鍓嶇紑锛堟寜瀹為檯鍩熷悕閰嶇疆锛夛紝鍓嶇閰嶇疆濂藉儚涓嶅お瀵圭幇鍦ㄦ槸鐩磋繛鍚庣锛屾墍鏈夎鍚庣绔彛
+ domain: http://47.97.181.254:9008 # 鍩熷悕鍓嶇紑锛堟寜瀹為檯鍩熷悕閰嶇疆锛夛紝鍓嶇閰嶇疆濂藉儚涓嶅お瀵圭幇鍦ㄦ槸鐩磋繛鍚庣锛屾墍鏈夎鍚庣绔彛
expired: 120 # token杩囨湡鏃堕棿锛堝垎閽燂級
use-limit: 10 # token浣跨敤娆℃暟涓婇檺
jwt-secret: abcdefghijklmnopqrstuvwxyz0123456789ABCDEFG # JWT瀵嗛挜
diff --git a/yudao-server/src/main/resources/application.yaml b/yudao-server/src/main/resources/application.yaml
index 4c9c073..ce5b8ba 100644
--- a/yudao-server/src/main/resources/application.yaml
+++ b/yudao-server/src/main/resources/application.yaml
@@ -96,8 +96,10 @@
aj:
captcha:
- jigsaw: classpath:images/jigsaw # 婊戝姩楠岃瘉锛屽簳鍥捐矾寰勶紝涓嶉厤缃皢浣跨敤榛樿鍥剧墖锛涗互 classpath: 寮�澶达紝鍙� resource 鐩綍涓嬭矾寰�
- pic-click: classpath:images/pic-click # 婊戝姩楠岃瘉锛屽簳鍥捐矾寰勶紝涓嶉厤缃皢浣跨敤榛樿鍥剧墖锛涗互 classpath: 寮�澶达紝鍙� resource 鐩綍涓嬭矾寰�
+ # 娉ㄦ剰锛氬繀椤荤敤 classpath*: 鍓嶇紑銆俢lasspath: 閫氶厤鎵弿涓嶄簡 jar 鍐呯洰褰曪紝
+ # fat jar 閮ㄧ讲鏃跺簳鍥惧湪 BOOT-INF/lib/yudao-module-system-*.jar 鍐呬細鎵弿涓虹┖锛屽鑷� /captcha/get 鎶� 6113
+ jigsaw: classpath*:images/jigsaw # 婊戝姩楠岃瘉锛屽簳鍥捐矾寰勶紝涓嶉厤缃皢浣跨敤榛樿鍥剧墖锛涗互 classpath 寮�澶达紝鍙� resource 鐩綍涓嬭矾寰�
+ pic-click: classpath*:images/pic-click # 鏂囧瓧鐐归�夛紝搴曞浘璺緞锛屼笉閰嶇疆灏嗕娇鐢ㄩ粯璁ゅ浘鐗囷紱浠� classpath 寮�澶达紝鍙� resource 鐩綍涓嬭矾寰�
cache-type: redis # 缂撳瓨 local/redis...
cache-number: 1000 # local 缂撳瓨鐨勯槇鍊�,杈惧埌杩欎釜鍊硷紝娓呴櫎缂撳瓨
timing-clear: 180 # local瀹氭椂娓呴櫎杩囨湡缂撳瓨(鍗曚綅绉�),璁剧疆涓�0浠ｈ〃涓嶆墽琛�
--
Gitblit v1.9.3