字符集错误的数据表 (字符集不一致可能会导致乱码,请手动修复以下数据表,当前字符集 GBK)
pre_dmember_view(utf8)
新增字段的数据表 (以下数据表中的字段可能是某些插件添加的,如你确认无误,可以忽略它们)
pre_common_member 新增的字段
banrate tinyint(1) unsigned NOT NULL
bansub tinyint(2) unsigned NOT NULL
banviewlog varchar(10) NOT NULL
cardstats tinyint(2) unsigned NOT NULL
colors varchar(15) NOT NULL
duty text NOT NULL
expiredate int(10) unsigned NOT NULL
icon varchar(255) NOT NULL
joindate int(10) unsigned NOT NULL
rate mediumint(5) unsigned NOT NULL
stats smallint(2) unsigned NOT NULL
subuid int(10) unsigned NOT NULL
subusername varchar(255) NOT NULL
pre_common_member_status 新增的字段
notifications text NOT NULL
pre_common_usergroup 新增的字段
checkday mediumint(3) unsigned NOT NULL
lastpay int(10) unsigned NOT NULL
laststat int(10) unsigned NOT NULL
payday mediumint(3) unsigned NOT NULL
rate mediumint(5) unsigned NOT NULL
taxrate mediumint(3) unsigned NOT NULL
pre_common_usergroup_field 新增的字段
allowviewlog tinyint(1) unsigned NOT NULL
allowviewpay tinyint(1) unsigned NOT NULL
allowviewtable tinyint(1) unsigned NOT NULL
charger varchar(255) NOT NULL
checkin text NOT NULL
checkout text NOT NULL
maxsub mediumint(3) unsigned NOT NULL
maxvat mediumint(3) unsigned NOT NULL
money1 int(10) NOT NULL
money2 int(10) NOT NULL
money3 int(10) NOT NULL
money4 int(10) NOT NULL
money5 int(10) NOT NULL
money6 int(10) NOT NULL
money7 int(10) NOT NULL
money8 int(10) NOT NULL
suboff mediumint(3) unsigned NOT NULL
vatoff mediumint(3) unsigned NOT NULL