huang
5065d925ad
All checks were successful
构建并部署到测试环境（无 SSH） / build-and-deploy (push) Successful in 7m33s
核心变更： 1. Model层时间字段改为*time.Time并设为nullable - PackageUsage.ActivatedAt/ExpiresAt - PersonalCustomerDevice/ICCID/Phone.LastUsedAt/VerifiedAt 2. 数据库迁移： - activated_at/expires_at列移除NOT NULL约束 - 清洗零值记录(status=0且activated_at<'2000-01-01') 3. 新增ActivateSpecificPackage方法：精准激活指定套餐， 修复HandlePackageQueueActivation从"查找过期包"改为直接激活payload指定套餐 4. 新增孤儿套餐恢复扫描：Worker启动或每次套餐检查时， 自动发现并恢复无status=1主套餐的孤儿载体 Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>
7 lines
263 B
SQL
7 lines
263 B
SQL
-- 回滚：无法恢复原有值，仅将已清洗为 NULL 的记录恢复为 NOT NULL 约束允许的最小值
|
|
UPDATE tb_package_usage
|
|
SET activated_at = '1970-01-01 00:00:00',
|
|
expires_at = '1970-01-01 00:00:00'
|
|
WHERE status = 0
|
|
AND activated_at IS NULL;
|