IX主机部分反映旧版织梦CMS被自动升级到v5.7的解决方法

alter table `dede_addoninfos` CHANGE `infotype` `infotype` char(20) NOT NULL default '0' COMMENT '' AFTER `nativeplace`;
alter table `dede_addonshop` ADD `vocation` char(20) NOT NULL default '0' COMMENT '' AFTER `redirecturl`;
alter table `dede_addonshop` ADD `infotype` char(20) NOT NULL default '0' COMMENT '' ;
alter table `dede_addonshop` ADD `uptime` int(11) NOT NULL default '0' COMMENT '' ;
alter table `dede_archives` ADD `voteid` mediumint(8) NOT NULL COMMENT '' AFTER `badpost`;
alter table `dede_homepageset` ADD `showmod` tinyint(2) NOT NULL default '1' COMMENT '' AFTER `position`;
alter table `dede_member_stow` CHANGE `type` `type` varchar(10) COMMENT '' AFTER `addtime`;

CREATE TABLE `dede_purview` (
`mid` mediumint(8) default '0',
`typeid` smallint(5) default '0',
`rank` smallint(6) default NULL,
`pkey` varchar(30) character set latin1 NOT NULL,
`pvalue` text NOT NULL,
KEY `pkey` USING BTREE (`pkey`)
)ENGINE=MyISAM;

CREATE TABLE `dede_sphinx` (
`countid` int(11) unsigned NOT NULL,
`maxaid` int(11) unsigned NOT NULL,
PRIMARY KEY (`countid`)
)ENGINE=MyISAM;

CREATE TABLE `dede_arcmulti` (
`id` mediumint(8) unsigned NOT NULL auto_increment,
`tagid` char(60) NOT NULL default '',
`uptime` int(11) NOT NULL default '0',
`innertext` varchar(255) NOT NULL default '',
`pagesize` int(11) NOT NULL default '0',
`arcids` text NOT NULL,
`ordersql` varchar(255) default '',
`addfieldsSql` varchar(255) default '',
`addfieldsSqlJoin` varchar(255) default '',
`attstr` text,
PRIMARY KEY (`id`)
) ENGINE=MyISAM;

CREATE TABLE `dede_member_group` (
`id` int(10) NOT NULL auto_increment,
`groupname` varchar(50) NOT NULL,
`mid` int(8) NOT NULL,
PRIMARY KEY (`id`),
KEY `id` (`id`)
) ENGINE=MyISAM;

alter table `dede_sys_enum` CHANGE `evalue` `evalue` char(20) NOT NULL default '0' COMMENT '' AFTER `ename`;
alter table `dede_vote` ADD `isallow` tinyint(6) NOT NULL default '0' COMMENT '' AFTER `ismore`;
alter table `dede_vote` ADD `view` tinyint(6) NOT NULL default '0' COMMENT '' ;
alter table `dede_vote` ADD `spec` int(20) unsigned NOT NULL default '0' COMMENT '' ;
alter table `dede_vote` ADD `isenable` tinyint(6) NOT NULL default '0' COMMENT '' ;

CREATE TABLE `dede_vote_member` (
`id` mediumint(8) unsigned NOT NULL auto_increment,
`voteid` int(10) unsigned NOT NULL default '0',
`userid` varchar(50) NOT NULL default '',
`uptime` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`id`)
)ENGINE=MyISAM;

CREATE TABLE `dede_member_feed` (
`fid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`mid` smallint(8) unsigned NOT NULL DEFAULT '0',
`userid` char(20) NOT NULL DEFAULT '',
`uname` char(36) NOT NULL DEFAULT '',
`type` char(20) CHARACTER SET gb2312 NOT NULL DEFAULT '0',
`aid` mediumint(8) NOT NULL DEFAULT '0',
`dtime` int(10) unsigned NOT NULL DEFAULT '0',
`title` char(253) NOT NULL,
`note` char(200) NOT NULL DEFAULT '',
`ischeck` smallint(6) NOT NULL,
PRIMARY KEY (`fid`)
) ENGINE=MyISAM;

CREATE TABLE `dede_member_msg` (
`id` int(10) unsigned NOT NULL auto_increment,
`mid` mediumint(8) unsigned NOT NULL default '0',
`userid` char(20) NOT NULL default '',
`ip` char(15) NOT NULL default '',
`ischeck` smallint(6) NOT NULL default '0',
`dtime` int(10) unsigned NOT NULL default '0',
`msg` text,
PRIMARY KEY (`id`),
KEY `id` (`ischeck`,`mid`)
) ENGINE=MyISAM;

CREATE TABLE `dede_member_model` (
`id` int(10) NOT NULL auto_increment,
`name` varchar(20) NOT NULL,
`table` varchar(30) NOT NULL,
`description` varchar(50) NOT NULL,
`state` int(2) NOT NULL default '0',
`issystem` int(2) NOT NULL default '0',
`info` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM;

INSERT INTO `dede_member_model` VALUES ('1', '个人', 'dede_member_person', '个人会员模型', '1', '1', '\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n');
INSERT INTO `dede_member_model` VALUES ('2', '企业', 'dede_member_company', '公司企业会员模型', '1', '1', '\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n');

alter table `dede_member` ADD `checkmail` smallint(6) NOT NULL default '-1' COMMENT '' AFTER `loginip`;

INSERT INTO `dede_sysconfig` (`aid`, `varname`, `info`, `groupid`, `type`, `value`) VALUES ('747', 'cfg_mb_feedcheck', '会员动态是否需要审核', '4', 'bool', 'N');

INSERT INTO `dede_sysconfig` VALUES('752','cfg_mysql_type','数据库类型（支持mysql和mysqli）','2','string','mysqli'),
('753','cfg_sphinx_article','是否启用文章全文检索功能（需配置sphinx服务器）','7','bool','N'),
('754','cfg_sphinx_host','Sphinx服务器主机地址','7','string','localhost'),
('756','cfg_sphinx_port','Sphinx服务器端口号','7','number','9312'),
(14, 'cfg_domain_cookie', '跨域共享cookie的域名(例如: .dedecms.com)', 2, 'string', ''),
('757','cfg_memcache_enable','是否启用memcache缓存，如果为否(N)，默认使用文件缓存',6,'bool','N'),
('758','cfg_memcache_mc_defa','默认memcache缓存服务器地址',6,'string','memcache://127.0.0.1:11211/default127'),
('759','cfg_memcache_mc_oth','附加memcache缓存服务器地址',6,'string','');

UPDATE `dede_sysconfig` SET `info` = 'Html编辑器（ckeditor,需要fck的用户可以去官网下载）', `value` = 'ckeditor' WHERE `varname` = 'cfg_html_editor';