手工在 系統(tǒng)->SQL命令行工具 的地方運(yùn)行下面SQL
(在線升級(jí)用戶后如果有出現(xiàn)錯(cuò)誤的,如:不能修改欄目等,也手工運(yùn)行一下SQL)
ALTER TABLE `#@__admintype` CHANGE `rank` `rank` FLOAT( 6 ) DEFAULT '1';
UPDATE `#@__admintype` set `rank`=(5 + (`rank`/10)) where `rank` > 10;
ALTER TABLE `#@__admin` CHANGE `usertype` `usertype` FLOAT( 6 ) UNSIGNED DEFAULT '0';
UPDATE `#@__admin` set `usertype`=(5 + (`usertype`/10)) where `usertype` > 10;
INSERT INTO `#@__sysconfig` (`aid`, `varname`, `info`, `groupid`, `type`, `value`) VALUES (746, 'cfg_album_mark', '圖集是否使用水印(小圖也會(huì)受影響)', 3, 'bool', 'N');
ALTER TABLE `#@__arctype` ADD `seotitle` VARCHAR( 80 ) NOT NULL DEFAULT '' AFTER `keywords` ;
UPDATE `#@__arctype` set `seotitle` = `typename`;
ALTER TABLE `#@__arctype` CHANGE `keywords` `keywords` VARCHAR( 60 ) NOT NULL DEFAULT '';
ALTER TABLE `#@__tagindex` ADD `typeid` SMALLINT( 5 ) UNSIGNED DEFAULT '0' NOT NULL AFTER `tag` ;
www.kuangtao.net 狂淘購物網(wǎng)