games-development-ai/contracts/db-schemas/V35.0.0__clarify_game_artifact_manifest_hash.sql
lili 1981a6be01
Some checks failed
contract-gates / contract-gates (push) Has been cancelled
docs-gate / docs-gate (push) Has been cancelled
feat(storage): 闭合 Agent 到 Runtime 的 OSS 游戏链路
增加不可变源码检出、两阶段 finalize/activate、Runtime 同源对象读取与 iframe 安全边界,并用 fail-closed CI 门固定契约。Git 仅提交平台实现、契约、迁移和 SoT,不包含具体游戏源码、素材、bundle 或验收证据。
2026-07-30 05:21:44 -07:00

13 lines
939 B
SQL
Raw Permalink Blame History

This file contains ambiguous Unicode characters

This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

-- =============================================================================
-- 契约 #2 DB 迁移 | 模块runtime/storage对象清单摘要语义| ownerWS3 + WS2
-- 文件V35.0.0__clarify_game_artifact_manifest_hash.sql
-- 目的:澄清 V34 两个契约清单摘要字段保存的是契约 manifestHash而非清单原始字节摘要。
-- 边界V34 已执行且保持字节不可变;本迁移只修改列注释,不改变数据和索引。
-- =============================================================================
ALTER TABLE `game_artifact_storage`
MODIFY COLUMN `artifact_manifest_hash` CHAR(64) NOT NULL DEFAULT ''
COMMENT 'GameArtifactManifest/1 manifestHash域标签 + 去自身字段 canonical JSON SHA-256',
MODIFY COLUMN `source_manifest_hash` CHAR(64) NOT NULL DEFAULT ''
COMMENT 'GameSourceArchive/1 manifestHash域标签 + 去自身字段 canonical JSON SHA-256';