Discuz!X3.5修复 超长数据无法正常插入的问题需要升级的数据库语句
2021/12/31 10:09:15
Discuz!X3.5修复 超长数据无法正常插入的问题需要升级的数据库语句：
- ALTER TABLE `pre_common_admincp_perm` CHANGE `perm` `perm` VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;
- ALTER TABLE `pre_common_cache` CHANGE `cachekey` `cachekey` VARCHAR(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '';
- ALTER TABLE `pre_common_cache` DROP PRIMARY KEY, ADD PRIMARY KEY (`cachekey`) USING BTREE;
- ALTER TABLE `pre_common_card` CHANGE `id` `id` CHAR(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '';
- ALTER TABLE `pre_common_card` DROP PRIMARY KEY, ADD PRIMARY KEY (`id`) USING BTREE;
- ALTER TABLE `pre_common_member` DROP INDEX `email`, ADD INDEX `email` (`email`(40)) USING BTREE;
- ALTER TABLE `pre_common_member_profile_setting` CHANGE `fieldid` `fieldid` VARCHAR(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '';
- ALTER TABLE `pre_common_member_profile_setting` DROP PRIMARY KEY, ADD PRIMARY KEY (`fieldid`) USING BTREE;
- ALTER TABLE `pre_forum_groupfield` CHANGE `type` `type` VARCHAR(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;
- ALTER TABLE `pre_forum_groupfield` DROP INDEX `types`, ADD UNIQUE `types` (`fid`, `type`) USING BTREE;
- ALTER TABLE `pre_forum_groupfield` DROP INDEX `type`, ADD INDEX `type` (`type`) USING BTREE;
- ALTER TABLE `pre_mobile_setting` CHANGE `skey` `skey` VARCHAR(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '';
- ALTER TABLE `pre_mobile_setting` DROP PRIMARY KEY, ADD PRIMARY KEY (`skey`) USING BTREE;
- ALTER TABLE `uc_members` DROP INDEX `email`, ADD INDEX `email` (`email`(40)) USING BTREE;
- ALTER TABLE `uc_badwords` DROP INDEX `find`;