18 lines
1.2 KiB
SQL
18 lines
1.2 KiB
SQL
-- 唐侦探 season-01 独立存档。仅新增表；不修改用户、患者或三消业务表。
|
|
-- 默认前缀 zyt_；部署时须与 database.prefix 核对。不要对线上库自动执行。
|
|
CREATE TABLE IF NOT EXISTS `zyt_tcm_tang_detective_progress` (
|
|
`id` bigint unsigned NOT NULL AUTO_INCREMENT,
|
|
`user_id` int unsigned NOT NULL COMMENT '统一 token 对应的小程序用户 ID',
|
|
`schema_version` smallint unsigned NOT NULL DEFAULT 1,
|
|
`content_version` varchar(32) NOT NULL DEFAULT 'season-01',
|
|
`revision` int unsigned NOT NULL DEFAULT 1 COMMENT '成功写入递增，旧修订不能覆盖',
|
|
`story_generation` int unsigned NOT NULL DEFAULT 0 COMMENT '重新开始故事时递增',
|
|
`progress_json` text NOT NULL COMMENT '严格白名单 ID 及游标，不含正文或健康选择',
|
|
`last_request_id` varchar(64) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
|
|
`last_request_hash` char(64) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
|
|
`create_time` int unsigned NOT NULL DEFAULT 0,
|
|
`update_time` int unsigned NOT NULL DEFAULT 0,
|
|
PRIMARY KEY (`id`),
|
|
UNIQUE KEY `uk_tang_progress_user` (`user_id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='唐侦探用户独立章节存档';
|