铜仁芸众商城数据表字段超长 同步数据结构出现错误解决办法

今天安装芸众商城，安装的数据库表少了几张，想把原始数据库表同步数据库结构时提醒下列错误，说明这三张表中有些字段超最大长度，遇上这情况一向也同步的，只必要打开该打开把对应字段数据值改小即可。重要涉及该三张表，假如在安装导入数据库过程中总表数据一向是2074张就是该题目导致，总数据2077张表

ims_yz_cstore_coupon

ims_yz_recharge_platform_phone

ims_yz_short_url

错误提醒如下

[Msg] Failed - Error on Table ims_yz_cstore_coupon - 1071 - Specified key was too long; max key length is 767 bytes
[Err] Synchronization Failed

(`uniacid`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARACTER SET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=Dynamic
[Msg] Failed - Error on Table ims_yz_recharge_platform_phone - 1071 - Specified key was too long; max key length is 767 bytes

[Msg] Failed - Error on Table ims_yz_short_url - 1071 - Specified key was too long; max key length is 767 bytes
[Err] Synchronization Failed

如打表表设计 ims_yz_short_url，找到最长的字段255改小即可，网址应该不超百字节，那就改80-100，其他的表都可参照如许修改，修改后保存

修改同步过程中就不会出现上述题目

同步后检查表总数