From 43aab58c9ecb1203770ba382efbdbae299ca87ec Mon Sep 17 00:00:00 2001 From: liu <2021943741@qq.com> Date: 星期一, 26 十月 2026 15:12:31 +0800 Subject: [PATCH] Merge remote-tracking branch 'origin/dev_business' into dev_business --- sql/mysql/agent_import_command_20261022.sql | 56 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 56 insertions(+), 0 deletions(-) diff --git a/sql/mysql/agent_import_command_20261022.sql b/sql/mysql/agent_import_command_20261022.sql new file mode 100644 index 0000000..852764f --- /dev/null +++ b/sql/mysql/agent_import_command_20261022.sql @@ -0,0 +1,56 @@ +-- 閫氱敤涓氬姟瀵煎叆骞傜瓑鍛戒护涓庨�愯鍥炴墽锛堜緵搴斿晢銆丅OM 绛夛級銆傛墽琛屽墠澶囦唤鐩爣搴撱�� +CREATE TABLE IF NOT EXISTS `agent_import_command` ( + `id` bigint NOT NULL AUTO_INCREMENT COMMENT '涓婚敭', + `command_id` varchar(64) NOT NULL COMMENT '鏅鸿兘浣撴彁浜ゅ懡浠� ID锛堝箓绛夛級', + `idempotency_key` varchar(128) NOT NULL COMMENT '骞傜瓑閿�', + `request_digest` char(64) NOT NULL COMMENT '璇锋眰鎽樿 SHA-256', + `module_id` varchar(64) NOT NULL COMMENT '涓氬姟妯″潡 ID锛屽 srm.supplier', + `owner_user_id` bigint NOT NULL COMMENT '鎻愪氦鐢ㄦ埛 ID', + `session_id` bigint DEFAULT NULL COMMENT '琛ュ綍浼氳瘽 ID', + `attachment_id` bigint NOT NULL COMMENT '闄勪欢 ID', + `source_sha256` char(64) NOT NULL COMMENT '闄勪欢鍐呭鎽樿', + `preflight_hash` char(64) NOT NULL COMMENT '棰勬璁″垝鎽樿', + `proposal_hash` varchar(128) DEFAULT NULL COMMENT '鏅鸿兘浣撴柟妗堟憳瑕�', + `status` varchar(20) NOT NULL DEFAULT 'RUNNING' COMMENT 'RUNNING/SUCCEEDED/PARTIAL_FAILED/FAILED/UNKNOWN', + `total_count` int NOT NULL DEFAULT 0 COMMENT '鎬昏鏁�', + `success_count` int NOT NULL DEFAULT 0 COMMENT '鎴愬姛琛屾暟', + `failed_count` int NOT NULL DEFAULT 0 COMMENT '澶辫触琛屾暟', + `skipped_count` int NOT NULL DEFAULT 0 COMMENT '璺宠繃琛屾暟', + `error_code` varchar(64) DEFAULT NULL COMMENT '鍛戒护绾ч敊璇爜', + `error_message` varchar(512) DEFAULT NULL COMMENT '鍛戒护绾ч敊璇俊鎭�', + `lease_expires_at` datetime DEFAULT NULL COMMENT '鎵ц绉熺害鍒版湡鏃堕棿', + `creator` varchar(64) DEFAULT NULL, + `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, + `updater` varchar(64) DEFAULT NULL, + `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, + `deleted` bit(1) NOT NULL DEFAULT b'0', + PRIMARY KEY (`id`), + UNIQUE KEY `uk_agent_import_generic_command` (`owner_user_id`, `module_id`, `command_id`), + UNIQUE KEY `uk_agent_import_generic_idempotency` (`owner_user_id`, `module_id`, `idempotency_key`), + KEY `idx_agent_import_generic_module` (`module_id`, `create_time`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='鏅鸿兘浣撻�氱敤涓氬姟瀵煎叆鍛戒护'; + +CREATE TABLE IF NOT EXISTS `agent_import_command_row` ( + `id` bigint NOT NULL AUTO_INCREMENT COMMENT '涓婚敭', + `command_id` varchar(64) NOT NULL COMMENT '鎻愪氦鍛戒护 ID', + `module_id` varchar(64) NOT NULL COMMENT '涓氬姟妯″潡 ID', + `candidate_id` varchar(64) NOT NULL COMMENT '瀵煎叆琛屾爣璇�', + `source_row` int DEFAULT NULL COMMENT '婧愭枃浠惰鍙�', + `code` varchar(64) DEFAULT NULL COMMENT '涓氬姟缂栫爜', + `name` varchar(255) DEFAULT NULL COMMENT '涓氬姟鍚嶇О', + `action` varchar(16) NOT NULL COMMENT 'CREATE/SKIP', + `status` varchar(16) NOT NULL COMMENT 'SUCCESS/FAILED/SKIPPED/UNKNOWN', + `target_item_id` bigint DEFAULT NULL COMMENT '鍐欏叆鍚庣殑鐩爣涓婚敭', + `target_version` varchar(64) DEFAULT NULL COMMENT '鐩爣鐗堟湰锛堥鐣欙級', + `error_code` varchar(64) DEFAULT NULL COMMENT '琛岀骇閿欒鐮�', + `error_message` varchar(512) DEFAULT NULL COMMENT '琛岀骇閿欒淇℃伅', + `retryable` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍙噸璇�', + `creator` varchar(64) DEFAULT NULL, + `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, + `updater` varchar(64) DEFAULT NULL, + `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, + `deleted` bit(1) NOT NULL DEFAULT b'0', + PRIMARY KEY (`id`), + UNIQUE KEY `uk_agent_import_generic_row` (`command_id`, `candidate_id`), + KEY `idx_agent_import_generic_row` (`command_id`, `source_row`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='鏅鸿兘浣撻�氱敤涓氬姟瀵煎叆閫愯鍥炴墽'; -- Gitblit v1.9.3