A5下载程序插件

分类分类

社区拍卖中心插件 for Discuz!7.0

社区拍卖中心插件 for Discuz!7.0

大小:14 KB更新:2010/10/21

类别:Discuz!插件系统:Linux/2003/PHP

立即下载

一 数据库升级

安装:
=============================================================

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`;



 

精品推荐
开发者应用
同类推荐
相关文章
相关下载
说两句网友评论
    我要跟贴
    取消
    推荐专题