8月17号(即官方正式发布的beta包,直接用官方的beta升级包即可)
1. 修改pw_kmd_info、pw_kmd_paylog、pw_kmd_spread、pw_kmd_user表的表结构(安装包中有)
请到phpmyadmin中运行(就是你管理数据库的地方)
复制代码
- DROP TABLE IF EXISTS `pw_kmd_info`;
- CREATE TABLE IF NOT EXISTS `pw_kmd_info` (
- `kid` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `fid` mediumint(8) unsigned NOT NULL DEFAULT '0',
- `uid` int(10) unsigned NOT NULL DEFAULT '0',
- `tid` int(10) unsigned NOT NULL DEFAULT '0',
- `status` tinyint(1) unsigned NOT NULL DEFAULT '0',
- `starttime` int(10) unsigned NOT NULL DEFAULT '0',
- `endtime` int(10) unsigned NOT NULL DEFAULT '0',
- PRIMARY KEY (`kid`),
- KEY `idx_tid` (`tid`)
- ) ENGINE=MyISAM ;
- DROP TABLE IF EXISTS `pw_kmd_paylog`;CREATE TABLE IF NOT EXISTS `pw_kmd_paylog` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `kid` int(10) unsigned NOT NULL DEFAULT '0',
- `fid` mediumint(8) unsigned NOT NULL DEFAULT '0', `uid` int(10) unsigned NOT NULL DEFAULT '0',
- `sid` int(10) unsigned NOT NULL DEFAULT '0', `type` tinyint(3) unsigned NOT NULL DEFAULT '0',
- `money` decimal(14,2) unsigned NOT NULL DEFAULT '0.00', `status` tinyint(3) unsigned NOT NULL DEFAULT '1',
- `createtime` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`),
- KEY `idx_fid` (`fid`), KEY `idx_uid` (`uid`),
- KEY `idx_createtime` (`createtime`)) ENGINE=MyISAM;
- DROP TABLE IF EXISTS `pw_kmd_spread`;CREATE TABLE IF NOT EXISTS `pw_kmd_spread` (
- `sid` int(10) NOT NULL AUTO_INCREMENT, `displayorder` int(10) UNSIGNED NOT NULL DEFAULT '0',
- `name` varchar(50) NOT NULL DEFAULT '', `day` smallint(3) UNSIGNED NOT NULL DEFAULT '0',
- `price` decimal(14,2) UNSIGNED NOT NULL DEFAULT '0.00', `discount` DECIMAL( 2, 1 ) UNSIGNED NOT NULL DEFAULT '0.0',
- PRIMARY KEY (`sid`)) ENGINE=MyISAM;
- DROP TABLE IF EXISTS `pw_kmd_user`;CREATE TABLE IF NOT EXISTS `pw_kmd_user` (
- `uid` int(10) UNSIGNED NOT NULL DEFAULT 0, `phone` varchar(15) DEFAULT NULL,
- `realname` varchar(15) NOT NULL DEFAULT '', `invoice` varchar(100) NOT NULL DEFAULT '',
- `address` varchar(200) NOT NULL DEFAULT '', PRIMARY KEY (`uid`)
- ) ENGINE=MyISAM;
2.更新pw_threads表字段及索引
到phpmyadmin中运行
ALTER TABLE `pw_threads` ADD `specialsort` TINYINT UNSIGNED NOT NULL DEFAULT 0;
ALTER TABLE `pw_threads` DROP INDEX `idx_fid_ifcheck_topped_lastpost` ,
ADD INDEX `idx_fid_ifcheck_specialsort_lastpost` ( `fid` , `ifcheck` , `specialsort` , `lastpost` )
3.上传85to87的升级包(注意是85to87)
4.运行pw87betato87.php进行升级(文件在87beta升级至87的包中)