Files
svc-hall-service/sql/add_fc_projection_version.sql
chenxing 391281582a
build / build-push (push) Successful in 1m21s
t1~t3+精修: 事项FC绑定/可信建件(意图+投影+恢复)/答卷对账Worker
含10-22精修: 对账有限重试(retry_count/指数退避/work_version防旧覆盖)+接缝身份(source-app-key空拒收)+应急对账闸让位FlowApplyRecoveryService+同attempt指令不重开终态。SQL未执行。
2026-10-22 10:03:07 +08:00

8 lines
498 B
SQL

-- TASK_2 prerequisite repair: local optimistic generation (NOT FC answer_revision).
-- Existing TASK_2 installations only. Run once, before deploying the new entity.
-- For a fresh schema use fc_projection_and_apply_intent.sql; do not run both.
-- MySQL 5.7; non-idempotent: inspect SHOW COLUMNS before execution.
ALTER TABLE fc_answer_projection
ADD COLUMN projection_version BIGINT NOT NULL DEFAULT 0
COMMENT 'Local optimistic generation; guards MQ/receipt/authoritative repair writes';