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/mdm_agent_import_command_20261022.sql | 55 +++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 55 insertions(+), 0 deletions(-) diff --git a/sql/mysql/mdm_agent_import_command_20261022.sql b/sql/mysql/mdm_agent_import_command_20261022.sql new file mode 100644 index 0000000..3ef179a --- /dev/null +++ b/sql/mysql/mdm_agent_import_command_20261022.sql @@ -0,0 +1,55 @@ +-- 鏅鸿兘浣撶墿鏂欏鍏ュ箓绛夊懡浠や笌閫愯鍥炴墽銆傛墽琛屽墠澶囦唤鐩爣搴擄紝骞跺湪搴旂敤鍙戝竷鍓嶅畬鎴愯縼绉汇�� +CREATE TABLE IF NOT EXISTS `mdm_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', + `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 '鏅鸿兘浣撴柟妗堟憳瑕�', + `sync_mes` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍚屾 MES锛堟湰闃舵鍥哄畾鍏抽棴锛�', + `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_command` (`owner_user_id`, `command_id`), + UNIQUE KEY `uk_agent_import_idempotency` (`owner_user_id`, `idempotency_key`), + KEY `idx_agent_import_command_session` (`session_id`, `create_time`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='鏅鸿兘浣撶墿鏂欏鍏ュ懡浠�'; + +CREATE TABLE IF NOT EXISTS `mdm_agent_import_command_row` ( + `id` bigint NOT NULL AUTO_INCREMENT COMMENT '涓婚敭', + `command_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 '鍒涘缓鐨勭墿鏂� ID', + `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_row` (`command_id`, `candidate_id`), + KEY `idx_agent_import_row_command` (`command_id`, `source_row`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='鏅鸿兘浣撶墿鏂欏鍏ラ�愯鍥炴墽'; -- Gitblit v1.9.3