-- 投标结果由专门动作登记,保留每次开标及重新投标的流水。 CREATE TABLE IF NOT EXISTS `crm_bid_progress` ( `id` BIGINT NOT NULL AUTO_INCREMENT, `bid_bond_id` BIGINT NOT NULL, `action` VARCHAR(20) NOT NULL COMMENT 'CREATED/FOLLOW_UP/WON/LOST/REBID', `from_result` TINYINT DEFAULT NULL, `to_result` TINYINT NOT NULL, `quotation_round` INT DEFAULT NULL, `remark` VARCHAR(500) DEFAULT NULL, `creator` VARCHAR(64) DEFAULT '', `create_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, `updater` VARCHAR(64) DEFAULT '', `update_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `deleted` BIT(1) NOT NULL DEFAULT b'0', PRIMARY KEY (`id`), KEY `idx_bid_bond_id` (`bid_bond_id`, `id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='投标过程流水'; -- 旧单据只补一条导入快照,不伪造历史跟进动作。 INSERT INTO `crm_bid_progress` (`bid_bond_id`, `action`, `from_result`, `to_result`, `quotation_round`, `remark`, `creator`, `create_time`) SELECT b.`id`, 'IMPORTED', NULL, b.`bid_result`, b.`quotation_round`, '历史单据导入时的状态快照', b.`creator`, b.`create_time` FROM `crm_bid_bond` b WHERE b.`deleted` = b'0' AND NOT EXISTS (SELECT 1 FROM `crm_bid_progress` p WHERE p.`bid_bond_id` = b.`id`);