|
|
楼主 |
发表于 2026-3-29 10:51:24
|
显示全部楼层
修复部分表fields 限制json值,默认为空,为不合规数据,改设置为{}
- -- 对原库进行修复
- -- 批量修复表结构,设置默认值为{}
- ALTER TABLE pre_common_member_profile_archive MODIFY COLUMN fields json NOT NULL DEFAULT '{}';
- ALTER TABLE pre_common_member_profile_history MODIFY COLUMN fields json NOT NULL DEFAULT '{}';
- ALTER TABLE pre_common_usergroup_field MODIFY COLUMN fields json NOT NULL DEFAULT '{}';
- ALTER TABLE pre_forum_forumfield MODIFY COLUMN fields json NOT NULL DEFAULT '{}';
- ALTER TABLE pre_home_docomment MODIFY COLUMN fields json NOT NULL DEFAULT '{}';
- ALTER TABLE pre_home_doing MODIFY COLUMN fields json NOT NULL DEFAULT '{}';
- -- 批量修复空值 '' 为合法JSON {}
- UPDATE pre_common_member_profile_archive SET fields = '{}' WHERE fields = '' OR fields IS NULL;
- UPDATE pre_common_member_profile_history SET fields = '{}' WHERE fields = '' OR fields IS NULL;
- UPDATE pre_common_usergroup_field SET fields = '{}' WHERE fields = '' OR fields IS NULL;
- UPDATE pre_forum_forumfield SET fields = '{}' WHERE fields = '' OR fields IS NULL;
- UPDATE pre_home_docomment SET fields = '{}' WHERE fields = '' OR fields IS NULL;
- UPDATE pre_home_doing SET fields = '{}' WHERE fields = '' OR fields IS NULL;
复制代码 |
|