谢谢分享,就是前台用Navicat来查询不知道如何用,
##account数据库查询新增字段
ALTER TABLE `fiona_logins`
ADD COLUMN `points` int(4) NOT NULL DEFAULT 0 AFTER `release_reason`;
ALTER TABLE `fiona_logins`
ADD COLUMN `zuanshi` int(4) NOT NULL DEFAULT 0 AFTER `points`;
有的人数据表设计不一样的,注册出错需要在新增这二个字段
ALTER TABLE `fiona_logins`
ADD COLUMN `fc` varchar(32) NOT NULL DEFAULT 0 AFTER `login_password`;
ALTER TABLE `fiona_logins`
ADD COLUMN `email` varchar(64) NOT NULL DEFAULT 0 AFTER `fc`;
##clunicode数据库查询新增字段
ALTER TABLE `char_body`
ADD COLUMN `totalLevel` int(4) NOT NULL DEFAULT 0 AFTER `used`;
ALTER TABLE `char_body`
ADD COLUMN `zsCount` int(4) NOT NULL DEFAULT 0 AFTER `totalLevel`;
ALTER TABLE `char_body`
ADD COLUMN `flag1` int(4) NOT NULL DEFAULT 0 AFTER `zsCount`;
ALTER TABLE `char_body`
ADD COLUMN `flag2` int(4) NOT NULL DEFAULT 0 AFTER `flag1`;
ALTER TABLE `char_body`
ADD COLUMN `flag3` int(4) NOT NULL DEFAULT 0 AFTER `flag2`;
ALTER TABLE `char_body`
ADD COLUMN `flag4` int(4) NOT NULL DEFAULT 0 AFTER `flag3`;
ALTER TABLE `char_body`
ADD COLUMN `flag5` int(4) NOT NULL DEFAULT 0 AFTER `flag4`;
ALTER TABLE `char_body`
ADD COLUMN `flag6` int(4) NOT NULL DEFAULT 0 AFTER `flag5`;
ALTER TABLE `char_body`
ADD COLUMN `flag7` int(4) NOT NULL DEFAULT 0 AFTER `flag6`;
ALTER TABLE `char_pets`
ADD COLUMN `totalLevel` int(4) NOT NULL DEFAULT 0 AFTER `bat_count`;
ALTER TABLE `char_pets`
ADD COLUMN `zsCount` int(4) NOT NULL DEFAULT 0 AFTER `totalLevel`;
ALTER TABLE `char_pets`
ADD COLUMN `flag0` int(4) NOT NULL DEFAULT 0 AFTER `zsCount`;
ALTER TABLE `char_pets`
ADD COLUMN `isbuy` int(4) NOT NULL DEFAULT 0 AFTER `bat_count`;
ALTER TABLE `char_items`
ADD COLUMN `isbuy` int(4) NOT NULL DEFAULT 0 AFTER `record_info`;