一 数据库升级
安装:
=============================================================
CREATE TABLE `cdb_auctionlog` (
`lid` int(10) unsigned NOT NULL auto_increment,
`rate` tinyint(1) NOT NULL default '0',
`selleruid` mediumint(8) unsigned NOT NULL default '0',
`aid` int(10) unsigned NOT NULL default '0',
`dateline` int(10) unsigned NOT NULL default '0',
`buyuid` mediumint(8) unsigned NOT NULL default '0',
`msg` mediumtext NOT NULL,
`stat` tinyint(1) unsigned NOT NULL default '0',
`rateterm` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`lid`),
KEY `uid` (`selleruid`,`aid`)
) ENGINE=MyISAM;
CREATE TABLE `cdb_auctions` (
`aid` int(10) unsigned NOT NULL auto_increment,
`goods` varchar(255) NOT NULL,
`price` smallint(6) unsigned NOT NULL default '0',
`extcredit` tinyint(1) unsigned NOT NULL default '0',
`uid` mediumint(8) unsigned NOT NULL default '0',
`mode` tinyint(1) unsigned NOT NULL default '0',
`numbers` smallint(6) unsigned NOT NULL default '1',
`term` int(10) unsigned NOT NULL default '0',
`message` mediumtext NOT NULL,
`gmode` tinyint(1) unsigned NOT NULL default '0',
`closed` tinyint(1) unsigned NOT NULL default '0',
`flag` smallint(6) unsigned NOT NULL default '0',
`dateline` int(10) unsigned NOT NULL default '0',
`logs` mediumtext NOT NULL,
PRIMARY KEY (`aid`)
) ENGINE=MyISAM;
=============================================================
卸载:
=============================================================
DROP TABLE IF EXISTS `cdb_auctionlog`;
DROP TABLE IF EXISTS `cdb_auctions`;
网友评论